I was having a problem after migrating my Database from 11.2.0.4 to 19c using dbua.
The migration process using dbua is smooth and successful except for migrating the TNS listener. I finally migrate the database without the listener and aims to create another listener after the migration.
I followed the instructions in "Net Configuration Assistant" to create a listener with the default port (1521). The listener is created successfully.
When I tried to start the newly created listener service, the following error is shown in the log,
Error listening on: (ADDRESS=(PROTOCOL=ipc))
TNS-01191: Failed to initialize the local OS authentication subsystem
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable
I did some research about the error TNS-01191 and I had already updated the environment variables "PATH" with the new Oracle home bin directory.
May I know if anyone had installed Oracle 19c on Windows 7 and configured the TNS listener successfully?
FYI, the tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
The listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENERFORSD =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = <ORACLE_HOME_MASKING>)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:<ORACLE_HOME_MASKING>\bin\oraclr19.dll")
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = <ORACLE_HOME_MASKING>)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:<ORACLE_HOME_MASKING>\bin\oraclr19.dll")
)
)
<LISTENER_NAME_MASKING> =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME_MASKING>)(PORT = 1521))
)
)
Best Answer
Windows 7 is not a supported operating system for Oracle 19c.
The documentation states that it is only supported for these versions of Windows:
Even if you are able to get the listener functioning, you will likely recieve other errors with normal database usage that will just cause more headaches in the future which is why it is very strongly NOT RECOMMENDED to install Oracle on an unsupported operating system.