OraFAQ Forum: Server Administration » Upgrading from 9i to 10g

Home » RDBMS Server » Server Administration » Upgrading from 9i to 10g (database: 9.2.0.4 OS:Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrading from 9i to 10g [message #377215]

Sun, 21 December 2008 19:58

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377232 is a reply to message #377215]

Mon, 22 December 2008 00:44

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you install 10.2 in the same home than 9.2?

Regards
Michel

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377240 is a reply to message #377232]

Mon, 22 December 2008 01:41

Frank Naude
Messages: 4581
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!

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377649 is a reply to message #377240]

Wed, 24 December 2008 01:40

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377669 is a reply to message #377664]

Wed, 24 December 2008 02:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #377755 is a reply to message #377669]

Wed, 24 December 2008 21:06

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #381405 is a reply to message #377755]

Fri, 16 January 2009 12:27

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #381580 is a reply to message #381405]

Sun, 18 January 2009 12:46

varunvir
Messages: 389
Registered: November 2007

Senior Member

Quote:

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

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

Report message to a moderator

Re: Upgrading from 9i to 10g [message #383658 is a reply to message #382792]

Thu, 29 January 2009 09:45

varunvir
Messages: 389
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

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

Report message to a moderator

Previous Topic:	scheduler job
Next Topic:	ORA-00214: controlfile error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:45:45 CST 2024