| upgrading to 10g [message #262327] |
Sun, 26 August 2007 03:27  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
hi!
I am upgrading 9i release 2 database on windows 2000 to 1og r2 on windows 2000 manually using the catupgrad script.
First I, checked for upgrade using the upgrade requiste script, then I, started the database in startup upgrade and the created the sysaux tablespace, then I, ran the catupgrad scrpirt, but it gives the error package standard in not accessible.
When I, try to create the package standard using the available script , it does not create the package, what can be possible reason for this.
|
|
|
|
|
|
| Re: upgrading to 10g [message #262360 is a reply to message #262327] |
Sun, 26 August 2007 09:12  |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
The error when I, run the upgrade script is
ora-06553 :pls-213 package standard not accessible.
The error when I, run the standard is
warning : package created with compilation errors.
create or replace
error at line 1
ora-06553:pls -213 package standard not accessible
grant succeeded.
|
|
|
|
|
|
|
|
| Re: upgrading to 10g [message #262377 is a reply to message #262327] |
Sun, 26 August 2007 13:44 |
vijaychauhan
Messages: 106
Registered: December 2005
|
Senior Member |
|
|
Actaually I installed oracle 9i and then oracle 10g on the same server.
Both the software work fine independently.
I also upgarded using dbua and it worked fine.
But when I do it manually it gives problem.
The steps that I, followed for upgrade.
I made a 9i database and then copied the init file and pasted it 10g oracle_home/database.
Then I ran the prerequiste script to check the changes needed to make.
Then I, changed the size of shared pool and java pool as specified, then I, started the database in startup upgrade mode and created the sysaux tablespace.
Then when I, run the upgrade script it gives error.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
