Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Question on running catproc.sql

Deanna Tran
Frequent Advisor

Question on running catproc.sql

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.
8 REPLIES
harry d brown jr
Honored Contributor

Re: Question on running catproc.sql

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
Live Free or Die
harry d brown jr
Honored Contributor
Dave Chamberlin
Trusted Contributor

Re: Question on running catproc.sql

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
Frequent Advisor

Re: Question on running catproc.sql

those threads that you are have recommended has
absolutely nothing to do with my qustions
Deanna Tran
Frequent Advisor

Re: Question on running catproc.sql

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

Re: Question on running catproc.sql

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
Honored Contributor

Re: Question on running catproc.sql

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)
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Graham Cameron_1
Honored Contributor

Re: Question on running catproc.sql

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.
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.