| DB 9i migration to 10g - Network configuration [message #335771] |
Wed, 23 July 2008 12:47  |
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 #335928 is a reply to message #335911] |
Thu, 24 July 2008 03:13  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
