Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> TNSNAMES, LISTENER, ORA-12505, Create New DB problems

TNSNAMES, LISTENER, ORA-12505, Create New DB problems

From: <argosy22_at_my-deja.com>
Date: Wed, 29 Mar 2000 00:44:39 GMT
Message-ID: <8brjlk$9bb$1@nnrp1.deja.com>

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

Listener Parameter File
/apps/oracle/product/734/network/admin/listener.ora Listener Log File
/apps/oracle/product/734/network/log/listener.log Services Summary...
  ltfd1 has 1 service handler(s) The command completed successfully

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US