Oracle Database Discussions

Hi All,

I have been trying to upgrade my personal laptop with 11G from 10G.

Since I didn't had any important data, so i removed 10G and tried to go for a fresh install of 11G.

Below are the entries of my files:

Listener.ora

# listener.ora Network Configuration File: C:\app\Nik\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL.WORLD)
      (ORACLE_HOME = C:\app\Nik\product\11.2.0\dbhome_1)
      (SID_NAME = ORCL)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Nik\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle8)
      (ORACLE_HOME = C:\app\Nik\product\11.2.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Nik-Laptop)(PORT = 1521))
  )

ADR_BASE_LISTENER = C:\app\Nik

TNSNAMES.ORA

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Nik-Laptop)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL.WORLD)
    )
  )

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 trace_level_client = 16
trace_file_client = cli
trace_directory_client = c:\trace
trace_unique_client = on
trace_timestamp_client = on
trace_filelen_client = 100
trace_fileno_client = 2
log_file_client = cli
log_directory_client = c:\trace\log
tnsping.trace_directory = c:\trace\trace
tnsping.trace_level = admin 

INITORCL.ORA

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='C:\app\Nik\product\11.2.0\dbhome_1\admin\orcl\adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='C:\app\Nik\product\11.2.0\dbhome_1\flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='C:\app\Nik\product\11.2.0\dbhome_1'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1.ctl, ora_control2.ctl)
compatible ='11.2.0'

If i start the database in nomount it doesn't give any error.

Once I try to mount it, it gives the following error:

SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying control file, check alert log for more info

SQL> show parameter control;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      C:\APP\NIK\PRODUCT\11.2.0\DBHO
                                                 ME_1\DATABASE\ORA_CONTROL1.CTL
                                                 , C:\APP\NIK\PRODUCT\11.2.0\DB
                                                 HOME_1\DATABASE\ORA_CONTROL2.C
                                                 TL
control_management_pack_access       string      DIAGNOSTIC+TUNING

Could you please help me if i am missing anything here..