beginner - Startup instance.

2663054

I'm long time ago trying install oracle database, but unsuccessful.

this error:

$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.2.0 Production on Mon Apr 28 21:04:07 2014


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production


SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01507: database not mounted




ORACLE instance shut down.
SQL> startup
ORACLE instance started.


Total System Global Area 1068937216 bytes
Fixed Size    2233344 bytes
Variable Size  616565760 bytes
Database Buffers  444596224 bytes
Redo Buffers    5541888 bytes
ORA-00205: error in identifying control file, check alert log for more info

/u01/app/oracle/diag/rdbms/xe/xe/trace/alert_xe.log:

Mon Apr 28 21:04:33 2014
ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control2'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/product/11.2.0/xe/dbs/ora_control1'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...

But has no file on "/u01/app/oracle/product/11.2.0/xe/dbs/".

$ rman 


Recovery Manager: Release 11.2.0.2.0 - Production on Mon Apr 28 20:58:15 2014


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> restore controlfile from autobackup;


Starting restore at 28-APR-14
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/28/2014 21:00:01
RMAN-12010: automatic channel allocation initialization failed
RMAN-06171: not connected to target database

lsnrctl:

$ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 28-APR-2014 21:19:15


Copyright (c) 1991, 2011, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                28-APR-2014 20:13:38
Uptime                    0 days 1 hr. 5 min. 36 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "xe" has 2 instance(s).
  Instance "XE", status BLOCKED, has 1 handler(s) for this service...
  Instance "xe", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

/u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File:


XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )


EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

/u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora

# listener.ora Network Configuration File:


SID_LIST_LISTENER =
  (SID_LIST =
    
    (SID_DESC =
      (SID_NAME = xe)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
      (PROGRAM = extproc)
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )


DEFAULT_SERVICE_LISTENER = (XE)

Any help would be greatly appreciated.

Avinash Sangle

Hi...

what is the value of CONTROL_FILES parameter?

also please check your ORACLE_HOME and ORACLE_SID parameters while starting instance.

onkar.nath

the error is self-explanatory. The control files are not present in the location mentioned in spfile/pfile. Check the location in the parameter file and check the location where the control files are present. If files are in different location then just move/copy the files to the location as per parameter file and it will solve the problem. Alternatively, you can also change the location of control files in your parameter file to reflect the actual location and this will also solve the problem.

Onkar

EdStevens

As onkar.nath pointed out, the errors about the control file are self explanatory.  What happened to your control files?  You had a running instance, as evidenced by your initial connection and attempt to start -- start a running instance.

And the error on rman is also self-explanatory:  "RMAN-06171: not connected to target database "

Rman has to connect, just like sqlplus does.  Set ORACL_SID, the connect with the command "rman taraget /".   This is the equivalent of connecting with "sqlplus / as sysdba".

Paul M.

Set ORACL_SID, the connect with the command "rman taraget /".

Ed, I'm becoming your spell checker...

EdStevens

Paul M. wrote:


Set ORACL_SID, the connect with the command "rman taraget /".

Ed, I'm becoming your spell checker... 

OUCH!

And thanks.