Home » RDBMS Server » Networking and Gateways » Problem between listener.ora and tnsnames.ora
icon13.gif  Problem between listener.ora and tnsnames.ora [message #224553] Wed, 14 March 2007 11:51 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Hi i have a problem.
Locally i can connect with my db, but i cant remotelly
i readed and used tnsping and tnsctrl status and ill show the results, i cant find an answer, can someone help me with that problem? thnx


%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

oracle@educ-erodriguez:/u01/app/oracle/product/10.1.0/db_1/bin$ ./lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-MAR-2007 10:33:39

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file
is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written
to /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.176)
(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.176)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 14-MAR-2007 10:33:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter
File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log
File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.176)(PORT=1521)))
Services Summary...
Service "oracle" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
oracle@educ-erodriguez:/u01/app/oracle/product/10.1.0/db_1/bin$ ./tnsping
10.0.0.176

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-MAR-2007
10:34:13

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.1.0/db_1/network/admin/sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.0.0.176))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.176)(PORT=1521)))
OK (10 msec)
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
este es el listener.ora
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP) (HOST = 10.0.0.176) (PORT = 1521)))

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
(SID_NAME = oracle)))
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
y este es el tnsnames.ora
oracle.world=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL= TCP) (HOST= 10.0.0.176 )(PORT = 1521))))
(CONNECT_DATA = (SID= oracle) (SERVER=DEDICATED))
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Re: Problem between listener.ora and tnsnames.ora [message #224560 is a reply to message #224553] Wed, 14 March 2007 12:11 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
Those are nice files.
Are we supposed to guess at what you are actually doing & how Oracle is responding?
Below is the equivalent of what you have posted.
My car won't go.
I have filled my gas tank.
Tell me how to make my car go.
==================================
PLEASE cut & paste completely & EXACTLY what you've done & how Oracle has responded.
Re: Problem between listener.ora and tnsnames.ora [message #224563 is a reply to message #224560] Wed, 14 March 2007 12:14 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

anacedent wrote on Wed, 14 March 2007 12:11
Those are nice files.
Are we supposed to guess at what you are actually doing & how Oracle is responding?
Below is the equivalent of what you have posted.
My car won't go.
I have filled my gas tank.
Tell me how to make my car go.
==================================
PLEASE cut & paste completely & EXACTLY what you've done & how Oracle has responded.



i used vi to create my own configuration files (using examples of another working databases)
and i used tnsping and tnsctrl status, and i put the result of that two sentences ill put again to you Wink
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

oracle@educ-erodriguez:/u01/app/oracle/product/10.1.0/db_1/bin$ ./lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-MAR-2007 10:33:39

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file
is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written
to /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.176)
(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.176)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 14-MAR-2007 10:33:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter
File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log
File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.176)(PORT=1521)))
Services Summary...
Service "oracle" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
oracle@educ-erodriguez:/u01/app/oracle/product/10.1.0/db_1/bin$ ./tnsping
10.0.0.176

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 14-MAR-2007
10:34:13

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.1.0/db_1/network/admin/sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.0.0.176))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.176)(PORT=1521)))
OK (10 msec)


thnx for your answer Very Happy
Re: Problem between listener.ora and tnsnames.ora [message #224569 is a reply to message #224553] Wed, 14 March 2007 12:31 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
You are a slow learner.
>Locally i can connect with my db, but i cant remotelly
Without any error messages/codes, You're On Your Own (YOYO)!


12533, 00000, "TNS:illegal ADDRESS parameters"
// *Cause: An illegal set of protocol adapter parameters was specified. In
// some cases, this error is returned when a connection cannot be made to the
// protocol transport.
// *Action: Verify that the destination can be reached using the specified
// protocol. Check the parameters within the ADDRESS section of
// TNSNAMES.ORA. Legal ADDRESS parameter formats may be found in the
// Oracle operating system specific documentation for your platform.
// Protocols that resolve names at the transport layer (such as DECnet object
// names) are vulnerable to this error if not properly configured or names are
// misspelled.

[Updated on: Wed, 14 March 2007 12:34] by Moderator

Report message to a moderator

Re: Problem between listener.ora and tnsnames.ora [message #224622 is a reply to message #224569] Wed, 14 March 2007 15:40 Go to previous message
thorin666
Messages: 144
Registered: March 2007
Senior Member

ok my problem is that
when i try to connect locally using @something
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
but if i don't use @ the connection works fine

In the client machine, i can use @without problem
it is ok? or why i can't use @ locally?
Previous Topic: TNS-12533: TNS:illegal ADDRESS parameters
Next Topic: tns-12535 tns:operation time out
Goto Forum:
  


Current Time: Wed Dec 07 09:02:58 CST 2016

Total time taken to generate the page: 0.13233 seconds