Home » RDBMS Server » Server Administration » DB 9i migration to 10g - Network configuration
DB 9i migration to 10g - Network configuration [message #335771] Wed, 23 July 2008 12:47 Go to next message
Asma123
Messages: 19
Registered: November 2007
Junior Member
Hi

We have oracle 9.2.0.1 database installed on our server. First we upgraded it to oracle 9.2.0.4 using patch set. We have to upgrade it to oracle 10g release 10.2.0.1. We used database upgrade assistant for this purpose. All steps were performed, database was connected successfully on the server, but we are unable to connect database through network configuration.
According to the given documentation, listener.ora file should have changed through upgrade assistant, but it did not happen. Oracle 9i was installed in D:\oracle path and 10g is installed in e:\oracle\product\db_1... path. listener.ora is present in d:\oracle\network\admin folder, but there is no such file in e:\oracle\product\db_1\network folder. Many of the standard files are not created in e:\oracle folder and files for 10g are upgraded in 9i folder. I do not understand which file is being used from where after the upgrade.

Can anyone help us in resolving this problem, so that we can connect to the upgraded database through network.

regards

Asma
Re: DB 9i migration to 10g - Network configuration [message #335777 is a reply to message #335771] Wed, 23 July 2008 13:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy the missing file to the new home.

Regards
Michel
Re: DB 9i migration to 10g - Network configuration [message #335883 is a reply to message #335777] Thu, 24 July 2008 01:35 Go to previous messageGo to next message
Asma123
Messages: 19
Registered: November 2007
Junior Member
The problem has been resolved. Thanks.

Asma
Re: DB 9i migration to 10g - Network configuration [message #335911 is a reply to message #335883] Thu, 24 July 2008 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How?

Regards
Michel
Re: DB 9i migration to 10g - Network configuration [message #335928 is a reply to message #335911] Thu, 24 July 2008 03:13 Go to previous message
Asma123
Messages: 19
Registered: November 2007
Junior Member

These are the steps
1)Stop listener services
2)Delete listener.ora file from ..oracle_home9i\network\admin
folder.
3)Run netca.bat file from ...oracle10g\bin. It will create
listener.ora file in oracle10g\network\admin folder
4)Configure Tnsnames file on client machine

Previous Topic: views
Next Topic: INDEX
Goto Forum:
  


Current Time: Fri Dec 02 16:54:27 CST 2016

Total time taken to generate the page: 0.33542 seconds