 Problem between listener.ora and tnsnames.ora [message #224553] |
Wed, 14 March 2007 11:51  |
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 #224563 is a reply to message #224560] |
Wed, 14 March 2007 12:14  |
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 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
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 
|
|
|
|
| Re: Problem between listener.ora and tnsnames.ora [message #224569 is a reply to message #224553] |
Wed, 14 March 2007 12:31 |
 |
BlackSwan
Messages: 26766
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 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
