 Posted 4/19/2009 10:33:50 AM
|
|
|
|
| I'm getting the following after upgrading and then having to back out of the upgrade when connecting to the db from the application user that resides on the same server as the database. DB: 10.2.0.3.0 OS: AIX 3.5 *********************************************************************** Fatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/oracle/10.2/bin/oracle)(ARGV0=oraclemarchm52)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(ROGRAM=admin@prodsrv)(HOST=prodsrv)(USER=admin">PROGRAM=admin@prodsrv)(HOST=prodsrv)(USER=admin)))) VERSION INFORMATION: TNS for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production Time: 19-APR-2009 04:45:47 Tracing not turned on. Tns error struct: ns main err code: 12547 TNS-12547: TNS:lost contact ns secondary err code: 12560 nt main err code: 517 TNS-00517: Lost contact nt secondary err code: 32 nt OS err code: 0 ***********************************************************************The way this was resolved was by shutting down all applications, databases, and listeners. Then did a relink all. After that, we started up all the databases, listener, and then the application and it was ok after wards. Hope this helps.
|
|
|
|