create database manually

Posted on 2012-08-28
Last Modified: 2012-09-04
Can you help me to find out the method to create database manually in 11g linux..
Question by:tomvv
    LVL 18

    Expert Comment

    by:Sushil Sonawane
    LVL 5

    Expert Comment

    by:Omid Omarkhail
    LVL 34

    Expert Comment

    I would use the doc:

    Explains all the options and there is a pretty good example at the end.

    Author Comment

    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 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
    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]$
    LVL 34

    Accepted Solution

    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).

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now