Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to do the startup command

this is what I have done

set oracle_sid=ORCL
sqlplus /nolog
SQL> conn /as sysdba
startup

It shows this error message,

 failure in processing system parameters
 could not open parameter file "C:\Program\11.2.0\DBhome_1\Database\initorcl.ora"

I went to check and found out that "initoracl.ora" doesn't exist inside the path

 "C:\Program\11.2.0\DBhome_1\Database"

I found a init.ora file in

 "C:\Program\11.2.0\dbhome_1\dbs"

I tried doing this command

 startup pfile="C:\Program\11.2.0\dbhome_1\dbs\init.ora"

It shows this error

 invalid value given for the diagnostic_dest init.ora parameter
 the specified ADR Base Directory does not existed [C:\program\11.2.0\dbhome_1\database\<oracle_base>]
 specific directory does not exist
 additional error information
 <OS 123> the filename, directory name, or volume syntax is incorrect.

What should I do?

share|improve this question

migrated from stackoverflow.com Jan 25 at 17:26

This question came from our site for professional and enthusiast programmers.

    
How was the database created? Has it started before? Does the initorcl.ora exist somewhere else, or do you have a valid spfile? –  Alex Poole Jan 25 at 12:42
    
I checked. there's no initorcl.ora or spfile. I am really sure how to create a database or whether a database is created as I am using this software the first time. where do I get this initorcl.ora file from? –  user3213758 Jan 25 at 13:58
    
What is %ORACLE_HOME% set to? Is your database definitely called ORCL? Are you certain a database has even been created? –  Phil Jan 26 at 5:40

1 Answer 1

There is 2 way to solve the problem.

One way is that, there might be another *.ora file (e.g spfileyourdbname.ora). If there is, just do the same thing as you did:

    SQL> startup pfile = 'C:\Program\11.2.0\dbhome_1\dbs\spfileyourdbname.ora'

Or Another way is, just copy the below codes, change the relevant directories and parameters, and save in the required directory (e.g $ORACLE_HOME/dbs/) as 'spfileyourdbname.ora'. Then just do the same thing:

    SQL> startup pfile = 'C:\Program\11.2.0\dbhome_1\dbs\spfileyourdbname.ora'


'mydb' is the name of your database [SID].

Codes to copy:

    mydb.__data_transfer_cache_size=0
    mydb.__db_cache_size=255852544
    mydb.__java_pool_size=12582912
    mydb.__large_pool_size=8388608
    mydb.__oracle_base='/home/yeyintkoko/app/oracle'#ORACLE_BASE set from environment
    mydb.__pga_aggregate_target=180355072
    mydb.__sga_target=536870912
    mydb.__shared_io_pool_size=20971520
    mydb.__shared_pool_size=226492416
    mydb.__streams_pool_size=0
    *.audit_file_dest='/home/yeyintkoko/app/oracle/admin/mydb/adump'
    *.audit_trail='db'
    *.compatible='12.1.0.0.0'
    *.control_files='/home/yeyintkoko/app/oracle/oradata/mydb/control01.ctl','/home/yeyintkoko/app/oracle/fast_recovery_area/mydb/control02.ctl'
    *.db_block_size=8192
    *.db_domain=''
    *.db_name='mydb'
    *.db_recovery_file_dest='/home/yeyintkoko/app/oracle/fast_recovery_area'
    *.db_recovery_file_dest_size=4800m
    *.diagnostic_dest='/home/yeyintkoko/app/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=mydbXDB)'
    *.enable_pluggable_database=true
    *.log_archive_format='%t_%s_%r.dbf'
    *.open_cursors=300
    *.pga_aggregate_target=170m
    *.processes=300
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=510m
    *.undo_tablespace='UNDOTBS1'
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.