Oracle9i: DBMS_APPLICATION_INFO accessibility problem

From: A. Fuentes <alvarof2_at_hotmail.com>
Date: Sun, 16 May 2004 18:52:20 -0500
Message-ID: <c88tvt$gn2$1@ausnews.austin.ibm.com>

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.

Best,

1. Fuentes 512-297-9937

Received on Sun May 16 2004 - 18:52:20 CDT