No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1323
Act. users last 24h3
Act. users last hour0
Registered user hits last week79
Registered user hits last month345
Comment details
Date 19-JUN-07
Type Bug
User Ramesh PS
Message I am having oracle 9i.

1. I tried as normal user and got this message.
==========================================

This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)

================================================================================
== VERIFYING PREREQUISITES ... ==
================================================================================

-- You need to run as SYS:
create or replace view SYS.PLATO$GDP$KSPPI AS
SELECT a.ksppinm as parameter, a.ksppdesc as description,
b.ksppstvl as session_value, c.ksppstvl as instance_value,
c.ksppstdf as is_default
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx;

grant select on SYS.PLATO$GDP$KSPPI to IT40;

create or replace view SYS.PLATO$GDP$KCCDI AS
select dimlm from sys.x$kccdi;

grant select on SYS.PLATO$GDP$KCCDI to IT40;

-- This user requires access to a lot of data dictionary tables
grant select any dictionary to IT40;

-- After doing all this, run this setup script again as user IT40

================================================================================
== PREREQUISITES NOT OK, FURTHER INSTRUCTIONS ARE DISPLAYED ABOVE ==
================================================================================

DECLARE
*
ERROR at line 1:
ORA-20999: Follow the instructions above, then run the setup script again.
ORA-06512: at line 183

==============================================


2. After executing the steps as SYS and logged in as normal user but got the following error.
==============================================

SQL> @plato_49_9i.sql
This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)

================================================================================
== VERIFYING PREREQUISITES ... ==
================================================================================

Creating package specification...
No errors.
Creating package body...

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY PLATO:
224/5 PLS-00201: identifier 'HTP.PRN' must be declared
224/5 PL/SQL: Statement ignored
BEGIN plato.help; END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "IT40.PLATO" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


========================================
3. Tries by logging in as "sys as sysdba" and got the same error.

SQL> @plato_49_9i.sql
This script may be run as any user.
It is recommended to run this script in SQL*Plus (due to the substitution var's)

================================================================================
== VERIFYING PREREQUISITES ... ==
================================================================================

Creating package specification...
No errors.
Creating package body...

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY PLATO:
224/5 PLS-00201: identifier 'HTP.PRN' must be declared
224/5 PL/SQL: Statement ignored
BEGIN plato.help; END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.PLATO" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


SQL> show err
Errors for PACKAGE BODY PLATO:
224/5 PLS-00201: identifier 'HTP.PRN' must be declared
224/5 PL/SQL: Statement ignored