| TNS ERROR [message #452420] |
Thu, 22 April 2010 00:20  |
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
|
Member |
|
|
Hi,
I am trying to to connect to a backup database on oracle 11g on a linux box( I have 2 database here) from oracle 10g database on windows system using TNS connection so I can create catalog and register my database.
At a stage in the process it keeps failing and giving me this error:
Connecting...ORA-12560: TNS:protocol adapter error
The test did not succeed.
Some of the information you provided may be incorrect.
Click Back to review the information provided for net service name, or Change Login to change username.
I really need help ASAP so i won't lose my mind cos I've been on this issue for 3 days now!
Here is the content of my TNSNAMES.ORA and LISTERNER.ORA files and other info that my paint a picture of my linux system:
[oracle@marine admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/app/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rmandb.marine)
)
)
DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)
[oracle@marine admin]$ cat listener.ora
# listener.ora Network Configuration File: /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
[oracle@marine admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/app/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
RMANDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rmandb.marine)
)
)
DIMASDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = marine.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dimasdb)
)
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 21-APR-2010 23:11:08
Uptime 0 days 0 hr. 47 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/diag/tnslsnr/marine/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=marine.home)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "dimasdb" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
Service "dimasdbXDB" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
Service "dimasdb_XPT" has 1 instance(s).
Instance "dimasdb", status READY, has 1 handler(s) for this service...
Service "rmandb.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Service "rmandbXDB.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
Service "rmandb_XPT.marine" has 1 instance(s).
Instance "rmandb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@marine ~]$ ps -ef | grep pmon
oracle 14930 1 0 Apr21 ? 00:00:00 ora_pmon_dimasdb
oracle 15036 1 0 Apr21 ? 00:00:00 ora_pmon_rmandb
oracle 16444 16293 0 00:01 pts/1 00:00:00 grep pmon
[oracle@marine ~]$ su -
|
|
|
|
|
|
| Re: TNS ERROR [message #452532 is a reply to message #452420] |
Thu, 22 April 2010 08:30  |
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
|
Member |
|
|
thanks for the advise.
I tried to copy and paste in the session in the box but it did not work so I attached it in word format.
At the end I changed login and replaced it with the rman sys password but it still failed. NEED HELP PLEASE.
Thank you
Panam
|
|
|
|
|
|
| Re: TNS ERROR [message #452545 is a reply to message #452420] |
Thu, 22 April 2010 09:37 |
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
|
Member |
|
|
So sorry about that Michel,
Just new in the business.
I have the whole sessin screen printed on a word document i am trying to paste it to the box but it is not giving me the option of pasting.
Let try and explain the session:
i typed netca on in command promt to launch the configuration assistant.
These are the order of the options I chose in the session:
1.Choose the configuration you would like to do:
I chose Local Net Sersvice Name Configuration
2. Select what you want to do:
I chose Add
3.Service name:
I typed in rmandb.marine (Name of the database on linux machine called marine)
4.Select the protocol used for the database you want to access:
I chose TCP
5.Host Name I chose marine.home (name of machine) and chose 1521 which is the listener port
6. so i run the test and changed loging when it fails the test and put in the system password for rmandb yet it failed.
I have the content of the TNSNAMES.ORA and LISTENER.ORA files in my early posting.
I wish these info is good enough to muster solution. Please help
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
