Month: November 2020

How I fixed a Linux user login issue

Although I spend a lot of time on Linux system on my daily work, my main focus is on application side. Yesterday a colleague brought a user login issue to me: he's been working on a secured Oracle Linux server and all of sudden he could not login into the system with his service user … Continue reading How I fixed a Linux user login issue

Advertisement

ORA-16624: broker protocol version mismatch detected

I did an Oracle rolling upgrade for an Oracle DataGuard environment last week and ran into the following error when doing a switchover from one server PROD2 (Oracle SID) to another server PROD1 (Oracle SID) after the upgrade: ORA-16624: broker protocol version mismatch detected This was an interesting problem which was caused by a small … Continue reading ORA-16624: broker protocol version mismatch detected

Dynamic Service Registration with IPC protocol?

Oracle database services can be registered dynamically to the listener, which then acts as a port mapper for those services. The listener uses the dynamic service information about the database and instance received through service registration. From Oracle Database Net Services Administrator's Guide, "Dynamic service registration is configured in the database initialization file. It does … Continue reading Dynamic Service Registration with IPC protocol?

How does systemd maintain the compatibility with SystemV init scripts?

systemd is a system and service manager for Linux operating systems. When a systemd Linux system starts, systemd runs as first process on boot (as PID 1), and it acts as init system that brings up and maintains userspace services. systemd uses "units" (12 different types) to manage services related to system boot-up and maintenance. … Continue reading How does systemd maintain the compatibility with SystemV init scripts?

Oracle 19c — ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Before Oracle 19c, we can connect to the database as the user "sys" without giving "as sysdba" if the parameter O7_DICTIONARY_ACCESS is set to TRUE. If this parameter is set to FALSE, you won't connect to the database as the user "sys" without giving "as sysdba". You will get the ORA-280009 if you do so. … Continue reading Oracle 19c — ORA-28009: connection as SYS should be as SYSDBA or SYSOPER