All,
I have installed 8.1.7 in a separate Oracle Home on our AIX 4.3.3 server,
which already has Oracle 8.1.6 installed.
I made sure that the 8.1.6 listener was not running during the minimal
installation of Oracle8i Enterprise Edition.
TNS_ADMIN, ORACLE_HOME and ORACLE_BASE were all pointing to the correct new
locations prior to and during the installation process.
The default listener of "listener" on port 1521 for the 8.1.7 environment
does not start.
We have tried relinking, deinstalling NET8, reinstalling NET8, deinstalling
817, reinstalling 817 to no avail.
I have also tried this on 8.1.7.1.0.
We have also tried copying the listener.ora and tnsnames.ora from the 816 to
817 TNS_ADMIN directory.
The following is the result of lsnrctl start in the 816 environment which
works:
TNSLSNR for IBM/AIX RISC System/6000: Version
8.1.6.0.0 - Production
System parameter file is
/u01/app/oracle/product/8.1.6/network/admin/listener.ora
Log messages written to
/u01/app/oracle/product/8.1.6/network/log/listener.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.16.14.55)(PORT=1521)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.16.14.55)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC
System/6000: Version 8.1.6.0.0 - Production
Start Date 31-MAY-2001 09:04:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File
/u01/app/oracle/product/8.1.6/network/admin/listener.ora
Listener Log File
/u01/app/oracle/product/8.1.6/network/log/listener.log
Services Summary...
817 has 1 service handler(s)
ORCL has 1 service handler(s)
PLSExtProc has 1 service handler(s)
R20 has 1 service handler(s)
R21 has 1 service handler(s)
TR1 has 1 service handler(s)
TR2 has 1 service handler(s)
TR3 has 1 service handler(s)
The command completed successfully
The following is an extract from the lsnrctl start in the 817 environment
(making sure the 816 listener is not running) and the TNS_ADMIN and
ORACLE_HOME are properly set:
TNSLSNR for IBM/AIX RISC System/6000: Version
8.1.7.1.0 - Production
System parameter file is
/u32/app/oracle/product/817/network/admin/listener.ora
Log messages written to
/u32/app/oracle/product/817/network/log/listener.log
Attempted to listen on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.16.14.55)(PORT=1521)))
TNS-12538: TNS:no such protocol adapter
TNS-12560: TNS:protocol adapter error
TNS-00508: No such protocol adapter
Has anyone else experienced and got over the same problem?
Thanks in advance
Juliette
Cap Gemini Ernst & Young
Mailto: juliette.[Email Address Removed]Oracle LazyDBA home page