topic Re: Question on running catproc.sql in Operating System - HP-UX

Question on running catproc.sql

Deanna Tran — Tue, 04 Jun 2002 18:07:08 GMT

After running catalog.sql, I do not have any problem. As suggested, the catproc.sql must be running as sys/change_on_install not as
system/manager. When I try to do the following and here is the eror that i am getting
@$ORACLE_HOME/rdbms/admin/catproc.sql
SP2-0734: unknown command beginning "$ORACLE_HO..." - rest of line ignored.

Re: Question on running catproc.sql

harry d brown jr — Tue, 04 Jun 2002 18:20:58 GMT

Deanna,

When you say

"... As suggested, the catproc.sql must be running as sys/change_on_install not as
system/manager."

Are you refering to some other thread??

Also, WHERE is the following error occuring???

"When I try to do the following and here is the eror that i am getting
@$ORACLE_HOME/rdbms/admin/catproc.sql
SP2-0734: unknown command beginning "$ORACLE_HO..." - rest of line ignored."

live free or die
harry

Re: Question on running catproc.sql

harry d brown jr — Tue, 04 Jun 2002 18:22:07 GMT

Deanna,

And, you need to visit these threads:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x96b70bce6f33d6118fff0090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x316efd3f91d3d5118ff40090279cd0f9,00.html

Great help in finding them:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1e6f84534efbd5118ff40090279cd0f9,00.html

live free or die
harry

Re: Question on running catproc.sql

Dave Chamberlin — Tue, 04 Jun 2002 18:37:47 GMT

I dont believe that the shell variable $ORACLE_HOME is known inside of sqlplus. Replace this with the actual path - ie /u01/oracle/8.1.7 etc for your database. BTW -you should go visit Barnes and Noble or your favorite bookstore and get an Oracle DBA handbook or similar. You will find it an excellent investment and can answer many questions you might have. Your boss will probably pay for it (unless you just do DBA for a hobby...). I have several and use them almost daily.

Re: Question on running catproc.sql

Deanna Tran — Tue, 04 Jun 2002 18:52:05 GMT

those threads that you are have recommended has
absolutely nothing to do with my qustions

Re: Question on running catproc.sql

Deanna Tran — Tue, 04 Jun 2002 18:53:56 GMT

hi dave,
Not every errors are in the handbook of oracle...
thanks for your suggestion

Re: Question on running catproc.sql

Brian Crabtree — Wed, 05 Jun 2002 00:11:57 GMT

What you can try doing is running the following (inside sqlplus or svrmgrl):

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

The ? will automaticlly convert to the ORACLE_HOME currently set.

Brian

Re: Question on running catproc.sql

Yogeeraj_1 — Wed, 05 Jun 2002 05:03:21 GMT

Hello deanna,

Definitely a problem with your SQLPLUS/SVRMGR.

I searched the Oracle Metalink Database for you and found the following helpful information below.

Hope this helps

Best Regards
Yogeeraj

Problem Description
-------------------
The 'alter database backup controlfile to trace' command generates a
trace file containing a script with the 'create controlfile' command.
When running this create controlfile script in SQL*Plus, which is
possible starting Oracle 8i, you receive errors similar to:

SP2-0734: unknown command beginning "The follow..." - rest of line ignored.
SP2-0734: unknown command beginning "to open th..." - rest of line ignored.
SP2-0734: unknown command beginning "Data used ..." - rest of line ignored.
SP2-0734: unknown command beginning "be require..." - rest of line ignored.

The same script works fine when using server manager. The same may happen
with other server manager scripts containing the hash ('#')-sign.

Solution Description
--------------------
Remove all the comment lines, those starting with the hash sign '#'. These
are causing the errors. The script itself works fine.

Explanation
-----------
Server manager accepts the hash sign '#' as a comment sign and ignores
what is on this line. SQL*Plus only accepts 'REMARK', /*...*/, and '--' as
signs of comment.

References
----------
SQL*PLUS user guide and Reference (A66736-01) Page 3-12
SQL Reference Volume 2 (A67795-01)

Re: Question on running catproc.sql

Graham Cameron_1 — Wed, 05 Jun 2002 07:06:52 GMT

Deanna
I think perhaps you are new to these forums.

The links pointed to by Harry were gentle hints to you to assign points to those, like me, who have posted anwers to your previous questions.

For this question, the posting by Brian is right, that by Yogeeraj addresses a different problem.

However from this and your previous postings I suspect you are new to Oracle and if I am right you may find www.orafaq.com more appropriate than this forum.