HPE Community
Operating System - HP-UX
1753518 Members
5104 Online
108795 Solutions
New Discussion юеВ

Getting error creating database

 
SOLVED
Go to solution
TwoProc
Honored Contributor

тАО06-09-2010 11:35 AM

тАО06-09-2010 11:35 AM

Re: Getting error creating database

Man - if you're having to run that "upgrade" option - I think you need to look in $ORACLE_HOME/rdbms/sql for the cat* script relevant to the database level that you're creating.

Unfortable feeling: I've NEVER had to use the "upgrade" parameter you're describing.
We are the people our parents warned us about --Jimmy Buffett
0 Kudos
TwoProc
Honored Contributor

тАО06-09-2010 11:37 AM

тАО06-09-2010 11:37 AM

Re: Getting error creating database

also - a reminder - check your autoexend. Since it's not holding you, it means it's taking default value, which may be very, very small (1k perhaps). You really don't want to leave it like that. Your db files will be very cut up over your file system.
We are the people our parents warned us about --Jimmy Buffett
0 Kudos
Emil Velez
Honored Contributor

тАО06-09-2010 12:36 PM

тАО06-09-2010 12:36 PM

Re: Getting error creating database

the final issue was that the catalog.sql and catproc.sql scripts did not run.

0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.