Home » RDBMS Server » Networking and Gateways » Problem in Oracle Networking.
Problem in Oracle Networking. [message #226674] Mon, 26 March 2007 02:56 Go to next message
amit_raj
Messages: 2
Registered: March 2007
Location: Hyderabad
Junior Member

Hi,

I have configured listerner.ora and tnsnames.ora for my database instance on the Solaris Server.

I started the listener successfully and I am also able to ping it using the "tnsping" command.

But on executing the followin command,

LSNRCTL> show trc_directory

I got the following error:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcssun03.satyam.com)(PORT=1527)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused


Can anyone please tell me the root of the problem and the possible solutions.

Thanks
Amit
Re: Problem in Oracle Networking. [message #226677 is a reply to message #226674] Mon, 26 March 2007 03:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcssun03.satyam.com)(PORT=1527)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused


1.check oracle service is start
2.database registration is DYNAMIC or STATIC... if dynamic then change STATIC.
3.after edit listner.ora file stop listener service and wait few minus then start ...

let us know result

regards
Taj
Re: Problem in Oracle Networking. [message #226683 is a reply to message #226677] Mon, 26 March 2007 03:32 Go to previous messageGo to next message
amit_raj
Messages: 2
Registered: March 2007
Location: Hyderabad
Junior Member

Hi Taj,

Thanks for replying.

The port number my listener is listening to is 4007 and not 1527 which was shown in the error.

Several users are using the same listener configuratin file for their instaces with port number 1527.
I am able to connect to the database using

sqlplus "system/manager@ORCDBTNS"


Is the port number causing the problem?

Regards
Amit


Re: Problem in Oracle Networking. [message #226691 is a reply to message #226683] Mon, 26 March 2007 03:52 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Is the port number causing the problem?
May be Yes...


regards
Taj

Previous Topic: changing ip address of server which has oracle installed
Next Topic: How to Connect to Oracle
Goto Forum:
  


Current Time: Thu Dec 08 14:12:31 CST 2016

Total time taken to generate the page: 0.05471 seconds