Re: Oracle9i: DBMS_APPLICATION_INFO accessibility problem

1. Fuentes wrote:
   >
   >
   > Fellow Oracle Users:
   >
   > I am running Oracle9i/AIX 5.2:
   >
   > I am trying to create the temp tablespace in a customized
   > database, by doing:
   >
   > startup pfile=/my_p_ora_dir/my_p_db_building.ora;
   > connect system/manager
   > create temporary tablespace temp tempfile
   > '/my_temp_datafile' size 600M reuse
   > extent management local uniform size 16M;
   >
   >
   > and I am getting:
   >
   >
   > SQL*Plus: Release 9.2.0.1.0 - Production on Sun May 16 18:05:40 2004
   >
   > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
   >
   > Connected to an idle instance.
   >
   > SQL> Connected to an idle instance.
   > SQL> ORACLE instance started.
   >
   > Total System Global Area x bytes
   > Fixed Size x bytes
   > Variable Size x bytes
   > Database Buffers x bytes
   > Redo Buffers x bytes
   > Database mounted.
   > Database opened.
   > SQL> ERROR:
   > ORA-06553: PLS-213: package STANDARD not accessible
   >
   > ERROR:
   > ORA-06553: PLS-213: package STANDARD not accessible
   >
   > Error accessing package DBMS_APPLICATION_INFO
   >
   > Connected.
   > SQL> 2 3
   > Tablespace created.
   >
   >
   > The temp tablespace is created but the 600M size is not allocated.
   >
   >
   > Questions:
   >
   > 1)Shall I stick a line like @/dir/standard.sql before the line
   > for creating the tablespace temp?
   >
   > 2)For the DBMS_APPLICATION_INFO package, how can I access it
   > (ie which sql scripts shall I run before the temp tablespace creation?
   > Is it just the $ORACLE_HOME/rdmbs/admin/dbmsapin.sql script or others?
   >
   > Any ideas/advice/comments will be greatly appreciated.
   

The DB is owned by "SYS" , not "SYSTEM" user. Received on Sun May 16 2004 - 19:13:54 CDT