Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> TNSNAMES, LISTENER, ORA-12505, Create New DB problems
HI all,
We are running Oracle 7.3.4 on Sun 5.6.
I have
- created a new database,
- and ran the scripts
catalog
catproc
pupbld.sql
I modified the TNSNAMES.ORA and LISTENER.ORA files to include the new ORACLE_SID.
I stopped and restarted the database.
The batch script includes starting the listener.
ltfd1 - new database ntst1 - old database
Now, on the Unix side, if I do:
export ORACLE_SID=the_sid
and
sqlplus
things works fine.
However, if I try to run everything as one string with either SID:
sqlplus username/password_at_some_SID
I get the error ORA-12505:
SQL*Plus: Release 3.3.4.0.1 - Production on Tue Mar 28 18:54:33 2000 Copyright (c) Oracle Corporation 1979, 1996. All rights reserved. ERROR: ORA-12505: TNS:listener could not resolve SID given in connect descriptor
The really crazy thing is when I tried to access via SQLPLUS for Windows NT.
I used EASYCONFIG to point to the new database. The time stamp for the TNSNAMES.ORA file is 1995, even though the new info is in the file!
And then, after calling sqlplus for windows,
and entering the data in all 3 slots,
I could only connect to the new database!!!
Even though I used to connect to the old database,
I could no longer connect!
The Unix LISTENER.ORA file shows:
# Installation Generated Net V2 Configuration
# Version Date: Sep-16-97
# Filename: Listener.ora
#
#(ADDRESS= (PROTOCOL= IPC)(KEY= ndev1)) LISTENER =
(ADDRESS_LIST = (ADDRESS= (PROTOCOL= TCP)(Host= dev1)(Port= 1521)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)))
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ntst1)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ltfd1)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
Listener info shows:
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=dev1)(Port=1521))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Solaris: Version 2.3.4.0.0 - Production Start Date 28-MAR-00 18:15:43 Uptime 0 days 0 hr. 37 min. 30 sec Trace Level off Security OFF SNMP OFF
LSNRCTL> services
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=dev1)(Port=1521))
Services Summary...
ltfd1 has 1 service handler(s)
DEDICATED SERVER established:2 refused:0
The command completed successfully
It's interesting that there is only 1 service handler, even though when I did this, on the Unix side, I logged onto both databases.
Does anyone have any suggestions?
Thanks,
Argosy
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 28 2000 - 18:44:39 CST