Database Security Products (MOSC)

MOSC Banner

create new DB manually

edited Nov 29, 2010 3:49AM in Database Security Products (MOSC) 18 commentsAnswered

Hello Oracleies,

I have a small issue with creating a new DB manually; following are my steps, please help me out to find out my problem:

 

1 created folder structure (admin, datafile, redologs, arch,..)

2 created pfile (in dbs folder)

3 created password file (in dbs folder)

4 run sqplus "/as sysdba"

5 startup nomount using pfile

6 create spfile from pfile (in dbs folder)

7 shutdown immediate

8 run sqplus "/as sysdba"

9 startup nomount 

10 exit from sqlplus

11 run sqlplus "sys/password@db_name as sysdba"

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Nov 25 10:29:46 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

 

oracle user is part of the oinstall and dba group

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center