Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    South Africa
    Posts
    1

    Angry Unanswered: Command-line creation of Oracle instance using Cygwin

    To anyone who can help:

    I am trying to manually create an Oracle instance using the Cygwin interface with the goal of fully automating Oracle db instance creation. I have been following "Manually Creating an Oracle Database" from the following site:

    http://www.lc.leidenuniv.nl/awcourse...te.htm#1018369

    This has led me to:
    1. Choose a SID for my database: DSTEST5
    2. Create a password file for DB authentication:
    -> as follows: orapwd file=$ORACLE_HOME/database/PWDDSTEST5.ora
    password=sys entries=20
    3. Create the initialisation parameter file:
    $ORACLE_HOME/database/initDSTEST5.ora which looks as follows (similar to Data Warehouse template provided by Oracle)

    ###########################################
    # Cache and I/O
    ###########################################
    db_block_size=8192
    db_cache_size=16777216
    db_file_multiblock_read_count=32

    ###########################################
    # Cursors and Library Cache
    ###########################################
    open_cursors=300

    ###########################################
    # Database Identification
    ###########################################
    db_domain="AIRCOM.CO.ZA"
    db_name=DSTEST5

    ###########################################
    # Diagnostics and Statistics
    ###########################################
    background_dump_dest=D:\oracle\admin\DSTEST5\bdump
    core_dump_dest=D:\oracle\admin\DSTEST5\cdump
    timed_statistics=TRUE
    user_dump_dest=D:\oracle\admin\DSTEST5\udump

    ###########################################
    # File Configuration
    ###########################################
    control_files=("D:\oracle\oradata\DSTEST5\CONTROL0 1.CTL", "D:\oracle\oradata\DSTEST5\CONTROL02.CTL", "D:\oracle\oradata\DSTEST5\CONTROL03.CTL")

    ###########################################
    # Instance Identification
    ###########################################
    instance_name=DSTEST5

    ###########################################
    # Job Queues
    ###########################################
    job_queue_processes=10

    ###########################################
    # MTS
    ###########################################
    dispatchers="(PROTOCOL=TCP) (SERVICE=DSTEST5XDB)"

    ###########################################
    # Miscellaneous
    ###########################################
    aq_tm_processes=1
    compatible=9.2.0.0.0

    ###########################################
    # Optimizer
    ###########################################
    hash_join_enabled=TRUE
    query_rewrite_enabled=TRUE
    star_transformation_enabled=TRUE

    ###########################################
    # Pools
    ###########################################
    java_pool_size=33554432
    large_pool_size=8388608
    shared_pool_size=50331648

    ###########################################
    # Processes and Sessions
    ###########################################
    processes=150

    ###########################################
    # Redo Log and Recovery
    ###########################################
    fast_start_mttr_target=300

    ###########################################
    # Security and Auditing
    ###########################################
    remote_login_passwordfile=EXCLUSIVE

    ###########################################
    # Sort, Hash Joins, Bitmap Indexes
    ###########################################
    hash_area_size=1048576
    pga_aggregate_target=33554432
    sort_area_size=1048576

    ###########################################
    # System Managed Undo and Rollback Segments
    ###########################################
    undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDOTBS1

    ###########################################

    On the fourth step, "Connect to the Instance", I issue the following commands:
    sqlplus /nolog
    connect sys/sys@dstest5 as sysdba

    This origionally gave the error
    TNS-12560: TNSrotocol adapter error

    After adding the following to tnsnames.ora:

    DSTEST5.AIRCOM.CO.ZA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = air011)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = DSTEST5)
    )
    )

    and the following to listener.ora within the SID_LIST:

    (SID_DESC =
    (GLOBAL_DBNAME = DSTEST5)
    (ORACLE_HOME = D:\oracle\ora92)
    (SID_NAME = DSTEST5)
    )

    the error changed to:
    ORA-12500: TNS:listener failed to start a dedicated server process

    What does this mean??? How can I connect to the instance in order to issue STARTUP NOMOUNT and then CREATE DATABASE commands?

    Any help will be much appreciated.

    Regards

    Jeremy

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I'm a *nix bigot & avoid Windoze whenever possible.
    First & foremost, SQL*Net is NOT required to interoperate with an Oracle DB, at least it is not on any *nix box.
    On *nix when logged directly onto the DB server itself, only a few environmental variables are required; ORACLE_SID, ORACLE_HOME, & PATH.
    The use of "@dstest5" forces SQL*Net to be used.
    IIRC, on Windoze a different/additional environmental variable (LOCAL?) needs to be set to the SID.

    HTH & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    read the docs please.

    anyways, as stated above, you need to set the environment variables:
    ORACLE_SID & ORACLE_HOME

    *nix commands:
    ORACLE_HOME=/appl/oracle/product/9.2.0.2
    export ORACLE_HOME
    PATH=$PATH:$ORACLE_HOME/bin

    ORACLE_SID=dstest5
    export ORACLE_SID


    windoze commands:
    set ORACLE_SID=dstest5

    also, since windoze SUCKS you need to also issue an oradim command:
    oradim -new -sid %ORACLE_SID% -pfile c:\path\to\some\init.ora

    ONE MORE THING:
    be sure your sqlnet.ora file contains this line:
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    Last edited by The_Duck; 01-03-05 at 10:49.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •