Re: ***DBA question--Help please

From: <tim.mcconechy_at_runtime.dk>
Date: Mon, 15 Mar 1999 14:34:54 GMT
Message-ID: <7cj5qe$qu8$1@nnrp1.dejanews.com>

It is of my Opionion you must do the following: 1) Change the file listener.ora ... IN The ORANT\NET80\admin directory.

Or use Net80 Assistant...
It should look like....

# D:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:D:\orant\net80\admin\listener.ora
# Generated by Oracle Net8 Assistant

PASSWORDS_LISTENER= (oracle)

LISTENER =
(ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
    (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    (ADDRESS = (PROTOCOL = NMP)(SERVER = RUNTIME-PDM)(PIPE = ORAPIPE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = runtime-pdm)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = runtime-pdm)(PORT = 1526))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = runtime-pdm)
(SID_NAME = ORCL)

    )
    (SID_DESC =
(SID_NAME = extproc)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = runtime-pdm)
(SID_NAME = TST)

    )
  )

OR Similar.....
The line you will add is ....
(SID_DESC =
(GLOBAL_DBNAME = runtime-pdm)
(SID_NAME = TST)

)

Where SID_NAME is TEST or TST or whatever you called it and... GLOBAL_DBNAME is your server name.
(Same as)

(SID_DESC =
(GLOBAL_DBNAME = runtime-pdm)
(SID_NAME = ORCL)
2) Stop and start the TNSLISTENER Service in the control Panel.

3) Change the tnsnames.ora ...
Or use Net80 Easy Config . To add an Alias() Use the machine IP address

4) Test with SQLPlus using the new connection string.

You can connect to
using system/manager_at_new_alias_name

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 08:34:54 CST