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
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 RelatedI 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 RelatedI 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 ?
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.)
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
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.
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.
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]....
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
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.
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?
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
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]....
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?
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
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
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).
[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'
Any example of database startup event and database shutdown event?
View 2 Replies View RelatedWhile 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.
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
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.
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.
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 ?
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
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...
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.
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?
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
