Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

beginner - Startup instance.

2663054Apr 28 2014 — edited Apr 29 2014

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 27 2014
Added on Apr 28 2014
5 comments
3,444 views