Home » RDBMS Server » Server Administration » Upgrading from 9i to 10g (database: 9.2.0.4 OS:Windows XP)
Upgrading from 9i to 10g [message #377215] Sun, 21 December 2008 19:58 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi

I am upgrading my database 9.2.0.4 to 10.2.0. After running the database upgrade assistance when i am trying to connect to my database its giving error as: ORA-12560: TNS:protocall adapter error.

THe most surprising is i have only 1 directory db_1 in my oraclehome. In this directory i have bin,RDBMS,demo,install etc directories. But there is no dbs,network etc directories.

Can some one guide me ? Have i lost my database? Can I troubleshoot or else how can i recover my old database?

Please help soon.


REgards
RIdhi
Re: Upgrading from 9i to 10g [message #377232 is a reply to message #377215] Mon, 22 December 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you install 10.2 in the same home than 9.2?

Regards
Michel
Re: Upgrading from 9i to 10g [message #377240 is a reply to message #377232] Mon, 22 December 2008 01:41 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Well, the first step of any valid upgrade procedure is to do a backup, so I guess you haven't lost anything, just restore the backup.

Also, note that you need to install Oracle 10g in a separate directory before attempting an upgrade. And, if this install doesn't have "dbs" and "network" directories, the install didn't work!

Best of luck with that restore!
Re: Upgrading from 9i to 10g [message #377649 is a reply to message #377240] Wed, 24 December 2008 01:40 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I did not install the 10.2 on the same home. But the directory was same. I mean both the homes are in 'E:/ORACLE'.I have uninstalled 10.2 and recovered my 9.2 DB. But I am not able to know where did I do mistake. Can some one provide me with a link to some document I can follow for this upgradation?

Thanks
Ridhi Sundar

[Updated on: Wed, 24 December 2008 01:43]

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377650 is a reply to message #377649] Wed, 24 December 2008 01:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
did not install the 10.2 on the same home. But the directory was same.

What does this mean? You just change the home name but not the home directory? You can't mix up 2 versions in the same directory.

Regards
Michel

[Updated on: Wed, 24 December 2008 01:45]

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377664 is a reply to message #377650] Wed, 24 December 2008 02:24 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I mean i have both the oraqcle home directory at E:/ORACLE. FOr 9i it is E:/ORACLE/orahome92 an for 10.2 its E:ORACLE/10.2.0. I am sory that my prebious statement was not much clear. If i will gate some document regarding the upgradation it will be grate. I have the DB 9.2.0.4.0. I have the oracle software 10.2.0.1.

Thanks
Ridhi Sundar
Re: Upgrading from 9i to 10g [message #377669 is a reply to message #377664] Wed, 24 December 2008 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are missing some definition:
- E:/ORACLE is your ORACLE_BASE
- E:/ORACLE/orahome92 is your ORACLE_HOME for Oracle 9i
- E:ORACLE/10.2.0 is your ORACLE_HOME for Oracle 10g

Now it depends on your application but most of the time in order to use Oracle 10g for your application, you just need to change ORACLE_HOME environment variable.

Regards
Michel
Re: Upgrading from 9i to 10g [message #377755 is a reply to message #377669] Wed, 24 December 2008 21:06 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I have done it. But still I couldn't know where did i do mistake on my 1st attempt. Now i have both the database 9.2 and 10.2 if i will uninstall my 9i database and delete the files from 9i home will it be OK?

Thanks
Ridhi Sundar
Re: Upgrading from 9i to 10g [message #381405 is a reply to message #377755] Fri, 16 January 2009 12:27 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi

i am having some issues. While running DBUA I found few errors as:
Quote:

1. The default privileges, previously assigned with the connect role will only have the create session privilege. to provide more privileges, you must manually assign the required privileges to the user/role.

2. The following components cannot be upgraded as the corresponding upgrade scripts are missing:
Oracle ultra Search(E;\oracle\product\10.2.0\db_1\ultrasearch\admin\wkdbmig.sql)

3. DBUA has detected the JAccelerator(NCOMP)is not installed.



Can any one help me in below questions:
How will these effect my new DB?
How can I solve the issues? (Either before upgrade or after upgrade)

Thanks & Regards
Ridhi
Re: Upgrading from 9i to 10g [message #381580 is a reply to message #381405] Sun, 18 January 2009 12:46 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Quote:
1. The default privileges, previously assigned with the connect role will only have the create session privilege. to provide more privileges, you must manually assign the required privileges to the user/role.


Please grant all the missing privileges manually to the user
after upgrading.

Quote:
2. The following components cannot be upgraded as the corresponding upgrade scripts are missing:
Oracle ultra Search(E;\oracle\product\10.2.0\db_1\ultrasearch\admin\wkdbmig.sql)

3. DBUA has detected the JAccelerator(NCOMP)is not installed.

You can ignore these two error messages.
Regards,
Varun Punj,

[Updated on: Sun, 18 January 2009 12:48] by Moderator

Report message to a moderator

Re: Upgrading from 9i to 10g [message #382792 is a reply to message #381580] Sat, 24 January 2009 12:31 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Thanks Varun. So you mean these errors will not effect my DB. Can I trouble shoot these by any manor? I was doing it in my test environment. Can I avoid these errors by any means while doing it in my production?

Thanks & Regards
Ridhi Sundar
Re: Upgrading from 9i to 10g [message #383658 is a reply to message #382792] Thu, 29 January 2009 09:45 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
IGNORE
Quote:
If you do not use Java in the database, then ignore this error message.


Don't Ignore
Quote:
If you use Java in the database, then install the NCOMP libraries by selecting the Oracle Database 10g Products installation type from the Oracle Database Companion CD.

Regards,
Varun Punj,

[Updated on: Thu, 29 January 2009 09:52] by Moderator

Report message to a moderator

Re: Upgrading from 9i to 10g [message #383909 is a reply to message #383658] Sat, 31 January 2009 03:33 Go to previous message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
I am having oracle apps running on this Database. Can any body give me a brief list of post upgrade steps or a suitable link?

Thanks and Regards
Ridhi Sundar
Previous Topic: scheduler job
Next Topic: ORA-00214: controlfile error
Goto Forum:
  


Current Time: Sun Dec 11 04:04:45 CST 2016

Total time taken to generate the page: 0.35390 seconds