sys crash - new database created - what next?

[robwall7]

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.

 

[rcurva]

Here are some steps that you need to do:

1. If you already created the DB by CREATE DATABASE command, run the catalog.sql & catproc.sql that can usually be found from $ORACLE_HOME/rdbms/admin dir.

2. Create and online another system rollback segment if there are other tablespaces other than SYSTEM. Make sure that this rollback can accomodate your largest table otherwise you have to commit often in your import.

CREATE ROLLBACK SEGMENT system2
TABLESPACE SYSTEM
STORAGE (...);

Alter rollback segment system2 online;

-check the status of this rollback!
SELECT * FROM SYS.DBA_ROLLBACK_SEGS
WHERE SEGMENT_NAME = 'SYSTEM2';

3. Do a full database import (FULL=Y) to restore the entire database.

Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War