What is "PLS-00201: identifier 'OWBSYS.WB_RT_SCRIPT_UTIL' must be declared
Hi,
I am installing OWB mega patch for 11.2.0.2 database. Before installing the patch the instructions are to stop all the OWB products running, including the Runtime Service by logging on as the Runtime repository owner and running the script "stop_service.sql" which is located in the OWB_HOME/rtp/sql directory. The example in the instructions is below:
sqlplus owbsys/owbsys_password @OWB_HOME/rtp/sql/stop_service.sql
When I execute the above sqlplus command give in the example I get the output below:
Enter user-name: owbsys@odsu
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
Role set.
l_available := owbsys.wb_rt_script_util.stop_service();
*
ERROR at line 5:
ORA-06550: line 5, column 18:
PLS-00201: identifier 'OWBSYS.WB_RT_SCRIPT_UTIL' must be declared
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
ORA-06550: line 10, column 26:
PLS-00201: identifier 'OWBSYS.WB_RT_SCRIPT_UTIL' must be declared
ORA-06550: line 10, column 5:
PL/SQL: Statement ignored
Can someone please help. I opened a ticket with Oracle Support but it is going on three days and I have not received a solution.
Thanks
Edited by: user11990981 on Mar 9, 2013 12:23 PM