Oracle problem

From: Adityanarayana K (SYSTEMS-ISL-ITPL) (adityanarayanak@VYSBANK.COM)
Date: Thu Nov 21 2002 - 11:37:01 EST

• Next message: Clifton, Pablo: "how to check the length of a variable in ksh?"
• Previous message: Bob Booth - UIUC: "Re: Backing Store (-BS)"
• Next in thread: Bullerwell, Edward: "Re: Oracle problem"
• Maybe reply: Bullerwell, Edward: "Re: Oracle problem"
• Maybe reply: Jolet, John: "Re: Oracle problem"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hi,

Can any one help me in the following scenario.

We have oracle database tested in staging. Oracle 8.1.7 running on AIX
4.3.3. The server is having multiple adapters.

We moved the server to another subnet. While doing this we dropped the
previous IP addr and assigned new IP.

We changed listner.ora and tnsnames.ora to point to changed IP.

Restarted database and Listner.

But, the listner is starting with changed IP with Old hostname.

How to get new hostname

Thanks and regards

• text/plain attachment: InterScan_Disclaimer.txt

• Next message: Clifton, Pablo: "how to check the length of a variable in ksh?"
• Previous message: Bob Booth - UIUC: "Re: Backing Store (-BS)"
• Next in thread: Bullerwell, Edward: "Re: Oracle problem"
• Maybe reply: Bullerwell, Edward: "Re: Oracle problem"
• Maybe reply: Jolet, John: "Re: Oracle problem"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:22 EDT