Home » Other » General » Oracle Database creation 10g
Oracle Database creation 10g [message #301122] Tue, 19 February 2008 04:29 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

i created oracle 10g database on windows platforms with 10.2.0.1.0 release.

database was sucessfully created.

when i tried to run CATALOG.SQL and CATALOG.SQL i am getting error with ora-01012 : not logged on.

after that i exited from sqlplus and tried connecting as sysdba and issued some queries like startup it asked me to shudown first and restart the instance again.

when i issued shutdown , i am getting error like this:--

ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","sql area","kglhin: t
mp")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","select value$ from props$ wh...","Typecheck","qcsqlpat
: qcsAddSqlPath")


Kindly give me some solution to solve my issue.

Regards,
Balaji
Re: Oracle Database creation 10g [message #301188 is a reply to message #301122] Tue, 19 February 2008 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a greater value for shared pool.
Oracle needs a lot of memory to create the catalog and related objects.

Regards
Michel

[Updated on: Tue, 19 February 2008 08:03]

Report message to a moderator

Re: Oracle Database creation 10g [message #301227 is a reply to message #301188] Tue, 19 February 2008 13:28 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks michel
Previous Topic: Puzzle n°02 - Hiding names in crossword array **
Next Topic: pl/sql package
Goto Forum:
  


Current Time: Sat Dec 10 05:00:39 CST 2016

Total time taken to generate the page: 0.09778 seconds