SunOS 5.6 sun4u sparc SUNW,Ultra-2
Oracle 8i, 8.1.5
I created the database and need to do a FULL import, but I think there are some steps missing. Are there certain SQL scripts that should be run before I can do the recovery import? Do I need to recreated the TABLESPACE file structure before FULL import?
ora>svrmgrl
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> connect internal as sysdba
Connected.
SVRMGR> startup nomount pfile=/u01/oracle8/dbs/initxyz.ora
ORACLE instance started.
Total System Global Area 4881808 bytes
Fixed Size 64912 bytes
Variable Size 4530176 bytes
Database Buffers 204800 bytes
Redo Buffers 81920 bytes
SVRMGR> @/u01/oracle8/dbascripts/xyz_crt_db.sql
Statement processed.
SVRMGR>
I have an xyz instance, but trying SQL*Plus, I get:
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
This is my first CREATE DATABASE. What am I missing?
Robert
default dba
Think twice, commit once.
Oracle 8i, 8.1.5
I created the database and need to do a FULL import, but I think there are some steps missing. Are there certain SQL scripts that should be run before I can do the recovery import? Do I need to recreated the TABLESPACE file structure before FULL import?
ora>svrmgrl
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> connect internal as sysdba
Connected.
SVRMGR> startup nomount pfile=/u01/oracle8/dbs/initxyz.ora
ORACLE instance started.
Total System Global Area 4881808 bytes
Fixed Size 64912 bytes
Variable Size 4530176 bytes
Database Buffers 204800 bytes
Redo Buffers 81920 bytes
SVRMGR> @/u01/oracle8/dbascripts/xyz_crt_db.sql
Statement processed.
SVRMGR>
I have an xyz instance, but trying SQL*Plus, I get:
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-213: package STANDARD not accessible
This is my first CREATE DATABASE. What am I missing?
Robert
default dba
Think twice, commit once.