edit the server-file

$ORACLE_HOME/network/admin/listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRITPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <YOUR IP ADDRESS OR HOSTNAME>)
(PORT = 1521))
)
)
...
after editing restart the listener

hth
Rüidiger J. Schulz
sosys-berlin.de

Teo Gek Eng schrieb:

>Hi,
>
>Anyone of you ever encounter a change of IP address for your Oracle 9i server?
>
>Recently my server admin change the IP address for one of my test Oracle 9i server.
>
>After a restart of Server, the oracle database can start up normally.
>
>But when i go to my PC and use the Oracle Enterprise Manager, the standalone database cannot be connected.
>
>May i know whether is there any configuration to be done on the server side such as amending the TNSNAMES.ora, SQLNET.ora??
>
>Please help.
>
>Thanks
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>

--
Rüdiger J. Schulz
Normannenstraße 4
D-14129 Berlin
fon: +49 (0) 30 / 922 59 789
fax/ab: +49 (0) 30 / 80 40 47 56
mobil: +49 (0) 178 / 815 13 36 (preferred)
eMail: [Email address protected]
im web: sosys-berlin.de



Oracle LazyDBA home page