OraFAQ Forum: Networking and Gateways » Problem in Oracle Networking.

Home » RDBMS Server » Networking and Gateways » Problem in Oracle Networking.

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

Problem in Oracle Networking. [message #226674]

Mon, 26 March 2007 02:56

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

Report message to a moderator

Re: Problem in Oracle Networking. [message #226677 is a reply to message #226674]

Mon, 26 March 2007 03:10

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

Report message to a moderator

Re: Problem in Oracle Networking. [message #226683 is a reply to message #226677]

Mon, 26 March 2007 03:32

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

Report message to a moderator

Re: Problem in Oracle Networking. [message #226691 is a reply to message #226683]

Mon, 26 March 2007 03:52

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 14:39:30 CST 2024