ORA-12547: TNS: Lost Contact "So for the moment, Error Cabel

[cream3]

Environment Information: Test
* Oracle version: 10G Enterprise
* Operating system: Hed Hat 5

Personal, this is taking nights and evenings and even The moment I could not solve.

In case: I installed Oracle in Red Hat, but at the time of creating the Bank via DBCA I come across the following error:

Select all

ORA-12547: TNS:lost contact

Logener Logener

Select all

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 19-AUG-2010 01:03:57 
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved. 
 
System parameter file is /u01/db/oracle/product/10.2.1/db_1/network/admin/listener.ora 
Log messages written to /u01/db/oracle/product/10.2.1/db_1/network/log/listener.log 
Trace information written to /u01/db/oracle/product/10.2.1/db_1/network/trace/listener.trc 
Trace level is currently 0 
 
Started with pid=5273 
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) 
 
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 
TNS-01201: Listener cannot find executable /u01/db/oracle/product/10.2.1/db_1/bin/orcl for SID orcl (ORACLE_HOME = /u01/db/oracle/product/10.2.0/db_1 
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

SQLNET log:
************** ***

Select all

Fatal NI connect error 12541, connecting to: 
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=LISTENER)(CID=(PROGRAM=java)(HOST=localhost)(USER=oracle)))) 
 
  VERSION INFORMATION: 
        TNS for Linux: Version 10.2.0.1.0 - Production 
        sdp  Time: 19-AUG-2010 01:16:37 
  Tracing not turned on. 
  Tns error struct: 
    ns main err code: 12541 
    TNS-12541: TNS:no listener 
    ns secondary err code: 12560 
    nt main err code: 511 
    TNS-00511: No listener 
    nt secondary err code: 111 
    nt OS err code: 0

Tracert:

Select all

[18-AUG-2010 15:20:54:209] sntpcall: Can't read from pipe; err[1] = 32 
[18-AUG-2010 15:20:54:209] nserror: nsres: id=0, op=65, ns=12547, ns2=12560; nt[0]=517, nt[1]=32, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0 
[18-AUG-2010 15:20:54:210] nsopen: unable to open transport 
[18-AUG-2010 15:20:54:210] nioqper:  error from nscall 
[18-AUG-2010 15:20:54:210] nioqper:    ns main err code: 12547 
[18-AUG-2010 15:20:54:210] nioqper:    ns (2)  err code: 12560 
[18-AUG-2010 15:20:54:210] nioqper:    nt main err code: 517 
[18-AUG-2010 15:20:54:210] nioqper:    nt (2)  err code: 32 
[18-AUG-2010 15:20:54:210] nioqper:    nt OS   err code: 0 
[18-AUG-2010 15:20:54:210] niqme: reporting NS-12547 error as ORA-12547 
[18-AUG-2010 15:20:54:210] niotns: Couldn't connect, returning 12547

Select all

SQLPlus 
 
SQL> connect sys/xxxx as sysdba 
ERROR: 
ORA-12547: TNS:lost contact

Listener:

Select all

LISTENER = 
  (DESCRIPTION_LIST = 
    (DESCRIPTION = 
      (ADDRESS_LIST = 
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
      ) 
     ) 
  ) 
SID_LIST_LISTENER = 
  (SID_LIST = 
    (SID_DESC = 
      (SID_NAME = orcl 
      (ORACLE_HOME = /u01/db/oracle/product/10.2.0/db_1) 
      (PROGRAM = orcl) 
    ) 
    (SID_DESC = 
      (GLOBAL_DBNAME = orcl.word) 
      (ORACLE_HOME = /u01/db/oracle/product/10.2.0/db_1) 
      (SID_NAME = orcl) 
    ) 
  ) 
DEFAULT_SERVICE_LISTENER= (orcl)

. Bash_profile

Select all

# User specific environment and startup programs 
 
PATH=$PATH:$HOME/bin 
 
export PATH 
PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin 
LD_LIBRARY_PATH=/usr/lib:/usr/X11R6/lib 
ORACLE_BASE=/u01/db/oracle 
ORACLE_HOME=$ORACLE_BASE/product/10.2.1/db_1 
ORACLE_SID=orcl 
PATH=$ORACLE_HOME/jdk/jre/lib/i386/server/:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/sbin 
export PATH 
export LD_LIBRARY_PATH 
export ORACLE_BASE ORACLE_HOME ORACLE_SID

Good, this is personal, I tried to pass the maximum of possible information.
I could not climb Listener, much less the bank.

[victorhugomuniz]

ORA-12547: TNS: LOST CONTACT
Cause: Partner Has Unexpectedly Gone Away, Usually During Process Startup.
Action: Investigate Partner Application for Abnormal Termination. On An Interchange, This Can Happen If the Machine is overloaded.

Oracle MOSC Documentation Offers Information on or-12547 Regarding It's Occurrence After Installing 10.1.0.5.0 Patchset. This Information Regards Oracle Enterprise; Version 10.1.0.2 During Attempts to Connect to the database. The Link Fails During Install Seen Below:
- Linking Oracle

Select all

rm -f /oracle/10g1/rdbms/lib/oracle  
cc +DD64 -Wl,+s -Wl,+n +DD64 -o /oracle/10g1/rdbms/lib/oracle -L/oracle/10g1/rdbms/lib/ -L/oracle/10g1/lib/ /oracle/10g1/rdbms/lib/ssoident.o `if /usr/bin/getconf KERNEL_BITS | grep "64" > /dev/null ; \  
then echo "-Wl,+pi,16M -Wl,+pd,L -Wl,+padtext,16M -Wl,+paddata,1M" ; \ 
else echo "" ; fi` -Wl,-E -Wl,-PF,linkorderfile +FPd /oracle/10g1/rdbms/lib/opimai.o /oracle/10g1/rdbms/lib/ssoraed.o /oracle/10g1/rdbms/lib/ttcsoi.o /oracle/10g1/rdbms/lib/defopt.o -Wl,+forceload -lperfsrv10 -Wl,+noforceload /oracle/10g1/lib/nautab.o /oracle/10g1/lib/naeet.o /oracle/10g1/lib/naect.o /oracle/10g1/lib/naedhs.o /oracle/10g1/rdbms/lib/config.o -lserver10 -lodm10 -lnnet10 -lskgxp10 -lhasgen10 -lcore10 -lskgxn2 -locr10 -locrb10 -locrutl10 -lhasgen10 -lcore10 -lskgxn2 -lclient10 -lvsn10 -lcommon10 -lgeneric10 -lknlopt `if /usr/ccs/bin/ar tv /oracle/10g1/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap10" ; fi` -ldm10 -lslax10 -lpls10 -lplp10 -lserver10 -lclient10 -lvsn10 -lcommon10 -lgeneric10 -lknlopt -lslax10 -lpls10 -lplp10 -ljox10 -lserver10 /oracle/10g1/has/lib/libclsra10.a -ldbcfg10 -locijdbcst10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lmm -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /oracle/10g1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `if /usr/ccs/bin/ar tv /oracle/10g1/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo10"; fi` -lctxc10 -lctx10 -lzx10 -lgx10 -lctx10 -lzx10 -lgx10 -lordimt10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lsnls10 -lunls10 -lcore10 -lxml10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /oracle/10g1/lib/sysliblist` -lm `cat /oracle/10g1/lib/sysliblist` -lm  
ld: Can't open the fdp output file linkorderfile  
1 errors.  
*** Error exit code 1 

Note The Error:

Select all

 
------------------ 
 
ld: Can't open the fdp output file linkorderfile  
1 errors.  
*** Error exit code 1 
  
  
 
The cause of ORA-12457 is stated below.  It is also pointed out that ORA-12547 should not be considered a fatal error, but when ORA-12547 is thrown, "the fatal error during link is due to using the incorrect ld executable during install of the patchset. When using the correct ld --> /usr/ccs/bin/ld, the error is not fatal, and link phase completes." 
 
Relinking fails with: 
 
ld: Can't open the fdp output file linkorderfile  
1 errors.  
*** Error exit code 1 
 
This MOSC document on ORA-12547 also offers many different solutions to be able to fully troubleshoot error ORA-12547" 
 
1. Change the Oracle users environment variable PATH to ensure that 'ld' is from /usr/ccs/bin 
 
export PATH=/usr/ccs/bin:${PATH} 
 
2. Verify the following commands return the correct path /usr/ccs/bin 
 
which make 
 
which ar 
 
which as 
 
which ld 
 
3. If you chose to 'ignore' or 'continue' when prompted during the linking of the patchset then you can relink by doing the following: 
 
script relink.log (this captures the relink output to a file) 
 
env|sort 
 
relink all > relink.out 
 
exit (stops the scripting output) 
 
4. Review the relink.log and relink.out for errors 
 
5. If you responded to the linking error prompt with 'stop installation' then reinstall the patchset as noted in the patchset readme file.

[[two]]

[cream3]

Difficult in !!

[cream3]

Someone can help,
I still can not solve problem.
Listener is active, but at the time of creating the Bank via DBCA it causes me this error or-12547
when connecting SQLPlus same thing.

Help !!!.

[elidias7]

Oops!

take a look at the kernel parameters that are configured for RedHAT5 for Oracle installation, review all added values, or review your installation. See also the access permissions to directories where Oracle has been installed, group issues (Overstall, DBA, OPER, OSASM) is also a good one.

of a zooed in the documentation and all this and then post there.

Hugs,