OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » catlog.sql (10g,WIndowsXp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

catlog.sql [message #339776]

Fri, 08 August 2008 07:57

niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai

Junior Member

Hi,
I am creating a database for the first time and while running the catlog.sql and catprod.sql..I got errors in the log file..Both the files must run without any error,if i am rite?
Error got while running catlog.sql:

drop table AUDIT_ACTIONS
*
ERROR at line 1:
ORA-00942: table or view does not exist
Can some one help?

Regards,
nivea

Report message to a moderator

Re: catlog.sql [message #339788 is a reply to message #339776]

Fri, 08 August 2008 08:37

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

while running the catlog.sql and catprod.sql..I got errors in the log file..

No doubt about this as the names are catalog.sql and catproc.sql

Errors on drops are "expected".

Regards
Michel

Report message to a moderator

Re: catlog.sql [message #340013 is a reply to message #339788]

Mon, 11 August 2008 00:24

niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai

Junior Member

thx for your reply.
so it it ok ,that it can run with errors,or must i make sure,it doesnt.

Report message to a moderator

Re: catlog.sql [message #340015 is a reply to message #340013]

Mon, 11 August 2008 01:09

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Some errors are normal, others not, you have to check each one.

Regards
Michel

Report message to a moderator

Re: catlog.sql [message #340062 is a reply to message #340015]

Mon, 11 August 2008 05:33

niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai

Junior Member

Hi michel,
How do we know wat errors are ok and wat are not?
In catlog.sql.
these were the other errors that i got.
SQL> CREATE ROLE exp_full_database;
CREATE ROLE exp_full_database
*
ERROR at line 1:
ORA-01921: role name 'EXP_FULL_DATABASE' conflicts with another user or role
name

SQL> CREATE ROLE imp_full_database;
CREATE ROLE imp_full_database
*
ERROR at line 1:
ORA-01921: role name 'IMP_FULL_DATABASE' conflicts with another user or role

Expect ORA-1921 for CREATE ROLE exp_full_database if this file is run
SQL> REM as part of the migration script and the role existed in the previous
SQL> REM release. Dropping will require DBA to regrant the role.

Wat do they mean??? Sad

..
Help!!!!
have also attached my catproc.sql log.and no idea wat is needed and wats not

Attachment: catproc errors.txt
(Size: 53.10KB, Downloaded 1936 times)

Report message to a moderator

Re: catlog.sql [message #340065 is a reply to message #340062]

Mon, 11 August 2008 05:44

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It just mean that these roles can be created by several script and so the second one can't create it because it is already created => normal error.

As there are hundred "normal" errors, I think this topic will not end soon. Smile

Regards
Michel

Report message to a moderator

Re: catlog.sql [message #340087 is a reply to message #340065]

Mon, 11 August 2008 07:28

niveditha_j_s
Messages: 4
Registered: July 2008
Location: chennai

Junior Member

Correct me if i am wrong.the database is created for the first time.There are no tables, roles etc...The catlog.sql only creates base tables or roles for the first.Then how is this error possible..

SQL> CREATE ROLE exp_full_database;
CREATE ROLE exp_full_database
*
ERROR at line 1:
ORA-01921: role name 'EXP_FULL_DATABASE' conflicts with another user or role
name.

Report message to a moderator

Re: catlog.sql [message #340090 is a reply to message #340087]

Mon, 11 August 2008 07:34

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because some scripts call some scripts that call the same scripts.

Regards
Michels

Report message to a moderator

Previous Topic:	check statistics
Next Topic:	database creattion error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 22:27:17 CST 2025