Standby Auto Startup On OEL 5

Sep 14, 2012

I have to make this script . It should be something like this :

starting of lsnrctl.......
startup mount;
alter database open read only;
recover managed .....................;

and a second script is to shut down everything correctly during Linux shutdown..I think it would be better to make a new Linux service . make a whole script? Oracle 11.2, Oracle Linux 5

View 2 Replies


ADVERTISEMENT

RAC & Failsafe :: How To Set Auto Startup When OS Start

Mar 24, 2012

I have installed a rac database,when the os start,and the database can not auto start,how to make the database auto start when OS start?

View 1 Replies View Related

Auto Startup Active DataGuard After Reboot

Apr 6, 2011

I try to auto startup my standby database after reebot machine. I used trigger " on startup" , srvctl but still it doesn't work..Database 11g , operating system RedHat 5 or HP-UX.

View 2 Replies View Related

Data Guard :: Standby DB Cannot Do Auto Recovery?

Apr 23, 2013

I have done the configs as per the guide here [URL] .... This is a physical standby db

Primary initBP1.ora
compatible = "11.2.0"
log_archive_dest_1 = "LOCATION=H:oracleBP1oraarchBP1arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=BP1"
log_archive_dest_2 = "SERVICE=BP1_DR VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
[code]...

How I do I make sure that the DR site is recovering automatically ?

View 10 Replies View Related

Data Guard :: Apply Standby Redo Log To Physical Standby Database

May 26, 2013

I have dataguard configuration operating in maximum availability mode with a local standby db (A - lgwr sync not using real time apply) and a remote standby db (B - lgwr async). I then simualted a crash of my primary database with batch jobs running. Since the stby db A is in lgwr sync option ,all the commited data in the current online redo log has been transmitted to stby A and is present in its stby redo log (Group 2).How do I apply this stby redo log to the remote stby db.

Tried the following methods.

1.ftp the stby redo log to the remote db and tried to regiter it, got an error that it is not completely archived.

2.issued the recover standby database command and supplied the stby redo log when it asked for the sequence in the stby redo, got an error saying there is corruption in a block(tried this option multiple times ended up with the same result.)

View 5 Replies View Related

Data Guard :: Possible To Convert Logical Standby To Physical Standby

Aug 30, 2013

My steps for testing as below:

1.create a primary database
2.duplicate a physical standby database;
3.turn on flashback on both databases.
4.record SCN xxx on physical standby database.
5.convert physical standby to logical standby (using keep identity statement)
6.flashback to logical standby to xxx
7.convert logical standby to physical standby
8.using real time apply I got errors: Fast Parallel Media Recovery enabledManaged Standby Recovery starting Real Time ApplyMRP0:

Background Media Recovery waiting for new incarnation during transient logical upgrade procedure

Errors in file /home ora/ app/ oracle/ diag/ rdbms/ ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:ORA-19906: recovery target incarnation changed during recoveryManaged Standby Recovery not using Real Time ApplyErrors in file /home/ ora/app/ oracle/diag/ rdbms/ ora11gr1dg/ ora11gr1dg/ trace/ora11gr 1dg_mrp0_ 10120.trc:ORA-19906: recovery target incarnation changed during recovery  

Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.Standby database incarnation:

List of Database IncarnationsDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time-------1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:182 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01     BGV

View 2 Replies View Related

Physical Standby Database To Logical Standby

Jul 17, 2013

can i create physical standby database to logical standby database.

my structure
============

primary database--->physical standby-->logical standby

for fail over case ==>physical standby convert to primary and logical standby connected to current primary database.

View 3 Replies View Related

Data Guard :: Standby Redo Log On Standby

Apr 24, 2011

GROUP# THREAD# SEQUENCE# sizeMB ARC STATUS T
---------- ---------- ---------- ---------- --- ---------------- -
1 1 115 512 YES CLEARING O
2 1 116 512 YES CURRENT O
6 1 114 512 YES CLEARING O
4 1 112 512 YES CLEARING O
5 1 113 512 YES CLEARING O
3 1 111 512 YES CLEARING O

6 rows selected.
[code]...

Above result is from standby database.I am trying to understand the concept of standby redo log.My stadby database protection_mode is MAXIMUM PERFORMANCE.

View 10 Replies View Related

RAC ASM Complete Shutdown And Startup

Jul 7, 2011

I need to take the certain logs on my 3-Node, 10gR2 RAC with ASM on Solaris 10.I have been asked to shutdown the database, nodeapps, listener, asm and crs and then restart crs. Below are t steps that I have prepared.

CODE
====Enable trace=========
ENABLE LEVEL 5 tracing-
./crsctl debug log crs allcomp:5
====Stop database, asm, listener, nodeapps finally crs===
1. STOP DATABASE
srvctl stop database -d DB_NAME
[code]....

View 2 Replies View Related

Unable To Login And Startup Database

May 15, 2011

I tried to login and start my db this evening and I receive the following message

[oracle@dbs]$ export ORACLE_SID=ORCL
[oracle@ukedxdtmtdbs01a dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sat May 14 19:59:48 2011
Copyright © 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on

How can I resolve - none of the passwords I enter seem to work? I have these init files

ls -ltr init*.ora

-rw-r--r-- 1 oracle oinstall 2867 May 14 18:53 init.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 19:12 initORCL.ora

my init.ora file looks like this:

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/adump'
audit_trail ='db'
[code]...

db had been up and running for about 2 weeks with no issues since installation..I am just trying to get the db up and running - nothing more

View 14 Replies View Related

Automating Database Startup And Shutdown?

Jan 5, 2012

We are having a problem trying to automate our 11g database startup on a Linux Platform (Redhat). This is the procedure we followed.

1. Logged in as the root user.

2. Edited the oratab file for the platform.

vi /etc/oratab
db:/u01/app/oracle/product/11.2.0/dbhome_1:Y

3. Create a file called dbora in /etc/init.d directory

4. Entered the following in dbora:

#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

[Code] .....

4. Changed permissions of dbora

chgrp dba dbora
chmod 750 dbora

5. Created symbolic links to the dbora script in the appropriate run-level script directories:

# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

Have I covered everything needed? At system restart the listener and database fail to startup as expected.

View 4 Replies View Related

RAC & Failsafe :: Startup Sequence 10g RAC Database With ASM?

Dec 28, 2012

I want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again

I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence

1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs

2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs

3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1

4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2

5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1

6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2

7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB

A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?

View 9 Replies View Related

Server Administration :: Database Startup?

Apr 27, 2010

MY oracle database is not starting ,at startup its giving me following error message .

ORA-00600: internal error code, arguments: [kccext_info_4], [], [], [], [], [],[], []

Alert Log file showing following message ,

Tue Apr 27 14:22:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Apr 27 14:22:26 2010
ARC1: Becoming the heartbeat ARCH
Tue Apr 27 14:22:26 2010
db_recovery_file_dest_size of 2048 MB is 36.88% used.

This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],

[code]...

If i connect with scott user ,following message occurs ,

ORA-01033: ORACLE initialization or shutdown in progress

View 2 Replies View Related

Forms :: Failure In Server During Startup

Dec 17, 2011

FRM-92101...There was a failure in the Forms Server during startup. this could happen due to invalid configuration. Look into the web-server for the details.

Details...
Java Exception:
Oracle.forms.net.ConnectionException:Forms Session<74> failed during startup: no response from runtime process
at oracle.forms.net.HTTPNStream.getResponse(unknown source)
at oracle.forms.net.HTTPNStream.doFlust(unknown source)
[code]....

View 3 Replies View Related

Forms :: Oracle 9i Errors On Startup?

Feb 11, 2011

We have an application that uses Oracle Forms 9i AS R2 that has been running happily for many years. There are two servers that run the client side application and provide the users with access to a single database. Two weeks ago one of the two servers started expperiencing issues, then yesterday the second server started experiencing issues also. The problem appears to relate to the Java component of the service. Typically what happens is that the user runs a batch file that starts the following java command:

C:OraHome1jdkinjava -Dorg.omg.CORBA.ORBClass=com.inprise.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.inprise.vbroker.orb.ORB -Doracle.security.jazn.config=C:OraHome1j2eeOracle9iDSconfigjazn.xml -Doracle.home=C:OraHome1 -DORACLE_HOME=C:OraHome1 -jar C:OraHome1j2eehomeoc4j.jar -userThreads -config C:OraHome1j2eeOracle9iDSconfigserver.xml

This should start a service that listens for connections on port 8888. Internet Explorer then fires up and establishes a connection to the listening port. Unfortunately we never get that far. We receive the following error and the Java service never starts so the IE conection fails to connect to the service on port 8888. unexpected exception has been detected in native code outside the VM.

Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC= 0x6d3f1992
Function name=(N/A)
Library=(N/A)

NOTE:
We are unable to locate the function name symbol for the error just occurred.

Current Java thread:
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1419)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1335)

[code]...

Dynamic libraries:
0x00400000 - 0x00405000 C:OraHome1jdkinjava.exe
0x7C800000 - 0x7C8C2000 C:WINDOWSsystem32
tdll.dll
0x77E40000 - 0x77F42000 C:WINDOWSsystem32kernel32.dll

[code]...

what could have happened?

View 6 Replies View Related

Dbconsole Missing In Startup And Services.msc?

Jun 27, 2013

I have download and installed the trial version of oracle 11g enterprise on windows 2008 r2 in vmware workstation. I couldn't see the database control in start up as my destination path c:oracleyourdatabaselocationdboc4jj2eeoc4j_DBConsole though I tried to open manually https://<localhost, ipaddress, domainname>:1158/em but its failed to open. I also tried to recreate the db using below commandemca -deconfig dbcontrol db -repos dropemca –config dbcontrol –repos createGot some info from below details:[URL]

NOTE: Moreover dbcontrol services missing in services.msc

View 4 Replies View Related

Database Cannot Startup After Host Crash

Feb 14, 2013

the db cannot startup after host crash.

the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.

Thu Feb 14 09:25:20 EST 2013
sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive
Thu Feb 14 09:25:20 EST 2013
sculkget: lock held by PID: 272600512
Thu Feb 14 09:25:20 EST 2013
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Thu Feb 14 09:25:20 EST 2013
Failed to acquire instance startup/shutdown serialization primitive
[code]....

Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive

View 17 Replies View Related

DB 11g On Min2K3 Take 100% Of One Core 2 To 4 Minutes After Startup

Feb 23, 2013

I have a Windows 2003 VirtualBox instance, to which I assigned 3 out of 4 cores my laptop has. This is a demonstration environment for an Oracle vertical product. I got it from my colleagues. The OS boots without starting the DB services - I did this deliberatley while trying to figure out what is happening.

About 2 and half to 3 and a half minutes after the service is started the oracle.exe "latches onto a core and does not let go" (as best as I can describe what I see). With 3 cores I see 33%-34% cprocessor use in the task manager with oracle.exe doing all the using. Nothing else is started. There is no process of which I am aware which actually uses the DB. I only start the TNS listener and the database service.

Once I start it, the demonstration software uses the database extensively for complex queries. With one of the 3 cores 100% used by the oracle.exe I am running short on CPU at times, which makes the demonstratin seem slaggish, and queries take longer than is really acceptable (not surprising seeing oracle.exe is very busy doing I know not what).

View 2 Replies View Related

Multiple Errors On Startup Nomount

Mar 11, 2013

[oracle@localhost ~]$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@localhost ~]$ sqlplus / as sysdba

SQL> startup nomount
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-15077: could not locate ASM instance serving a required diskgroup

I verified oracleasm is mounted and loaded, both are yes.I am unable to start my ASM instance as well.when attempting to create spfile from pfile I kept getting errors:

SQL> create spfile from pfile = 'u01/app/oracle/product/11.2.0/dbhome_1/dbs/init.ora';
create spfile from pfile = 'u01/app/oracle/product/11.2.0/dbhome_1/dbs/init.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/u01/app/oracle/product/11.2.0/dbhom
e_1/dbs/init.ora'

View 21 Replies View Related

SQL & PL/SQL :: Database Startup And Shutdown Event?

May 7, 2013

Any example of database startup event and database shutdown event?

View 2 Replies View Related

Forms :: FRM - 92101 / Failure In Server During Startup

Sep 3, 2010

While running the test form test.fmx available in DevSuiteHome_1 ools , I get the follwing error :-

FRM - 92101 There was a failure in Forms server during startup. This could happen due to invalid configuration.

I have tried to install the software many times after deinstalling but no success. However the same software has been installed on other machines too and is working absolutely fine.

View 1 Replies View Related

Client Tools :: Sql Developer Startup Is Slow?

Apr 15, 2013

I am finding Oracle sql developer start up to be very slow.It takes more than 5 - 10 mins to startup.It seems for long startup.Its installed on Windows 7 machine in c: drive. Want to know what is causing it to be too slow.virus scanning, JVM startup.... ?

FYI
---------
Oracle Sql developer Version -- 3.2.20.09
Java(TM) Platform -- 1.6.0_43

View 4 Replies View Related

JDeveloper, Java & XML :: Programs (JRE) Hang On Startup?

Jun 23, 2011

I'm facing a problem with the starting of java programs on my Win XP system. The startup most often takes from 5 to 60min. Only in rare cases java programs start-up normally. I've these problems with Eclipse, Nitro and ProM which are all Java-based tools.

I have used STraceNT to find the cause of my problems but I couldn't figure it out. I've attached the STraceNT log file for the execution of ProM. The program runs until the last line in the log while starting without showing up anything. After 20min suddenly the programs shows up and works as it normally does. The last line in the log where the software hangs for this long time is a call to WaitForeSingleObject. Before that it seams to allocate memory. I could see similar patterns in the executions of the other java programs, but I still can't see where the problem lies. I also tried removing the JRE and install different versions.

View -1 Replies View Related

Forms :: Frm-92101 Failure In Server During Startup?

Feb 22, 2008

i just compile all the forms on linux server and creatge a envirement in formsweb.cfg file and create my test.env file.

then when i run OC4J and starting my application. it gave me following error

frm-92101 There was failure in forms server during startup this could be happen due to invalid configuration look your web server log file for details.

i also attached the screen shot, you can see it in attachment.

View 4 Replies View Related

RAC & Failsafe :: Advisable To Use Shutdown Immediate And Startup Command

Feb 15, 2013

I want to set the following parameter in one node and restart the machine.

ALTER SYSTEM SET MEMORY_MAX_TARGET=4G SCOPE=SPFILE sid='*'

I know we could use srvctl command to restart DB.My question is..to restart DB is it advisable to use shutdown immediate and startup command ?

View 6 Replies View Related

Forms :: Frm-92101 - Failure In Server During Startup

May 30, 2013

i have one problem when i make any changes in my any existing reports or just i recompile the existing report after that when i open this report its give me

error

Quote:•FRM-92101: THERE WAS A FAILURE IN THE FORMS SERVER DURING STARTUP. THIS COULD HAPPEN DUE TO INVALID CONFIGURATION

View 2 Replies View Related

Server Administration :: Unable To Startup Database

Jun 20, 2011

im new to DBA.i installed oracle on my pc but im not able to startup database...im manually creating database ..CRD files r still not created as im unable to startup nomount..im getting this error.

SQL> startup nomount
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel

i almost worked on this for 10 days but im getting the same error...

View 39 Replies View Related

XE :: OracleXE Version 11g R2 Installation During Database Startup

Sep 24, 2012

I am new user using oracle XE. During the installing process, all see is Ok, but, when database is over startup process, the process NOT RESPONDING, and i don't know the cause.

My environment

Hardware: NOTEBOOK HP Genuine Inter (R) CPU
T2500 @ 2.00GHz
1.66 GHz, 2 GB of RAM
SO : Windows XP with services pack 3

Installation flow implement:

1. Download Oraclexe from oracle site
2. The installation & configuration process finish succeful, but when el flow are in startup point and i treat to login
the login step give me the next message:

ERROR:
ORA-01089: Immediate shutdown in progress - no operations are permitted
Process ID:0
sESSION id: 0 Serial number: 0

I Hope about 5 hours and the message is the same, while when i hope about 5 hours.

View 7 Replies View Related

SQL Startup Error - End-of-file On Communication Channel

Dec 28, 2012

Oracle 11g 11.2.0.2 Expression Edition

I made the number of processes to 1 by issuing the below command.

SQL> alter system set processes = 1;
SQL>shutdown immediateI am getting the below error when I issued startup command.

SQL> startup;
ORA-03113: end-of-file on communication channelalert log:
Fri Dec 28 14:09:24 2012
PMON started with pid=2, OS id=2984
Fri Dec 28 14:09:24 2012
PSP0 started with pid=3, OS id=5788
Fri Dec 28 14:09:25 2012
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors.
Process GEN0 submission failed with error = 20
USER (ospid: 4780): terminating the instance due to error 444
Fri Dec 28 14:09:25 2012
VKTM started with pid=4, OS id=1676 at elevated priority

Instance terminated by USER, pid = 4780How to startup my database again?

View 19 Replies View Related

Startup SMON Process Will Do Instance Recovery

May 7, 2013

we have given shutdown abort to a database.At the next startup SMON process will do instance recovery. If it contains committed as well as uncommitted transactions on what basis or how the SMON process will roll forward or rollback the transactions and from where it will get these informations or data?

View 4 Replies View Related







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