Re: Oracle newbie question

From: tae sik <tshan_at_kofex.com>
Date: Wed, 15 Apr 1998 13:44:01 +0900
Message-ID: <35343B11.E7ADC173@kofex.com>

Did you check your listener.ora file ?
After you created another new Database, you must modify or recreate listener using new SID and restart listener process.

#########################
#Example

#Contents of the listener.ora file

#########################

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)


          (KEY= oracle.world)


        )
        (ADDRESS=


          (PROTOCOL= TCP)


          (Host= tae-sik-han)


          (Port= 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = tae-sik-han)
      (SID_NAME = NEW_SID)

    )
    (SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM=extproc)

    )
  )
PASSWORDS_LISTENER = (oracle)

##################################

And then you have to modify or insert the tnsnames.ora file in remote client computer.

###########################
#Example

#Contents of the tnsnames.ora

###########################

TcpExample.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)

    )
    (CONNECT_DATA = (SID = NEW_SID)
    )
  ) Received on Tue Apr 14 1998 - 23:44:01 CDT