I'm trying to create a 9.2 db but r 1

[scohan]

I'm trying to create a 9.2 db but running in to an error just trying to create the spfile. I've included the output generated when rnning my db script. ???? Thanks.



SQL> SET TERMOUT ON
SQL>
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL>
SQL> -- Create the spfile and startup the database.
SQL>
SQL> CREATE SPFILE FROM PFILE='$ORACLE_HOME/dbs/initecassdev.ora';
CREATE SPFILE FROM PFILE='$ORACLE_HOME/dbs/initecassdev.ora'
*
ERROR at line 1:
ORA-01012: not logged on

SQL>
SQL> STARTUP NOMOUNT
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>
SQL> -- Create database
SQL>
SQL> CREATE DATABASE ecassdev
2 USER SYS IDENTIFIED BY pw
3 USER SYSTEM IDENTIFIED BY pw
4 LOGFILE GROUP 1 ('/REDOLOG/ecassdev/redo01.log') SIZE 100M,
5 GROUP 2 ('/REDOLOG/ecassdev/redo02.log') SIZE 100M,
6 GROUP 3 ('/REDOLOG/ecassdev/redo03.log') SIZE 100M
7 MAXLOGFILES 5
8 MAXLOGMEMBERS 5
9 MAXLOGHISTORY 1
10 MAXDATAFILES 100
11 MAXINSTANCES 1
12 CHARACTER SET US7ASCII
13 NATIONAL CHARACTER SET AL16UTF16
14 DATAFILE '/DATA/ecassdev/system01.dbf' SIZE 325M REUSE
15 EXTENT MANAGEMENT LOCAL
16 DEFAULT TEMPORARY TABLESPACE tempts1
17 TEMPFILE '/DATA/ecassdev/temp01.dbf'
18 SIZE 20M REUSE
19 UNDO TABLESPACE undotbs
20 DATAFILE '/DATA/ecassdev/undotbs01.dbf'
21 SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE DATABASE ecassdev
*
ERROR at line 1:
ORA-01012: not logged on

SQL>
SQL> -- Create additional tablespaces ...
SQL>
SQL> -- Create a user tablespace to be assigned as the default tablespace for users
SQL> CREATE TABLESPACE data LOGGING
2 DATAFILE '/DATA/ecassdev/ecassdev01.dbf'
3 SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
4 EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE data LOGGING
*
ERROR at line 1:
ORA-01012: not logged on

SQL> -- Create a tablespace for indexes, separate from user tablespace
SQL> CREATE TABLESPACE indx LOGGING
2 DATAFILE '/DATA/ecassdev/indx01.dbf'
3 SIZE 25M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
4 EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE indx LOGGING
*
ERROR at line 1:
ORA-01012: not logged on

SQL>
SQL> create user ecassdev identified by pw
2 default tablespace data;
create user ecassdev identified by pw
*
ERROR at line 1:
ORA-01012: not logged on

SQL>
SQL> grant create session to ecassdev;
grant create session to ecassdev
*
ERROR at line 1:
ORA-01012: not logged on

SQL> grant dba to ecassdev;
grant dba to ecassdev
*
ERROR at line 1:
ORA-01012: not logged on

 

[Turkbear]

Hi,
IIRC, you need to startup nomount ( using your pfile) before running the
create spfile... command.

 

[scohan]

Actually I was just trying to do the startup with just the pfile (and no spfile) but now I'm seeing:

SQL> STARTUP NOMOUNT PFILE='$ORACLE_HOME/dbs/initecassdev.ora';
ORA-01081: cannot start already-running ORACLE - shut it down first

I shutdown the db before running the create db script, but still keep seeing this message. Any clues???

BTW, what does IIRC mean?

Thanks

 

[Turkbear]

Hi,
IIRC=If I Recall Correctly

Sometimes Oracle 'thinks' it is running when it is not..

Try a shutdown abort, startup restricted pfile=<yourpfile>,shutdown immediate

This sequence usually cleans things up..

If that fails, and you are on Windows, stop the Oracle service ....then restart it.

 

[scohan]

I'm on Redhat Linux. Thanks a ton, Turkbear. I was able to shutdown abort, startup nomount pfile..., shutdown immediate, and then run the script as it was getting past the create spfile. But now I see the following error on the create database statement.

CREATE DATABASE ecassdev
*
ERROR at line 1:
ORA-01034: ORACLE not available

Getting close...

 

[Turkbear]

Hi,
Very close...
Are you still using:
Startup pfile=<yours>
Connect / as sysdba
Create database...

The Oracle service needs to be started before an instance can be created...
( it has been a long time since I did a RedHat install, so your steps may differ)

 

[scohan]

Actually I'm doing as originally attempted (follows). I'm trying to follow the example for manually starting a databse in the oracle documention (

http://otn.oracle.com/docs/products...release2/server.920/a96521/create.htm#997776)

**************************

CONNECT / AS SYSDBA

-- Create the spfile and startup the database.

CREATE SPFILE FROM PFILE='$ORACLE_HOME/dbs/initecassdev.ora';

STARTUP NOMOUNT

-- Create database

CREATE DATABASE ecassdev
USER SYS IDENTIFIED BY gosps
USER SYSTEM IDENTIFIED BY gosps
LOGFILE GROUP 1 ('/REDOLOG/ecassdev/redo01.log') SIZE 100M,
GROUP 2 ('/REDOLOG/ecassdev/redo02.log') SIZE 100M,
GROUP 3 ('/REDOLOG/ecassdev/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/DATA/ecassdev/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/DATA/ecassdev/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/DATA/ecassdev/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

 

[Turkbear]

Hi,
Try the steps individually :

connect / as sysdba

then

startup nomount pfile=<yourpfile> ( no SPFILE attempt yet)
thenm, if no errors,
Create..etc


See what errors, if any, you get before the Create database statement...

 

[scohan]

That's exactly what I'm doing and it is helping. Since I BACKGROUND_DUMP_DEST=/$ORACLE_BASE/admin/ecassdev/bdump defined in the pfile an alert og is created that is telling me that:

ORA-01501: CREATE DATABASE failed
ORA-01990: error opening password file '/ORACSOFT/app/oracle/product/9.2.0.1.0/dbs/orapw'
ORA-27037: unable to obtain file status

I also have REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
defined in the pfile, but I haven't set up the pw file. So it looks like that's the next step.

Thanks for the steering me in the right direction Turkbear. You're a big help.