Home » RDBMS Server » Server Administration » 9i upgrade from 8i...
9i upgrade from 8i... [message #51912] Fri, 21 June 2002 02:04 Go to next message
Vishnu Murty
Messages: 16
Registered: June 2001
Junior Member
Hi ,
I am trying to upgrade an 8i database to 9i . Can anyone pls provide me a checklist which should be verified while doing this upgrade ? Are there any security loop holes in 9i server which we need to take care of ?
Also can you share your experiences of upgrading to 9i ?

Thanks for ur help in advance .

Regards,
Vishnu

Report message to a moderator

Re: 9i upgrade from 8i... [message #51928 is a reply to message #51912] Fri, 21 June 2002 12:00 Go to previous messageGo to next message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
SIR,

NO NEEDS TO VERIFY.JUST EXPORT ALL THE TABLES IN 8I AND IMPORT IN THE ORACLE 9I .BUT USE ONLY ORACLE9I 'S IMPORT AND EXPORT UTILITY.

K.SREENIVASAN

Report message to a moderator

Re: 9i upgrade from 8i... [message #51936 is a reply to message #51912] Fri, 21 June 2002 15:26 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
DO NOT USE EXPORT/IMPORT !!! IT WILL CORRUPT YOUR DATA DICTIONARY !

Consult this note before starting Upgrade 8i to 9i

You have to go through a lots of steps before finaly upgrading your data dictionary with SQL>$ORACLE_HOME/rdbms/admin/u0801070.sql - (for 8.1.7). If you have other version run the appropriate script.

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

Report message to a moderator

Previous Topic: how to Gant rights and privileges to new user
Next Topic: Operation Log
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:29:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.