| 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
|
|
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
|
|
|
|
| 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
|
|
|
|
| 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))
)
)
|
|
|
|
| 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
|
|
|
|
| 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.
|
|
|
|
| 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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
