Cannot Start Oracle DB After Hardware Failure / Recovery

Sep 12, 2013

We have a server that crashed due to hardware failure and although brought back up OK Oracle DB's are no longer mounting. I am not a DBA but it looks bad to me and it seems there are no backups. This is Oracle 11G XE running on Centos 6. There is no Oracle contract here.

[root@627963 trace]# sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 12 23:18:26 2013

Copyright © 1982, 2011, Oracle. All rights reserved.

SQL> connect sys as sysdba;
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size 2233344 bytes
Variable Size 893389824 bytes
Database Buffers 167772160 bytes
Redo Buffers 5541888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 10571
Session ID: 62 Serial number: 3

SQL> startup /nomount
SP2-0714: invalid combination of STARTUP options
SQL> startup nomount
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>

Alert_XE.log:

Thu Sep 12 21:26:18 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0

[Code]....

View 1 Replies


ADVERTISEMENT

Backup & Recovery :: How To Start Database In Oracle

Dec 29, 2011

how to start database in oracle

View 2 Replies View Related

Backup & Recovery :: Unable To Auto-start Oracle Net Listener

Dec 30, 2011

when i try to run dbstart i got Message like "

ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME
Processing Database instance "orcl": log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log

how to set oracle listener ? i tried using listener.ora file again show the same error

View 3 Replies View Related

Backup & Recovery :: Standby Clone Failure?

Mar 26, 2012

I have run a standby clone that terminated with error due to few missing LV-s. I removed all LV-s for the clone, recreated them including the missing ones. I ran the clone again,but it skips the files that were successfuly duplicated in the previous clone request that failed. I need to be able to start the clone all over again, but RMAN does persistantly skip duplicating the datafiles that were successfuly processed in the first atempt.

How to ignore the RESUME option so that the clone process would start from the beginning? Where does RMAN keep the info about the successfuly duplicated datafiles in clone standby process? I have tried few RMAN tables , but no luck.

View 1 Replies View Related

Backup & Recovery :: Trying To Recover Database After Disk Failure

May 4, 2011

multiple disk failure, the database was open at the time.We have managed to recover the data from the disk and have put it on another disk.We have got a new server with oracle 9 running.

A blank database has been created.I have copied the control files and redo files onto the new server and left the datafiles , (.dbf,.ora) on a seperate external disk F drive (this is because the original database resided on F drive)I can mount the database , however when I try to open it I get the following

ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'F:ORACLEORADATALCMPROSYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile

View 25 Replies View Related

Backup & Recovery :: How To Recover Unarchived Data In Case Of Media Failure

Jan 26, 2012

I have a database for which I use RMAN for backup & recovery. The database is in archivelog mode. Online redo log files are multiplexed and I have more than one destinations for archive logs. If, due to a disk crash, all data files and redo log files are gone - and I have archive logs, one member of each redo log group and a full database backup available, I can recover till the last archived log. But I want to ask that what about the transactions which were not archived at the time of media failure? How can I recover committed transactions which were not archived at the time of crash, and I have a mirrored copy of log group which was current at the time of failure?

View 5 Replies View Related

Recovery Manager (RMAN) :: Can't Start Database And Backup?

Sep 18, 2013

Can't start the Database and can't backup What is happening now. My database connection is not stable so can't do the backup.I spent two days trying unsuccessfully.

check the following print screen : [test@localhost ~]$ xhost +access control disabled, clients can connect from any host[test@localhost ~]$ [test@localhost ~]$ [test@localhost ~]$ su - rootPassword: [root@localhost ~]# [root@localhost ~]# [root@localhost ~]# su - oracle[oracle@localhost ~]$ [oracle@localhost ~]$ export ORACLE_SID=db11gr2[oracle@localhost ~]$ [oracle@localhost ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1[oracle@localhost ~]$

[code]....

View 13 Replies View Related

Communication Failure In Oracle AQ With Firewall ON

Jul 21, 2010

I have two machines with oracle 11g . Both having ODP 11.2 Beta. I've to communicate between these two machines using Oracle Advanced queuing. The message sent from one machine will reach the second machine only if the Firewall of both machine is OFF.But based on requirement, we cannot switch OFF firewall or add exceptions as ports or applications.

View 1 Replies View Related

Installation :: Fail To Start OCR And OS / Error When Start OracleCSService

Jun 5, 2012

I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:

First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.

At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".

View 3 Replies View Related

Server Administration :: Database Connection Failure - Oracle Not Available

May 28, 2010

I'm getting the error messaage:

Database Connection failure. Reason: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

I'm not an Oracle expert, but I have research a little and seems that the SID could be wrong or that the DB is down, in fact I have already checked trhe server but everything seems normal to me.

View 3 Replies View Related

RAC & Failsafe :: Oracle CRS Failure / Rebooting For Cluster Integrity

Sep 7, 2013

I got following error on Oracle 10.2.0.4.0 RAC on solaris 10

Oracle clsomon failed with fatal status 12.

Oracle CRS failure. Rebooting for cluster integrity.

I think this problem in 11g but I am using 10g.

View 14 Replies View Related

Server Administration :: Oracle Database Configuration Assistant Failure

Feb 1, 2012

I m using Windows Vista Business 32 bit , Oracle 10.2.0.3

while running my setup so many time i got same error each and every time Error:12560 TNS Protocol Adapter error and it shows me i attached my screen shot with my thread , and remember i already installed earlier but at that time there was no error and successfully installed, i removed the total software before installing and i also removed my environment variable and after getting this Database Configuration Assistant failure there is no service is started regarding my database.. I also tried manually but there also i got some other problem if by Database Configuration Assistant it ll b solved then it ll be good for me.

View 9 Replies View Related

Unable To Start Oracle Listener

Aug 30, 2010

Recently, I've just restored my QAS database and filesystem from my backup tape. I have checked all the configuration files and oracle setting files and do not notice any problem.

However, when I tried to start my listener, it shows some error messages as below. As a result, I'm unable to start my SAP application.

Error:
-------
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...

For you information, I'm able to start my Oracle instance. Please refer to below.

SQL> startup mount
ORACLE instance started.

Total System Global Area 5620367360 bytes
Fixed Size 2064184 bytes
Variable Size 2818572488 bytes
Database Buffers 2785017856 bytes
Redo Buffers 14712832 bytes
Database mounted.

oraqas 3> lsnrctl start

LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 12:57:25
Copyright � 1991, 2007, Oracle. All rights reserved.

Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-------------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 30-AUG-2010 12:57:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))

Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

View 6 Replies View Related

Enterprise Manager :: How To Start - Downloaded Oracle 11g

Oct 5, 2012

I have just downloaded Oracle 11g from the Oracle website.How do I start enterprise manager?

but once I get away from UNIX I don't have a clue what I am doing. What are the windows bits. I go to the oracle bin directory from a dos window and enter emctl commands, and I get "emctl" is not recognised as an ibternal or external command.

View 3 Replies View Related

Windows :: Oracle Service Doesn't Start

Oct 3, 2012

I've installed oracle 11.2 in Windows 7 - 64 bits. Everything was working fine until suddenly stops working. Oracle Service (OracleServiceORCL) doesn't start and when I try to start manually, returns OS error 1067. Listener starts well. Below I list my listener.ora, sqlnames.ora and sqlnet.ora

# listener.ora Network Configuration File: C:appmbaproduct11.2.0dbhome_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

[code]....

View 3 Replies View Related

Server Administration :: Oracle 8i Service Did Not Start

Apr 27, 2013

I have oracle8i database on windows 2008 but not a domin server now i have domin server and i want to join this server on domin network i try to join domin it fine but my oracle8i service did not start what to do ?

old hostname=bagmati
afterchange hostname=bagmati.alkatel.org.np

View 3 Replies View Related

Express Edition (XE) :: Oracle 11g R2 Doesn't Start?

Sep 3, 2013

I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output 
Starting Oracle Net Listener...Done
Configuring database...

Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

When I look at the logs I get the following error ORA-01034: ORACLE not available.  After receiving this error I have attempted to start Oracle manually.

sqlplus "/as sysdba"
 
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
 
As you can see I got

ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions 

/u01/app/oracle/product/11.2.0/xe/config/log# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/sda1                 46G  9.7G   34G  23% /
none                     4.0K     0  4.0K   0% /sys/fs/cgroup

[code]...

View 4 Replies View Related

SQL & PL/SQL :: Oracle Jobs Not Start Automatically As Per Interval?

Dec 20, 2010

My Oracle jobs are not running. I can run them manually but they don't start automatically as per interval. The job_queue_processes=100 and CJQ process is not running. I started CJQ0 process by resetting it to 0 and then to 100. But as soon as I enabled a job this background process stopped.

The job also did not execute in its next execution time. I have created the database manually without using DBCA. Is the problem because of this? I have set crontab immediately to get rid of it.

View 4 Replies View Related

Way To Start Oracle Database 10g Express Edition On Fedora

Sep 29, 2007

am having problems starting Oracle Database 10g Express Edition on Fedora. Here is what I did in order to start it:

[root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start
[root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost +
access control disabled, clients can connect from any host

Not sure what I am doing wrong here.

View 2 Replies View Related

RAC & Failsafe :: Hierarchy To Stop And Start Oracle RAC Instance

Apr 20, 2013

What is the hierarchy to stop and start oracle RAC instance ?

View 10 Replies View Related

Server Administration :: Oracle Tracing At Stop And Start

Jan 20, 2012

I need to add some kind of tracing in oracle 11g on linux when oracle starts and stops - as at times oracle takes a long time to start.

View 9 Replies View Related

Unable To Start Oracle Database 11g On Linux Machine?

Nov 12, 2012

Issue : NOT able to start the Oracle Data Base 11g on Linux machine

I've successfully installed Oracle-DB-11g on my Linux machine.

Note : I haven't declared or exported any variable(s) , actually I'm not sure how and where to do this.

View 1 Replies View Related

Express Edition (XE) :: Oracle Doesn't Start Correctly With 3G Router

Oct 7, 2013

I have used a HUAWEI dongle directly connected to my PC. First, the operating system and Oracle start up, then I connect to the internet using the Huawei Mobile Partner utility. Any application can connect to Oracle and use it correctly. All OK. Now I have added a 3G router which is connected to the PC by ethernet cable and has the Huawei dongle connected to a USB port on the router. All works correctly if I follow the sequence: 

1) Start the PC with the router switched off, and wait until Oracle has fully started. 

2) Power the router up and wait 2 minutes until Windows says the 100 Mb ethernet link is open. Oracle.exe in Task Manager is about 210 Mb, and sometimes more, depending on activity. 

However, if I switch on the router first and then start the PC, Oracle does not start correctly. It rejects connection requests forever more, indicating Network Adapter could not establish the connection: Code 17002.In Task Manager Oracle.exe occupies only 145Mb. What can I do to get it to start correctly ? I can dig into Listener.ORA, TNSNAMES.ORA and HOSTS without any problems, and have often modified them manually (not the case here), but logs and traces escape me !

View 3 Replies View Related

Automatic Storage Management :: Cannot Start ASM On Oracle Database Appliance

Apr 11, 2013

I cannot start ASM on my Oracle Database Appliance.

crsctl status resource -t says:
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started

however, if I try to access the ASMCMD it says:
[grid@node1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> startup
ORA-00304: requested INSTANCE_NUMBER is busy
Connected to an idle instance.

View 13 Replies View Related

Oracle Solaris 11 Database Control Failed To Start Set ORACLE_UNQNAME

Apr 20, 2013

Oracle Solaris 11
Oracle Database 11.2.0.3

Create a new database using dbca and at the end dbca reports it could not start database control.

The dbca warning window asks to set ORACLE_UNQNAME and to start database control again.

su - oracle
$ . oraenv
rcat
export ORACLE_UNQNAME=rcat
emctl stop dbconsole
emctl start dbconsole
failed...

I tried that and dbconsole still cannot start.

View 3 Replies View Related

Networking And Gateways :: Start Multiple Listeners In One Oracle Database?

Dec 6, 2011

can i start multiple listeners in one oracle database ?

View 7 Replies View Related

Installation :: 11g On Windows 2008 R2 - Unable To Start Oracle Service

Aug 30, 2012

I tried to reinstall oracle 11g on windows 2008 R2 and couldn't complete the installation as i am unable to start the oracle service. The system gives the following error message

Instance created.
DIM-00019: create service error
O/S-Error: (OS 1053) The service did not respond to the start or control request
in a timely fashion.

I try to manually create the service and it gives me the same error.I also tried to start the service using the net start as follows

C:UsersAdministrator>net start oracleserviceprod
The service is not responding to the control function.

Having looked at the event viewer in windows, I noticed three different error messages as followsr

Application popup: Microsoft Visual C++ Runtime Library : Runtime Error!

Program: c:appadministratorproduct11.2.0dbhome_1inORACLE.EXE

R6034
An application has made an attempt to load the C runtime library incorrectly.and then A timeout was reached (30000 milliseconds) while waiting for the OracleServiceprod service to connect.

The OracleServiceprod service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

View 26 Replies View Related

TNS-04012 - Unable To Start Oracle Connection Manager Instance?

Apr 3, 2013

I've tried to configure Connection Manager but i fails on TNS-04012: Unable to start Oracle Connection Manager instanceThis is my configuration (

CMAN1=(CONFIGURATION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=1522))
  (RULE_LIST=
   (RULE=(SRC=*)(DST=<IP>)(SRV=*)(ACT=accept))))

[code]...

View 3 Replies View Related

Windows :: Unable To Start DBCONSOLE After Initial Installation Of Oracle 11gR2?

May 29, 2013

unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost

[code].....

I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.

View 7 Replies View Related

Client Tools :: Database Won't Start / Unable To Initialize Oracle Call Interface

Mar 10, 2010

I am facing the problem in windows 7. I have oracle client 10g installed. When i run sqlplus from comand prompt it gives the error as:

C:Userssrirams>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

When I select the executable 'sql+' and run as administrator it works fine.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved