I went through the steps and the DB will come up, although the SystemStarter gives a permission denied error. My question though is on the create_db script which gives a database not open for each script that gets called. What am I missing ? What output would help trouble shoot ?
As I said the DB seem to come up ok with dbstart and it can be seen by tnsping, but there's nothing there table wise.
As you can probably tell I'm new to Oracle.
Pete
oracle: ~ % sqlplus /nolog @/Users/oracle/db_create.sql
SQL*Plus: Release 9.2.0.1.0 - Developer's Release on Wed Jun 18 01:10:39 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
limit: maxproc: Can't set limit
File created.
limit: maxproc: Can't set limit
limit: maxproc: Can't set limit
SQL> spool /Users/oracle/v920/assistants/dbca/logs/CreateDB.log
SQL> shutdown abort
ORACLE instance shut down.
SQL> connect / as SYSDBA
Connected to an idle instance.
SQL> startup nomount pfile="/Users/oracle/v920/dbs/initprod1.ora";
ORACLE instance started.
Total System Global Area 352915720 bytes
Fixed Size 450824 bytes
Variable Size 335544320 bytes
Database Buffers 16777216 bytes
Redo Buffers 143360 bytes
SQL> CREATE DATABASE PROD1
2 MAXINSTANCES 1
3 MAXLOGHISTORY 1
4 MAXLOGFILES 50
5 MAXLOGMEMBERS 5
6 MAXDATAFILES 100
7 DATAFILE '/Volumes/Oracle/v920/prod1/system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
8 UNDO TABLESPACE "undotbs" DATAFILE '/Volumes/Oracle/v920/prod1/undo01.dbf' SIZE 500M
9 DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/Volumes/Oracle/v920/prod1/temp01.dbf' SIZE 55M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
10 CHARACTER SET AL32UTF8
11 NATIONAL CHARACTER SET AL16UTF16
12 LOGFILE GROUP 1 ('/Volumes/Oracle/v920/prod1/redo01.log', '/Volumes/Oracle/v920/prod1/redo01g1f2.log') SIZE 10M,
13 GROUP 2 ('/Volumes/Oracle/v920/prod1/redo02.log', '/Volumes/Oracle/v920/prod1/redo02g2f2.log') SIZE 10M,
14 GROUP 3 ('/Volumes/Oracle/v920/prod1/redo03.log', '/Volumes/Oracle/v920/prod1/redo03g3f2.log') SIZE 10M
15 set time_zone = 'America/Chicago';
CREATE DATABASE PROD1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
SQL> spool off
SQL>
SQL> spool /Users/oracle/CreateDBFiles.log
SQL> CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/Volumes/Oracle/v920/prod1/tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/Volumes/Oracle/v920/prod1/tools01.dbf' SIZE 10M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
|
