Re: Problem with PL/SQL

In article qs7_at_nameserver.lif.de, barth_at_newsserver (Juergen Barth) writes:
> Stupid question, but how do I start PL/SQL?
>
> I have PL/SQL installed with the installer but
> I can`t find out how to link it in. My login
> banner in SQL*Plus only says :
>
> ORACLE7 Server Release 7.0.15.4.0 - Production
>
> Thanx Juergen
> ---

(I had trouble responding to the author of this question, so I'm posting to the group.)

Here's how to get PL/SQL "started."

1. Go to $ORACLE_HOME/rdbms/lib.
2. Issue the command: make -f oracle.mk procopt install
3. When this is done, you may get an "end of channel" (or something similar) error message when you try to start sqlplus (and probably other products).
4. If this occurs, do the following:

	setenv TWO_TASK p:
	shutdown and then restart the database
	unsetenv TWO_TASK
	as SYS, run ORACLE_HOME/rdbms/admin/catproc.sql

This should fix your problem.

Beverly  

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
+                                    +                             +
+  Beverly Cather Zygmunt            +  Phone: (615) 574-1007      +
+  Oak Ridge National Laboratory     +  email: zygmuntbc_at_ornl.gov  +
+  Building 4500N, MS 6274           +         bzy_at_ornl.gov        +
+  Oak Ridge, TN 37831-6274          +                             +
+                                    +                             +
+                                    +                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                                  +
+  "If you torture your data long enough, they will tell you what  +
+  you want to hear." -- James L. Mills                            +
+                                                                  +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++