Home » RDBMS Server » Server Administration » Oracle Upgrade to 11G issue (11 R2)
Oracle Upgrade to 11G issue [message #573416] Fri, 28 December 2012 05:08 Go to next message
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..
Re: Oracle Upgrade to 11G issue [message #573419 is a reply to message #573416] Fri, 28 December 2012 05:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00205: error in identifying control file, check alert log for more info
 *Cause:  The system could not find a control file of the specified name and
           size.
 *Action: Check that ALL control files are online and that they are the same
         files that the system created at cold start time.

Regards
Michel
Re: Oracle Upgrade to 11G issue [message #573420 is a reply to message #573419] Fri, 28 December 2012 05:13 Go to previous messageGo to next message
nikhiljuneja@gmail.com
Messages: 8
Registered: December 2012
Location: Delhi
Junior Member
I am unable to find any control file in the directory which i had specified. COuld you please tell if i can create them now?
Re: Oracle Upgrade to 11G issue [message #573424 is a reply to message #573420] Fri, 28 December 2012 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore them from a backup or use CREATE CONTROLFILE statement.

Regards
Michel
Re: Oracle Upgrade to 11G issue [message #573427 is a reply to message #573424] Fri, 28 December 2012 06:07 Go to previous messageGo to next message
nikhiljuneja@gmail.com
Messages: 8
Registered: December 2012
Location: Delhi
Junior Member
It is a new created database. I m unable to find any ctl file in the directory structure.

Could you please suggest if I should recreate the new database?
If yes, could you please provide me with the relevant steps for removal and creating a new one.

Thanks and Regards,
Nik
Re: Oracle Upgrade to 11G issue [message #573428 is a reply to message #573427] Fri, 28 December 2012 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you upgrade an existent database or do you create a new database?

Regards
Michel
Re: Oracle Upgrade to 11G issue [message #573431 is a reply to message #573428] Fri, 28 December 2012 06:49 Go to previous messageGo to next message
nikhiljuneja@gmail.com
Messages: 8
Registered: December 2012
Location: Delhi
Junior Member
I have deleted the old one using Database Configuration Assistant.
I had removed the 10G and trying to install 11G
Re: Oracle Upgrade to 11G issue [message #573436 is a reply to message #573431] Fri, 28 December 2012 08:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you deleted the database why do you try to start it?
Create a new one before, using dbca.

Regards
Michel

[Updated on: Fri, 28 December 2012 08:49]

Report message to a moderator

Re: Oracle Upgrade to 11G issue [message #573439 is a reply to message #573436] Fri, 28 December 2012 08:58 Go to previous messageGo to next message
nikhiljuneja@gmail.com
Messages: 8
Registered: December 2012
Location: Delhi
Junior Member
Thanks Michel for all your inputs..

I removed the Database and created a new one using Database configuration Assistant.

Now its working fine as expected.
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production



A small query though, while connecting from cmd prompt i am able to do it successfully as sysdba and any other user like hr

But while connecting using sys or system and providing the Oracle SID it gives me the following error:

C:\Users\Nik>sqlplus system@orcl
 
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 28 20:15:32 2012
 
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
 
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
 



Could you please tell why this is coming?

Thanks,
Nik
Re: Oracle Upgrade to 11G issue [message #573442 is a reply to message #573439] Fri, 28 December 2012 09:12 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You do not need SQL*Net (and @ connection) for a local database, just set ORACLE_SID (and ORACLE_HOME).

Regards
Michel

[Updated on: Fri, 28 December 2012 09:13]

Report message to a moderator

Previous Topic: users creation limits
Next Topic: TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
Goto Forum:
  


Current Time: Fri Mar 29 00:34:41 CDT 2024