could not open parameter file error message
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: could not open parameter file error message

  1. #1
    Join Date
    Nov 2004
    Posts
    20

    could not open parameter file error message

    Am trying to create database manually but with no luck. Am trying to do this on windows xp pro. Here are my steps. I set the enviroment and a new instance using oradim command. setup a password with orapwd file. At the command prompt i set the oracle_sid. log on sqlplus

    sqlplus /nolog

    connect /as sysdba

    startup nomount -after typing this statment i get the error

    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file 'C:\U01\APP\ORACLE\PRODUCT\9204\DATABAS
    E\INITDBSTUDEN.ORA

    I do have a pfile in the location named above. Below is a copy of my pfile

    ##############################################################################
    # Copyright (c) 1991, 2001 by Oracle Corporation
    ##############################################################################

    ###########################################
    # Cache and I/O
    ###########################################
    db_block_size=2048
    #db_cache_size=83886080
    db_cache_size=80M

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

    ###########################################
    # Diagnostics and Statistics
    ###########################################
    background_dump_dest=/u01/app/oracle/admin/dbstuden/bdump
    core_dump_dest=/u01/app/oracle/admin/dbstuden/cdump
    timed_statistics=TRUE
    user_dump_dest=/u01/app/oracle/admin/dbstuden/udump

    ###########################################
    # Distributed, Replication and Snapshot
    ###########################################
    remote_login_passwordfile=NONE
    os_authent_prefix = "ops$"
    global_names=true
    db_domain="okc.us"
    job_queue_processes=4
    #job_queue_processes=0
    open_links=8
    #parallel_automatic_tuning=true
    parallel_max_servers=10
    parallel_min_servers=0
    replication_dependency_tracking=true
    utl_file_dir=/u01/app/oracle/admin/dbstuden/utlfiles

    ###########################################
    # File Configuration
    ###########################################
    control_files=("/u02/oradata/dbstuden/control01.ctl", "/u03/oradata/dbstuden/control02.ctl", "/u04/oradata/dbstuden/control03.ctl")

    ###########################################
    # MTS
    ###########################################
    # Uncomment the following line when your listener is configured for SSL
    # (listener.ora and sqlnet.ora)
    # dispatchers = "(PROTOCOL=TCPS)(SER=MODOSE)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
    # dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

    ###########################################
    # Miscellaneous
    ###########################################
    compatible=9.2.0.4.0
    db_name=dbstuden

    ###########################################
    # Network Registration
    ###########################################
    instance_name=dbstuden
    service_names=dbstuden
    local_listener="(address=(protocol=TCP)(host=mouse)(port=1521))"

    ###########################################
    # Pools
    ###########################################
    sga_max_size=250M
    #java_pool_size=51200
    java_pool_size=20M
    large_pool_size=20M
    shared_pool_size=100M
    pga_aggregate_target=80M
    workarea_size_policy=auto
    db_16K_cache_size=16M

    ###########################################
    # Archiving
    # Uncommenting the lines below will cause
    # automatic archiving if archiving has
    # been enabled using
    # ALTER DATABASE ARCHIVELOG.
    ###########################################
    #log_archive_start = true
    #log_archive_dest = "/u01/app/oracle/admin/dbstuden/arch"
    #log_archive_format = arch_%t_%s.arc

    ###########################################
    # Processes and Sessions
    ###########################################
    processes=500

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

    ###########################################
    # Resource Manager
    ###########################################
    resource_manager_plan=SYSTEM_PLAN

    ###########################################
    # Sort, Hash Joins, Bitmap Indexes
    ###########################################
    sort_area_size=1048576

    ###########################################
    # System Managed Undo and Rollback Segments
    ###########################################
    undo_management=AUTO
    undo_tablespace=UNDOTBS

    ###########################################
    # Log Write Tuning
    ###########################################
    log_buffer=1048576

    ###########################################
    # Query Rewrite Settings
    ###########################################
    query_rewrite_enabled=true
    query_rewrite_integrity=trusted

    Thanks in advance.
    Last edited by anakolo; 01-15-2006 at 05:24 PM.

  2. #2
    Join Date
    Nov 2004
    Posts
    20

    The operating system is windows xp pro.

    Sorry i forgot to mention that the operating system is windows xp pro.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    prove it, to d 'dir' command in that directory fom a dos prompt

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    looking at it again, you got everything messed up in there

    you say you are on windows but your init.ora is full of unix paths?

Posting Permissions

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


Click Here to Expand Forum to Full Width