SQL & PL/SQL :: Database Startup And Shutdown Event?
May 7, 2013Any example of database startup event and database shutdown event?
View 2 Replies
ADVERTISEMENT
Automating Database Startup And Shutdown?
Jan 5, 2012We 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.
Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database
Jun 24, 2010Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
View 1 Replies View RelatedServer Administration :: Oracle 10g - Database Server Startup / Shutdown
Jun 29, 2011I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies View RelatedRAC ASM Complete Shutdown And Startup
Jul 7, 2011I 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]....
RAC & Failsafe :: Advisable To Use Shutdown Immediate And Startup Command
Feb 15, 2013I 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 ?
Server Administration :: Error In Startup Mount After Shutdown Immediate?
Apr 1, 2009I want to shutdown the database using shutdown immediate and startup the database using startup mount.
1.)My system is client system if I connect start--> program -->Accessories --> communication --> Remote Desktop connection (connect server system) , open Run type cmd after
Shutdown immediate (database is shutdown)
Startup mount (database is mounted no problem it's working fine)
2.) But if I, open Run type cmd in client system If I run same command, I'm getting below error (ORA-12560: TNS:protocol adapter error).
C:>set oracle_sid=dbadb
C:>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on ╘± ╠ß± 31 18:09:27 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
[code].....
3. If I run same command in Sql Plus I'm getting below error(ORA-12514: TNS:listener does not currently know of service requested in connect descriptor).
SQL*Plus: Release 10.1.0.2.0 - Production on Ôñ Ìáñ 31 18:23:13 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
[code].....
Server Administration :: Startup Open After Shutdown Throws ORA-12514 Error?
Jan 12, 2011I searched the knowledge base here and in other forums and haven't found the answer. There was a similar condition presented earlier, but it turned out the resolution was to run the >shutdown/>startup on the server rather than from a client. Not applicable in my case!
Shutdown and startup called used to work with 9i, now startup fails in 10g. ORACLE_HOME and ORACLE_SID are set and report correct values. What is different in 10g that the script (shown below) now throws a TNS listener error after shutdown?
I successfully upgraded from 9i to 10g (10.2.0.5.0) on Windows Server 2003, 32-bit last weekend. Now our backup_script.bat and oracle_stop_start.sql throw "ORA-12514: TNS:listener does not currently know of service requested in the connect descriptor"
This batch file and sql script predate me and worked with 9i for years. Now the startup command in the oracle_stop_start throws this error after executing shutdown. The backup batch file calls:
sqlplus "system/manager@wind as sysdba" @D:ptcwindchillackupsoracle_stop_start
The entire oracle_stop_start.sql is as follows:
shutdown immediate;
startup open;
quit
What is different in 10g that this now doesn't work? Shutdown works, but it will not startup due to the listener error. I have made the backups work by commenting out the call to sqlplus and I'm getting good backup dumps.
In my virtual image of the server I have found that I can duplicate the error after >shutdown. I have found that if I exit sql*plus and go back in as follows I can get the database instance to restart from the command line:
c:>sqlplus /nolog
sql>connect sys/* as sysdba
sql>startup open wind;
That does start, mount and open the database instance.
Is there a better way to be making sure that everything is stopped before executing the >exp command to create a backup dump? I will look into and test datapump export/import and RMAN for creating the backups, after I get this working again.
why this worked in sql*plus in 9i but not in 10g? Can I make TNS Listener smarter? Change or add variables to the startup command?
Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)
Sep 13, 2013we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?
View 3 Replies View RelatedServer Administration :: SHUTDOWN And STARTUP DB Server From Client Machine?
Sep 21, 2010I have installed oracle 11g Release 11.1.0.1 on windows server 2008.I access this server from a client machine running on winXP through SQL PLUS. I wanted to shutdown and start DB server from this client machine. Accordingly i issued shutdown immediate command from SQLPLUS.
Now when i tried to start the DB with "STARTUP NOMOUNT" command i received error 12514. I understand this error means that the listener received a request to establish connections to a database but since DB services are not up and running, hence the error. So my first question is how do I resolve this error.
Continuing further, i tried to re-connect to the database as sys, and i received another error ORA-01041. So, my second question is why did i receive this error and again how can i resolve it
may be you can point me to relevant reference in Oracle documentation) how can i start and stop oracle from a client machine using SQL interface in CLI mode and windows environment and avoid this error.
Workflow :: No Event Subscriptions Exist For Event Error
Mar 6, 2013we are running Oracle R12.1.3 on DB version 11.2.0.3. I just migrated a created a custom subscription for the oracle.apps.ap.supplier.event Oracle Event. I execute a custom package when this event fires. My package is working fine and I'm getting the expected results. My problem is I keep getting a Workflow notification saying:
Sent: Monday, March 04, 2013 9:14 PM
To: SYSADMIN
Subject: Action Required: Local Event UNEXPECTED : oracle.apps.ap.supplier.event / 36422
To SYSADMIN
Sent 04-MAR-2013 21:13:40
ID 1659929
An Error occurred in the following Event Subscription: Event Subscription
Event Error Name:
Event Error Message: No Event Subscriptions exist for this Event
Event Error Stack:
Event Data: Event Data URL
Event Details
Event Field Value
[code]...
I saw an earlier post about this and have tried changing the Source Type to "External" but that didn't change anything. why Workflow is telling me a subscription doesn't exist when my subscription is executing with no problems.
Database Auto Start With Machine On And Shutdown With Machine Shutdown
Sep 2, 2012i install oracle 10g on linux on perform the following step but my database is not auto start with the machine
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.
The scripts are,
$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut
Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.
-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.
In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.
If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.
Automate Startup/Shutdown of Oracle Database on Linux
Step 01: Be sure that oratab file is correct and complete.
Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.
Database entries in the oratab file have the following format:
$ORACLE_SID:$ORACLE_HOME:Y
Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.
If in my database there is two database named arju and arjudup then my oratab file will contain the entry like,
arju:/var/opt/oracle/product/10.2.0/db_1:Y
arjudup:/var/opt/oracle/product/10.2.0/db_1:Y
where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.
Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.
a) Login as root.
b) Change directories to /etc/init.d
c) Create a file called dbora and chmod it to 750.
# touch dbora
# chmod 750 dbora
d)Edit the dbora file and make the contents of it like below.
[Code].....
SQL & PL/SQL :: How To Generate Email On Database Event
May 15, 2011I've heard about diferent ways of generating email in response to a database event e.g
1 - Using UTL_MAIL package.
OR
2 - Event Driven Reporting feature of 10g Database and using SRW.Run_Report package to generate and mail a report.
Now I'm confused that how should I accomplish the following tasks:
(i) - How to generate an email after Insert/Update/Delete on a table and acknowledge the concerned users about that event?
(ii)- How to attach a text file with that email?
Database Time Spent Waiting % For Event Class Concurrency
Dec 4, 2012Most of my day to day work involves the support of DB2 on AIX and z/OS. I support the database infrastructure for one business system that runs on the Oracle RDBMS. The application is Oracle Transportation Management. The non-production environments don't get much traffic. If I sign into the TEST or DEV Enterprise Manager DB Control screen, the following warning is almost always listed on the main page:
Metrics "Database Time Spent Waiting (%)" is at 44.00384 for event class "Concurrency"
Enterprise Manager reports that this metric is continuously fluctuating above and below the warning threshold of 30% of db time when the environment is idle.To investigate(and I am no oracle expert, far from it), I ran the following:
SELECT * FROM v$session_event
WHERE WAIT_CLASS='Concurrency'
ORDER BY TOTAL_WAITS DESC;
By far, the top two entries in the result are the following:
SIDEVENTTOTAL_WAITSTIME_WAITEDAVERAGE_WAITMAX_WAIT
124os thread startup12041423733.5218
359os thread startup150653433.5521
[code]...
Does this indicate a possible problem with the operating system?
How To Know Database Shutdown Without Monitoring
Nov 23, 2010The Database is Shutdown, no user is complaining about it and also you are not monitoring it through alert log file, then how will you, as a DBA, come to know about it?
View 2 Replies View RelatedUnable To Login And Startup Database
May 15, 2011I 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
RAC & Failsafe :: Startup Sequence 10g RAC Database With ASM?
Dec 28, 2012I 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?
Server Administration :: Database Startup?
Apr 27, 2010MY 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
Database Cannot Startup After Host Crash
Feb 14, 2013the 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
Server Administration :: Unable To Startup Database
Jun 20, 2011im 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...
XE :: OracleXE Version 11g R2 Installation During Database Startup
Sep 24, 2012I 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.
Server Administration :: Database Shutdown Failed
Dec 16, 2012I issued a SHUTDOWN IMMEDIATE command on my database and for over 2 hours and got no response. I did this because I wanted to restart the database due to many hanging sessions which had led to high CPU usage on the server by oracle process.
Oracle Service<dbname> instance using the Windows Services screen which failed with an error 1053 message. At the same time I got an ORA-01013 message saying user requested cancel of operation. See below:
SQL> SHUTDOWN IMMEDIATE
ORA-01013: user requested cancel of current operation
SQL> SHUTDOWN IMMEDIATE
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> SHUTDOWN ABORT
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
What I want to know is how do I proceed? Also how do I check to see the status of the Shutdown operation?
Server Administration :: Database Shutdown Is Required Or Not
Apr 24, 2011We have 2 Unix SunOS server, named as SUNOS01 and SUNOS02, there is some space need to add in SUNOS02 and for that I have to bring Database down on SUNOS02. When I checked I found that the DB is pointing to SUNOS01, i.e. there is no DB on SUNOS02, So, Do I required to shutdown the DB on SUNOS01 or it is not required to do anything from Database side. I mean to say should I ask Unix team to bring down the unix server and add the space.Also, if DB shutdown is not required then what I have to do afetr they have added space and bring the server up from DB side.
View 4 Replies View RelatedDatabase Hangs In Shutdown Immediate For Cold Backup
Jan 28, 2013we have scheduled cold backup for our database. is there any solution to resolve below mentioned errors other than RMAN hot backup or shutdown abort ?
Sat Jan 26 00:20:55 2013
Active call for process 3939 user 'oracle' program 'oracle@proddb.fgho.com'
SHUTDOWN: waiting for active calls to complete.
Sat Jan 26 01:15:59 2013
SHUTDOWN: Active sessions prevent database close operation
Instance shutdown aborted
Database Instance Cannot Be Startup / Status / Failed ORA-12505
Jul 19, 2012I am running ORACLE 10.2.0 on Windows Virtual PC. System: Microsoft Windows XP SP3.
Yesterday I wanted to make a copy of my Virtual Machine Hard Drive Image. I directly copied all the files to my external hard drive, but I forgot shutting down my virtual machine when I was doing this.
Today I found my instance failed startup.
In OEM, it is showing:
Agent Connection to Instance
Status: Failed
Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
In SQLPlus:
SQL> connect sys/password as sysdba
Connected to an idle instance
SQL> startup
ORACLE instance started.
[code]....
Server Administration :: Preventing Database Shutdown By A Trigger?
Jan 15, 2013i mean can i write a trigger to prevent shutdown in certain time.
create or replace trigger trig1 before shutdown on database begin if to_char(sysdate,'hh24') <16 then 'what is the right thing to do here?'
Data Guard :: Shutdown Down In Primary Database In Environment
Jun 29, 2010I have configured data Guard on oracle 11gR2. It is working fine. The only issue i am facing is that when i am stopping the database on the primary server, it is taking a long long time to down the database.
Is it normal?
Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.
Server Administration :: DBMS_JOB Restarting / Database Shutdown
Aug 8, 2010I was monitoring a database job to collect statistics, it was scheduled using DBMS_JOBS..I found that it was running during business hours so i got the session ID of the job using;
select sid from dba_jobs_running where job=11;
I then i killed the job using;
select serial# from v$session where sid =232;
alter system kill session '232, 10852';
select sid from dba_jobs_running where job=11;
no rows selected...After some time i again fired the same command
select sid from dba_jobs_running where job=11;
SID
----------
232
and found that the same job is again running..This behavior was repeated again N again. i have attached the spool file for the same...
what could be the reason that the job is starting all over again even after killing the session and what should be done to stop it..I understand that once the database shuts down and if the job is still running then it will restart once the database is up..In this case, Should i remove the job and re submit it again..
Server Administration :: Unable To Drop User Without Database Shutdown
Apr 19, 2013We are unable to drop user due to below error, how to drop the below user without shutdown the database.
SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
No session was available for particular user.
Server Administration :: Database To Startup With PFile - Failure In Processing System Parameters
Feb 8, 2011I successfully created a DB manually with PFILE.
I want the DB to startup with SPFILE at next login.So i fired the below command.
CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.
But it shows the error as below:
ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.
