All we need is an easy explanation of the problem, so here it is.
I was having a problem after migrating my Database from 22.214.171.124 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) ) )
# 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)) ) )
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Windows 7 is not a supported operating system for Oracle 19c.
The documentation states that it is only supported for these versions of Windows:
Windows 8.1 x64 – Pro and Enterprise editions
Windows 10 x64 – Pro, Enterprise, and Education editions
Windows Server 2012 R2 x64 – Standard, Datacenter, Essentials, and
Windows Server 2016 x64 – Standard, Datacenter, and Essentials
Windows Server 2019 x64 – Standard, Datacenter, and Essentials
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.
Windows 7 is not a supported operating system, period.
Ditch it and re-install this on a current, "server" flavour of Windows.
(Showing my age, here, but …)
The sleeve notes from the original "Tubular Bells" album seems oddly relevant here:
In Glorious Stereophonic Sound: Can also be played on mono equipment at a pinch.
This stereo record cannot be played on old tin boxes no matter what they are fitted with. If you are in possession of such equipment please hand it into the nearest police station.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂