Home » RDBMS Server » Server Utilities » running catalog.sql in svrmgrl
running catalog.sql in svrmgrl [message #70214] Mon, 06 May 2002 00:47 Go to next message
Jurriaan
Messages: 2
Registered: May 2002
Junior Member
I'm having difficulties with running catalog.sql in svrmgrl. I start svrmgrl, I connect as internal, then I want to run catalog.sql, and all it does is advance to the next line and then nothing!

I'm sure I'm overlooking something, but I can't figure out what it is...

I have HP UX 11 with Oracle 817

Jurriaan
Re: running catalog.sql in svrmgrl [message #70217 is a reply to message #70214] Mon, 06 May 2002 08:07 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Try:

sqlplus internal
SQL> @catalog

I am assuming the DB was created without errors and started. Check your alert log and trace files in bdump. Monitor the job for I/O and CPU.
Re: running catalog.sql in svrmgrl [message #70226 is a reply to message #70217] Tue, 07 May 2002 02:26 Go to previous messageGo to next message
Jurriaan
Messages: 2
Registered: May 2002
Junior Member
Yes, the database is running, and I am sure the job is not running. I saw that I didn't fully post what I saw in SVRMGRL, so that could be confusing. This is what happens:

SVRMGR> @catalog
2>

So svrmgrl asks for input, but this should not happen right?
Re: running catalog.sql in svrmgrl [message #70229 is a reply to message #70217] Tue, 07 May 2002 06:45 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
This should not happen. You could be running out of resources. Did you follow the Installation Guide and it's recommendations on kernal settings. The default for semiphores is too low. Set it to at least 600.
Previous Topic: Re: Urgent!!! SQL * LOADER ERROR-524
Next Topic: Re: This did not help....
Goto Forum:
  


Current Time: Thu Apr 25 08:02:28 CDT 2024