ORA-12547: TNS:lost contact "até o momento, erro cabel

cream3 · Qua, 25 Ago 2010 11:55 am

Informações do Ambiente: Teste
* Versão do Oracle: 10g Enterprise
* Sistema Operacional: hed hat 5

Pessoal, isso está me tirando noites e noites e até o momento não consegui resolver.

Caso: Instalei o oracle no red hat, mas, na hora da criação do banco via dbca me deparo com seguinte erro:

Selecionar tudo

ORA-12547: TNS:lost contact

log listener

Selecionar tudo

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)))

log do sqlnet:
*****************

Selecionar tudo

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:

Selecionar tudo

[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

Selecionar tudo

SQLPlus

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

LISTENER:

Selecionar tudo

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

Selecionar tudo

# 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

Bom, é isso pessoal, tentei passar o maximo de informações possível.
Não consegui subir o listener, muito menos o banco.

Qua, 25 Ago 2010 6:39 pm

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 ORA-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 as seen below:
- Linking Oracle

Selecionar tudo

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:

Selecionar tudo

------------------

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.

http://www.dba-oracle.com/t_ora_12547_t ... ontact.htm

cream3 · Qua, 25 Ago 2010 11:03 pm

dificil em!!

cream3 · Seg, 13 Set 2010 5:25 pm

Pessoal alguém pode ajudar,
ainda não consegui resolver problema.
Listener está ativo, mas, no momento da criação do banco via dbca ele me ocasiona este erro ora-12547
ao conectar sqlplus mesma coisa.

HELP!!!.

elidias7 · Ter, 14 Set 2010 9:07 am

Opa!

De uma olhada nos parametros de kernel que são configurados para o RedHat5 para a instalação do Oracle, reveja todos os valores adicionados, ou seja revise sua instalação. Veja também as permissões de acesso aos diretórios onde o oracle foi instalado, questões dos grupos (oinstall, dba, oper, osasm) também é uma boa.

De uma zoiada na documentação e nisso tudo e depois posta ai.

Abraços,

ORA-12547: TNS:lost contact "até o momento, erro cabel

Quem está online