OraFAQ Forum: Linux » Connection Error 12541

Home » Infrastructure » Linux » Connection Error 12541

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

Connection Error 12541 [message #219001]

Mon, 12 February 2007 08:41

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

Good morning
I have a problem connecting to my db with a client, the error that I obtain is 12514.

From aix server where is present the db, I check the listener.ora and tnsnames.ora but they seems ok.

I tried also to restart the listener with lsnrctl, the command work fine, but the problem remain.

The tnsping command is ok.

Until yesterday all worked fine, and there dont' should change anything.

Someone can help me or make a suggestion?
thans in advance

Report message to a moderator

Re: Connection Error 12541 [message #219026 is a reply to message #219001]

Mon, 12 February 2007 10:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Can you post here complete error with your TNSNAMES.ORA or LISTENER.ORA file.
and what is your database status ?

because "tns-12514" error happen due to couple of reasons.
regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219122 is a reply to message #219026]

Tue, 13 February 2007 01:32

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

Hello Taj, thanks for replay

The database is mounted at the moment and yesterday evening after retry to restart the listener with lsnrctl another time the code error on the client is changed in "Connection error: 000012203".
This is strange because I had already tried to restart the listener. The name of db that I can't reach is OAS93 and OAS94

Attached you can see the listener.ora, in the next post I attached the tnsnames.ora.

Attachment: listener.ora
(Size: 2.16KB, Downloaded 1771 times)

Report message to a moderator

Re: Connection Error 12541 [message #219123 is a reply to message #219122]

Tue, 13 February 2007 01:33

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

The tnsnames.ora file attached.

Thanks in advance for your help.

Attachment: tnsnames.ora
(Size: 0.57KB, Downloaded 1749 times)

Report message to a moderator

Re: Connection Error 12541 [message #219124 is a reply to message #219123]

Tue, 13 February 2007 01:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
ORA-12203: TNS:unabel to connect to destination

for above error check your computer network connect from client to server is ok.
ping server_ip_address

or check firewall is disable on server.

I cann't open your attacted file please post your both file output here.

regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219126 is a reply to message #219001]

Tue, 13 February 2007 01:50

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

The ping reply, the firewall is disabled.

From my client I connetct to server with terminal or ftp without problem.

This is the tnsnames.ora:

OAS94.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1594))
)
(CONNECT_DATA =
(SID = OAS94)
)
)

OAS93.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OAS93)
)
)

OAS91.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1521))
)
(CONNECT_DATA =
(SID = OAS91)
)
)

This is the listener.ora

#name......: listener.ora
# Name..........: rs98edp.np.ge.com lsn_98. Listener Generico
# Date..........: 31-MAR-99 15:22:48
################
SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_lsn98 = OFF
USE_CKPFILE_lsn98 = OFF
STARTUP_WAIT_TIME_lsn98 = 0
CONNECT_TIMEOUT_lsn98 = 10
TRACE_LEVEL_lsn98 = OFF
LOG_DIRECTORY_lsn98 = /u18/app/oracle/network/log
LOG_FILE_lsn98 = lsn98
TRACE_DIRECTORY_lsn98 = /u18/app/oracle/network/trace

lsn98 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs98edp)(PORT = 1810))
(ADDRESS=
(PROTOCOL=IPC)
(KEY= OAS91.np.ge.com)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= OAS91)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= OAS93.np.ge.com)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= OAS93)
)
)
)
)

SID_LIST_lsn98 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = OAS91.np.ge.com)
(ORACLE_HOME = /u18/app/oracle/product/8.1.7)
(SID_NAME = OAS91)
)
(SID_DESC =
(GLOBAL_DBNAME = OAS93.np.ge.com)
(ORACLE_HOME = /u18/app/oracle/product/8.1.7)
(SID_NAME = OAS93)
)
)

# LISTENER.ORA Network Configuration File: /u18/app/oracle/product/9.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
################################ OAS04 Instance #################################

SID_LIST_OAS94 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = OAS94.np.ge.com)
(ORACLE_HOME = /u18/app/oracle/product/9.2.0)
(SID_NAME = OAS94)
)
)

OAS94 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs98edp)(PORT = 1594))
)
)
)

SID_LIST_OAS93 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = OAS93.np.ge.com)
(ORACLE_HOME = /u18/app/oracle/product/9.2.0)
(SID_NAME = OAS93)
)
)

OAS93 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rs98edp)(PORT = 1594))
)
)
)

Thank you

Report message to a moderator

Re: Connection Error 12541 [message #219132 is a reply to message #219126]

Tue, 13 February 2007 02:29

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
sid

REPLACE sid with SERVICE_NAME in TNSNAMES.ORA file.

Is your TNSNAMES.ORA file is from CLIENT MACHINE. ?

regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219135 is a reply to message #219132]

Tue, 13 February 2007 02:40

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

This is the tnsnames on the server.
I tried to replace sid with SERVICE_NAME, but the problem remain the same.

now the tnsnames.ora is:

OAS94.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1594))
)
(CONNECT_DATA =
(SERVICE_NAME = OAS94)
)
)

OAS93.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OAS93)
)
)

OAS91.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = OAS91)
)
)

Report message to a moderator

Re: Connection Error 12541 [message #219136 is a reply to message #219135]

Tue, 13 February 2007 02:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Are database services is start which you try to connect ?

or
post exact output of your error.

regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219153 is a reply to message #219136]

Tue, 13 February 2007 03:11

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

I try to explain better.

1. I have the mainly database OAS93 on the aix server and I connect it from some clients that has a terminal installed (and no oracle installation, so no tnsnames on the client).
When I run the terminal I obtain the error:
connection error: 000012203

Until last Sunday all worked fine.

2. The database OAS94 is another on the aix server and I connect it from a client that has oracle 9, installed, this is the tnsnames.ora on the client.

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora9i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

OAS94.np.ge.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.224.3.6)(PORT = 1594))
)
(CONNECT_DATA =
(SID = OAS94)
)
)

When I tried to run the application the error is:
20105 - connection error: 40002
20029 - verify the password
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

The password is surely correct.
If I tried to test the connection from ODBC source I obtain this error:
Unable to connect
SQLState=S1000
[Oracle][ODBC][Ora]ORA-12505: TNS: listener cannot resolve SID in the connection description

-----

The Db are running, yesterday morning I tried to stop the listener and shutdown the db. After I restarted the db and listener, but the problem remained.

Thank you

Report message to a moderator

Re: Connection Error 12541 [message #219162 is a reply to message #219153]

Tue, 13 February 2007 07:45

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

ORA-12505: TNS: listener cannot resolve SID in the connection description

after change SID to SERVICE_NAME are you RESTART your listener SERVICES.

it is your problem go through below link...

http://dbataj.blogspot.com/2007/02/ora-12505.html

regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219170 is a reply to message #219162]

Tue, 13 February 2007 08:26

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

I tried to restart listener, but now the error is
ORA-12505: TNS:listener does not currently know of SERVICE_NAME given in connect descriptor

I'm not able to understand why...

Report message to a moderator

Re: Connection Error 12541 [message #219206 is a reply to message #219001]

Tue, 13 February 2007 10:11

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

After change again the tnsnames.ora with old tnsnames (that yesterday doesn't work!) now the application on database OAS94 works!

But the other application on OAS93 now obtains the error code: connection error: 000012514

Why now the OAS94 works, while OAS93 no?
Apparently anything don't should be changed.

Report message to a moderator

Re: Connection Error 12541 [message #219211 is a reply to message #219206]

Tue, 13 February 2007 10:20

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Actually Ora-12514 error due to couple of reason.
there is no one place to look out.

Those are some reason of Ora-12514.

1.Oracle Database Services is not started.
2.During connect through SYS user.because of LISTENER configure is DYNAMIC instead of STATIC.
3.When SQLNET.ORA file is missing.
4.SID is not register in listener services.
5.Wrong TNSNAMES.ORA file is point.

regards
Taj

Report message to a moderator

Re: Connection Error 12541 [message #219235 is a reply to message #219211]

Tue, 13 February 2007 11:22

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

1.Oracle Database Services is not started.
2.During connect through SYS user.because of LISTENER configure is DYNAMIC instead of STATIC.
3.When SQLNET.ORA file is missing.
4.SID is not register in listener services.
5.Wrong TNSNAMES.ORA file is point.

--------------
Thank you Taj, but my limited knowledge on this topic don't allow me to reply to all your points...

1. I don't how to check this
2. I don't how to check this
3. sqlnet.ora is present
4. if I run lsnrctl and then services I obtain "The listener supports no services" (if I undertando what you mean)
5. How can i check this? This is possible because I see that on the server there is three oracle installation

Thanks again

Report message to a moderator

Re: Connection Error 12541 [message #219280 is a reply to message #219001]

Tue, 13 February 2007 15:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

12541, 00000, "TNS:no listener"
// *Cause: The connection request could not be completed because the listener
// is not running.
// *Action: Ensure that the supplied destination address matches one of
// the addresses used by the listener - compare the TNSNAMES.ORA entry with
// the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
// go by way of an Interchange). Start the listener on the remote machine.

post output from run from box to which you can not connect
$ lsnrctl status

Report message to a moderator

Re: Connection Error 12541 [message #219380 is a reply to message #219001]

Wed, 14 February 2007 03:42

dgitalia
Messages: 10
Registered: February 2007
Location: Italy

Junior Member

This is the output of listener restart and listener status:

LSNRCTL> start
Starting /u18/app/oracle/product/8.0.6/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.0 - Production
System parameter file is /u18/app/oracle/network/listener.ora
Log messages written to /u18/app/oracle/product/8.0.6/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=10)(HOST=10.224.3.6)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.
Start Date 14-FEB-2007 10:23:51
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u18/app/oracle/network/listener.ora
Listener Log File /u18/app/oracle/product/8.0.6/network/log/listener.log
The listener supports no services
The command completed successfully

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 8.0.6.3.
Start Date 14-FEB-2007 10:23:51
Uptime 0 days 0 hr. 0 min. 14 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u18/app/oracle/network/listener.ora
Listener Log File /u18/app/oracle/product/8.0.6/network/log/listener.log
The listener supports no services
The command completed successfully

This is the error that I obtain try to connect to OAS03 Db from odbc sources:

Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]ORA-12154: TNS: could not resolve service name

Report message to a moderator

Previous Topic:	how to set cronjob? how can i say my OS to do coldbackup every day at 9pm
Next Topic:	256 Bit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 16:11:51 CDT 2024