Thursday, May 29, 2008

PLS-213: package STANDARD not accessible

Today when i was creating a new database (10.2.0.2) using DBCA for CMS Production, i got error "PLS-213: package STANDARD not accessible". How to solve this problem?. Well there are few things that you have to check

1. Check standard.sql does exists under ORACLE_HOME/rdbms/admin
ora10g@bahamut:/home/ora10g/10.2/rdbms/admin> ls -arlt st*
-rw-r----- 1 ora10g dba 144274 Jun 30 2005 stdspec.sql
-rw-r----- 1 ora10g dba 19277 Jun 30 2005 stdbody.sql
-rw-r----- 1 ora10g dba 65 Jun 30 2005 standard.sql

2. Check that glogin.sql (ORACLE_HOME/sqlplus/admin) does not contain "set serveroutput on"

Here my problem was caused because serveroutput was set to on, after remove it for temporary then i can continue database creation through DBCA



GBU