• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

create database manually

Can you help me to find out the method to create database manually in 11g linux..
0
tomvv
Asked:
tomvv
1 Solution
 
Sushil SonawaneCommented:
0
 
johnsoneSenior Oracle DBACommented:
I would use the doc:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5004.htm#i2061233

Explains all the options and there is a pretty good example at the end.
0
 
tomvvAuthor Commented:
I was trying to install oracle
one made a mistake in one step..

Is there any way to fix.....

below is the problem..


[oracle@mac dbs]$ export ORACLE_SID=sat
[oracle@mac dbs]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 28 10:12:17 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> startup nomount pfile=/u01/app/oracle/product/11.2.0/db_1/dbs/initsat.ora
ORA-01031: insufficient privileges
SQL> conn / as sysdba
ERROR:
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on


SQL> shutdown abort
ORA-09925: Unable to create audit trail file
Linux Error: 2: No such file or directory
Additional information: 9925
SQL> exit
[oracle@mac dbs]$
0
 
johnsoneSenior Oracle DBACommented:
You need to set more than ORACLE_SID to create a database.  You would also need to set ORACLE_HOME and make sure that $ORACLE_HOME/bin is on the PATH and $ORACLE_HOME/lib is on LD_LIBRARY_PATH (or whatever the equivalent variable is in your OS).
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now