Question on running catproc.sql

[Deanna Tran]

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.

[harry d brown jr]

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

[harry d brown jr]

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

[Dave Chamberlin]

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.

[Deanna Tran]

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

[Deanna Tran]

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

[Brian Crabtree]

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

[Yogeeraj_1]

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)

[Graham Cameron_1]

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.