Hi,

My host file does not contain the sever name and its IP address.

And my TNSNAMES.ORA is using the hostname to point to the server itself.

Please help! >_<

$ORACLE_HOME/network/admin/listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRITPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTNAME>)
(PORT = 1521))
)
)

----- Original Message -----
From: "Yoav Givon " <[Email address protected]
To: <[Email address protected]
Sent: Sunday, February 26, 2006 12:22 AM
Subject: RE: Change of IP Address in Oracle 9i Linux Server


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal
> **Anything below this line is the original email text
>
>
> Been there .. in your /etc/hosts set the hostname and the current IP
> .
>
> Should work for U
>
> Yoav
>
> -----Original Message-----
> From: Teo Gek Eng
> [Email address protected]
> Sent: Saturday, February 25, 2006 6:16 PM
> To: LazyDBA Discussion
> Subject: Change of IP Address in Oracle 9i Linux Server
>
>
> 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
>
>


Oracle LazyDBA home page