Oracle Names
Orlando Reyes, April 24, 2001 - 2:40 pm UTC
These are the little things that help you to get the job done, but without them your life can be misserable for a while.
Thanks for the help.
A reader, October 24, 2002 - 7:15 am UTC
Hi tom,
I want to configure my database like this ..Say database DB1 server is located at location L1..I want to make the connection to the DB1 from another location which is located at L2 .,there is no database sitting at L2 .. but group of clients sitting over and has to run the VB application by connecting to DB1 .
I thought setting the oracle names server will help .. I started creating the oracle
Names service while starting I am getting the following error .
--------------------
NAMESCTL> start
Starting "names.exe"...Failed to start service, error 2.
server not started, errors follow
TNS-12536: TNS:operation would block
TNS-12560: TNS:protocol adapter error
TNS-00506: Operation would block
32-bit Windows Error: 997: Unknown error
----------------------
Can you please tell me how to come over from this problem ., Also give me the
solution to my problem.
Thanks
Ravi
October 24, 2002 - 2:16 pm UTC
Problem Description:
====================
When using a GUI Net tool (or command line) to start a newly configured
names server, An error message appears with the following contents:
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocl adapter error
32-bit Windows Error: 61: Unknown error
(Later releases of Oracle include a "TNS-12536: TNS:operation would block" error
and may report the 32-bit Windows Error as "997: Unknown error".
On Unix, this error is reported as:
"$ORACLE_HOME/bin/names" does not exist
SNL-00044: snlfacc: file or path name does not exist
Solution Description:
=====================
Install Oracle Names from the 8i or 9i install CD-ROM
Solution Description:
=====================
Re-run the Oracle Installer.
1) Select "Oracle Enterprise Edition" as the product to install.
2) Select "Custom" as the installation type.
3) Make sure "Oracle Names" is selected.
4) Continue with install.
Explanation:
============
The names executable is not installed using the default installation of
Oracle 8i or Oracle 9i.
ORA-12637: Packet receive failed
Zahid Kareem, June 05, 2006 - 3:46 am UTC
Tom,
i have configured my database to user Oracle Names Server. Every thing is ok.
The Names Server is up and running.
The Listener is registered with the Nameserver.
I can use TNSPING successfully with the names server.
But when i connect from sqlplus using the nameserver as the connect string e.g. scott/tiger@oranamsrvr1 it gives me "ORA-12637: Packet receive failed".
Please help me.
Thanx
June 05, 2006 - 7:50 am UTC
please utilize support for installation/configuration issues.
TNS-00530: Protocol adapter error
ch, September 19, 2006 - 2:18 am UTC
17-SEP-2006 16:02:34 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=s234005nj2ss02)(USER=o
racle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=153093376))
* st
atus * 0
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort
17-SEP-2006 16:03:16 * 12560
TNS-12502: TNS:listener received no CONNECT_DATA from client
*TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort*
17-SEP-2006 16:03:21 * 12560
*TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort*
17-SEP-2006 16:03:25 * service_update * svtra1 * 0
17-SEP-2006 16:03:26 * service_update * svtra1 * 0
17-SEP-2006 16:03:25 * service_update * svtra2 * 0
17-SEP-2006 16:03:26 * service_update * svtra2 * 0
17-SEP-2006 16:03:26 * 12502
17-SEP-2006 16:03:26 * 12560
TNS-12502: TNS:listener received no CONNECT_DATA from client
*TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Solaris Error: 130: Software caused connection abort*
17-SEP-2006 16:03:27 * 12502
$ grep -i listener initsvtra1.ora
*.local_listener='LISTENER_SVTRA'
svtra2.local_listener='LISTENER_SVTRA2'
svtra1.local_listener='LISTENER_SVTRA1'
*.remote_listener='LISTENERS_SVTRA'
Or
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_SVTRA1
mts_listener_address string
mts_multiple_listeners boolean FALSE
remote_listener string LISTENERS_SVTRA
SQL>
Tom,
It is 9.2.0.5 RAC with 2 node cluster. can you please suggest something why is it happening? It is causing application down for 40 seconds.
September 19, 2006 - 2:27 pm UTC
please use support, they can collect necessary data (that I'm not really going to - like your listener configuration and such)...
more details
ch, September 19, 2006 - 3:13 am UTC
SQL> show parameter mts
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
mts_circuits integer 445
mts_dispatchers string (PROTOCOL=TCP) (SERVICE=svtraXDB)
mts_listener_address string
mts_max_dispatchers integer 5
mts_max_servers integer 20
mts_multiple_listeners boolean FALSE
mts_servers integer 1
mts_service string svtra
mts_sessions integer 440
SQL>
select * from v$dispatcher
NAME NETWORK PADDR STATUS ACC MESSAGES BYTES BREAKS OWNED CREATED IDLE BUSY LISTENER CONF_INDX
---- -------------------------------------------------- ---------------- ---------------- --- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
D000 (ADDRESS=(PROTOCOL=tcp)(HOST=s234005nj2ss02)(PORT= 00000004295DB5D0 WAIT YES 0 0 0 0 0 43785958 0 0 0
57748))
SQL> SELECT * FROM V$QUEUE ;
PADDR TYPE QUEUED WAIT TOTALQ
---------------- ---------- ---------- ---------- ----------
00 COMMON 0 0 0
00000004295DB5D0 DISPATCHER 0 0 0