OraFAQ Forum: Portuguese » Erro acessar o banco

Home » Non-English Forums » Portuguese » Erro acessar o banco (Oracle 10g, CentOS 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Erro acessar o banco [message #418590]

Mon, 17 August 2009 09:45

leosantoss
Messages: 8
Registered: August 2009

Junior Member

Olá pessoal, estou com o seguinte problema ao acessar o banco.

ORA-12541: TNS:no listener.

Estou com o banco oracle 10G R2 em uma maquina virtual com CentOs 5.3.

Assim que terminei a instalação consegui acesso normalmente, porém após reiniciar a maquina não consigo mas logar pois ocorre o erro acima.

Desde já grato.

att,
Leonardo

Report message to a moderator

Re: Erro acessar o banco [message #418592 is a reply to message #418590]

Mon, 17 August 2009 09:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from following commands when run on DB server system as user oracle

env | sort
lnsrctl start

Report message to a moderator

Re: Erro acessar o banco [message #418593 is a reply to message #418592]

Mon, 17 August 2009 10:09

leosantoss
Messages: 8
Registered: August 2009

Junior Member

env | sort

COLORTERM=gnome-terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-NiY4WiCdm9,guid=b4664f6e90cecfb5df2198004a8966fe
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-jSGK94/socket
GTK_RC_FILES=/etc/gtk/gtkrc:/home/suporte/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=dbdetran.localdomain
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_IS_PRELINKED=1
KDE_NO_IPV6=1
LANG=pt_BR.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/suporte
OLDPWD=/home/suporte
ORACLE_BASE=/mnt/banco/u01/app/oracle
ORACLE_HOME=/mnt/banco/u01/app/oracle/product/10.2.0/db_1
ORACLE_SID=detran
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/suporte/bin
PWD=/mnt/banco/u01/app/oracle/product/10.2.0/db_1/bin
SESSION_MANAGER=local/dbdetran.localdomain:/tmp/.ICE-unix/3118
SHELL=/bin/bash
SHLVL=3
SSH_AGENT_PID=3154
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-ZNncEP3118/agent.3118
TERM=xterm
USERNAME=suporte
USER=oracle
_=/usr/bin/env
WINDOWID=48234577
XAUTHORITY=/home/oracle/.xauthANj05J
XMODIFIERS=@im=none

lnsrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-AUG-2009 12:01:15

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /mnt/banco/u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 17-AUG-2009 12:01:15
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Report message to a moderator

Re: Erro acessar o banco [message #418596 is a reply to message #418593]

Mon, 17 August 2009 10:27

leosantoss
Messages: 8
Registered: August 2009

Junior Member

Este e o erro que da quando tento logar.

[oracle@dbdetran bin]$ ./sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 17 12:24:06 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system@detran
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

Report message to a moderator

Re: Erro acessar o banco [message #418597 is a reply to message #418596]

Mon, 17 August 2009 10:29

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

The database is not started.

Report message to a moderator

Re: Erro acessar o banco [message #418598 is a reply to message #418590]

Mon, 17 August 2009 10:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from following commands

lsnrctl service
cat /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
tail -40 /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Report message to a moderator

Re: Erro acessar o banco [message #418599 is a reply to message #418598]

Mon, 17 August 2009 10:44

leosantoss
Messages: 8
Registered: August 2009

Junior Member

[root@dbdetran bin]# tail -40 /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
17-AUG-2009 11:09:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
WARNING: Subscription for node down event still pending
17-AUG-2009 11:09:37 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
WARNING: Subscription for node down event still pending
17-AUG-2009 11:09:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
WARNING: Subscription for node down event still pending
17-AUG-2009 11:09:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
17-AUG-2009 11:11:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=detran)(CID=(PROGRAM=sqlplus)(HOST=dbdetran.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=36050)) * establish * detran * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbdetran.localdomain)(PORT=1521)))
Listener completed notification to CRS on stop
17-AUG-2009 11:13:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=16986956 8)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 17-AUG-2009 12:01:15

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Trace information written to /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/trace/listener.trc
Trace level is currently 0

Started with pid=3553
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
17-AUG-2009 12:01:15 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dbdetran.localdomain)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869 568)) * status * 0
17-AUG-2009 12:24:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=detran)(CID=(PROGRAM=sqlplus)(HOST=dbdetran.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=3878)) * establish * detran * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
17-AUG-2009 12:34:13 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=detran)(CID=(PROGRAM=sqlplus)(HOST=dbdetran.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=43733)) * establish * detran * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
17-AUG-2009 12:34:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=detran)(CID=(PROGRAM=sqlplus)(HOST=dbdetran.localdomain)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.142)(PORT=43740)) * establish * detran * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Report message to a moderator

Re: Erro acessar o banco [message #418600 is a reply to message #418599]

Mon, 17 August 2009 10:44

leosantoss
Messages: 8
Registered: August 2009

Junior Member

cat /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# listener.ora Network Configuration File: /mnt/banco/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /mnt/banco/u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.142)(PORT = 1521))
)
)

Report message to a moderator

Re: Erro acessar o banco [message #418601 is a reply to message #418600]

Mon, 17 August 2009 10:45

leosantoss
Messages: 8
Registered: August 2009

Junior Member

[root@dbdetran bin]# ./lsnrctl service

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-AUG-2009 12:42:17

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
Linux Error: 111: Connection refused

Report message to a moderator

Re: Erro acessar o banco [message #418602 is a reply to message #418601]

Mon, 17 August 2009 10:49

leosantoss
Messages: 8
Registered: August 2009

Junior Member

Senhores.
Ao executar o start do banco ocorreu as seguinte mensagens.

Failed to auto-start Oracle Net Listene using /ade/vikrkuma_new/oracle/bin/tnslsnr
Processing Database instance "detran": log file /mnt/banco/u01/app/oracle/product/10.2.0/db_1/startup.log

e aqui a baixo e o arquivo de log

./dbstart: Starting up database "detran"
Seg Ago 17 12:37:57 BRT 2009

logger: Warning: Database instance "detran" already started.
logger: Warning: Database instance "detran" possibly left running when system went down (system crash?).
logger: Action: Notify Database Administrator.

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 17 12:37:57 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> Connected.
SQL> ORACLE instance shut down.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 17 12:37:57 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> Connected to an idle instance.
SQL> ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

./dbstart: Database instance "detran" warm started.

Report message to a moderator

Re: Erro acessar o banco [message #418741 is a reply to message #418602]

Tue, 18 August 2009 07:45

leosantoss
Messages: 8
Registered: August 2009

Junior Member

./sqlplus /nolog
conn / as sysdba

Com esses comando acima eu consigo logar, porém com o usuário e senha que foi criado na hora da instalação não consigo, ocorre o erro

ORA-12514: TNS:listener does not currently know of service requested in connnect descriptor

Report message to a moderator