| Oracle Upgrade to 11G issue [message #573416] |
Fri, 28 December 2012 05:08  |
 |
nikhiljuneja@gmail.com
Messages: 8
Registered: December 2012
Location: Delhi
|
Junior Member |
|
|
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..
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
