Is It One Alert Log Per Instance Or One Per Database

Jul 28, 2010

Is it one alert log per instance or one per database? My guess would be per instance, but I have some documentation that indicates per database.

View 4 Replies


ADVERTISEMENT

Oracle Database Alert Engine

Mar 15, 2011

I am running Oracle XE . This database collects information about server statistics in my organization ( memory usage, threads running, etc). Now , I need to send alert/ notification emails if the certain thresholds are crossed by server ( ex: if number of threads increase more than 100, send an alert email).

One way to do this is to write stored procedures and schedule them to run every hour and send alert email if conditions are met.

But what I want to do is to use some sort of rule engine where I can specify the rules/conditions which have to be true for alerts to be sent. The reason I want this approach is so that every time there is a new rule, I do not have to write a new stored procedure and I can just specify the condition in the rule engine . So are there any Rule Engines out there that I can use (preferably open source and free to use)?

View 2 Replies View Related

LGWR Switch In Database Alert Log Every 3-4 Minutes

Jul 6, 2012

i am seeing (LGWR switch) happening in my databsae alert log every 3-4 minutes. is that appropriate? if not, what measure can i take to reduce this?

View 1 Replies View Related

RMAN :: Clone 2 Node RAC Database To Single Instance Non-RAC Database Using Existing Backup

Jul 25, 2012

I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:

rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault

And the database was in mount stage, and when i tried to open database it failed with below error:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .

View 4 Replies View Related

Can't Able To Connect To Local Database Instance

Oct 31, 2012

I cant able to connect to my local DB instance. Oracle service for DB instance will be started running when the system boots automatically.I faced this problem before, I was instructed to boot my system without network connection. It worked for few days. Suddenly I cant able to connect to my local DB instance again, even though I am booting my system without network connection.

This is the configuration I have in tnsnames.ora in my local machine.I have the host as localhost, because local machine is laptop and IP will change periodically.

CSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CSS)
[code]....

View 14 Replies View Related

Data Guard :: Possible To Use Dataguard From Single Instance To RAC Instance?

Jul 1, 2010

Is it possible to use oracle dataguard from single instance to RAC instance ? Does Oracle dataguard support this ?

View 1 Replies View Related

Server Administration :: How To Get Disk List On Any DB Instance That Uses ASM Instance

Mar 16, 2011

My context on our servers is the following one:

- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks

On each DB instance you can see:

- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view

So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?

View 6 Replies View Related

Oracle 11g Installation - Database Instance Recovery

Oct 16, 2010

My database is working on Oracle 10g. After installing a Oracle 11g in my PC instance went down and my database got corrupt. What are the steps I should follow to recover my Database?

View 2 Replies View Related

Enterprise Manager :: Can't Configure 11g R2 - Database Instance Not Available

Dec 12, 2010

I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.

EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....

View 3 Replies View Related

RAC & Failsafe :: Single Instance - Migration To Database

Oct 20, 2010

2 Database.

TP1 Database - Oracle RAC 11g (2 Node)
TP2 database - Single Instance

Is it possible to migrate from RAC to Non-RAC(Single Instance)?

Our requirement is, 3 Oracle Schemas@TP1(having DW data) we need to move it to TP2 Database.

View 4 Replies View Related

How To Create Instance Using Database Template File

May 8, 2012

how to create database instance using database template file(.dbt) while running DBCA?

View 1 Replies View Related

RAC & Failsafe :: Database Instance Using Srvctl Command

Aug 13, 2013

Would there be any issue in application and database when i down RAC database instance using below srvctl command ?

srvctl stop instance -d DB -i DB1
srvctl start instance -d DB -i DB1

View 18 Replies View Related

Enterprise Manager :: Failed To Connect To Database Instance

Oct 27, 2011

When login i'm getting error : Details Failed to connect to database instance: ORA-28000: the account is locked (DBD ERROR: OCISessionBegin).

I have checked DBCONSOLE & AGENT are running properly.

litening:/opt/oracle/product/11.2.0/bin>export ORACLE_SID=infoddp
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOME=/opt/oracle/product/11.2.0
litening:/opt/oracle/product/11.2.0/bin>export ORACLE_HOSTNAME=liteningv
litening:/opt/oracle/product/11.2.0/bin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

[code].....

View 10 Replies View Related

RAC & Failsafe :: Query On Dependency Between Database Instance And Service?

Jul 8, 2013

suggest on the dependenecy between the database service and the database instance?

srvctl start instance -i db1
will this start service as well for which the above instance is either preferred or available instance?
will it start the listener as well?

srvctl stop instance -i db1
will this stop service as well for which the above instance is either preferred or available instance?
will it stop the listener as well?

srvctl start service -d db -s dbserve
will this start service as well for which the above instance is either preferred or available instance?

srvctl stop servive -d db -s dbserve
will this stop service as well for which the above instance is either preferred or available instance?

srvctl start database -d db
will it start instance, listener and service as well?

srvctl stop database -d db
will it stop instance, listener and service as well?

View 1 Replies View Related

Database Instance Cannot Be Startup / Status / Failed ORA-12505

Jul 19, 2012

I 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]....

View 3 Replies View Related

Cons Of Running 8 Production Database Instance On One Windows Server

Dec 3, 2010

We are planning to consolidate our Oracle Production DB into one server. We are basically a windows shop. Is it feasible to run 8 production Oracle DB in one windows server. All the DB are not really transaction intensive DB. 2 DB in the size of 300GB and others all DB falls under average size of 40GB.

I can take care of the HD slicing so Oracle does not enter into IO bottleneck. We are planning to go for external NAS or SAN for storage.

My main concern is on processor usage. The processor we are thinking about is Intel Xeon Quad Core x 2nos. Will there be a processor bottleneck or is there way in Oracle to assign processor usage(I belive there is no much tweaking options here)

View 6 Replies View Related

Server Administration :: Install Oracle 11.2.0.2 Single Instance Database On AIX 6.1?

May 4, 2011

I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?

View 1 Replies View Related

Recovery Manager (RMAN) :: Restoring A Backup To A New Database Instance

Sep 4, 2013

I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.

(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)

 I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.

View 6 Replies View Related

Instance Of Oracle Enterprise Manager 10g Database Control Already Running

Jun 4, 2012

I'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:

while enter in a command

$emctl status dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------

View 1 Replies View Related

Clusterware :: Can Use Grid Infrastructure 11.2 To Protect A Single Instance Database

Oct 12, 2012

I would like to use Oracle Grid Infrastructure to protect a single-instance database.

I found these docs:

[URL]

I was unable to find a similar document for GI 11.2 . Do you know if such a document exists?

At the moment I only know that the GI is free if used for an Oracle Product, but I am not shure whether it can be used to protext external applications or single-instance databases

View 4 Replies View Related

Single Instance Non-Grid To Single Instance Grid Database

Aug 27, 2012

I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.

Here is what I've done:

1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:

RMAN> backup as copy database format '+ASM_DATA_DG';

Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:

===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:

[Code]....

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                22-AUG-2012 06:08:53
Uptime                    2 days 2 hr. 50 min. 48 sec
Trace Level               off

[Code]....

View 10 Replies View Related

Enterprise Manager :: Unable To Apply Monitoring Template On Database Instance

Sep 13, 2011

I have to apply monitoring template on my databases. Databases are already added and configured into OEM. They are visible under Databases tab and also under Groups where I have added them.

But when I try applying monitoring template and look for database in search window, it doesn't appear there.

View 1 Replies View Related

Data Guard :: Change Instance Parameter Of Primary Database And Standby

Nov 29, 2011

I have a requirement to change the instance parameter of the primary database and standby in the data guard. Any procedure to do the same. I have to do it directly on production and there is no test set up so I cannot experiment . The procedure I am thinking of is as below.

1. Stop the standby

2. backup the primary

3. Change the parameter and restart to make it effective

4. Start the primary

5. Go to stand by

6. Change the parameter and mount the database.

7. Check if both are in sync and apply logs if not.

View 6 Replies View Related

Data Guard :: Primary Database Is RAC And Physical Standby Is Single Instance

Mar 27, 2013

I am using Oracle RAC 11.2.0.3 as primary database, we are going to start using Oracle data guard. So I am designing my infrastructure and planing to use Oracle 11.2.0.3 Single instance as my physical stand by database.

My question is it feasible to have my standby database as single instance while the primary is RAC? is it feasible to build my Oracle single instance standby database from the RMAN backup of the RAC primary database? Is there any restrictions (or any points to be taken into consideration) since my primary database is RAC while the physical standby is Oracle single instance?

in the below link

[URL].......

it was mentioned that primary can be RAC or single and same for standby, but my question is it feasible to have primary as RAC while standby as single instance? or it should be like each others?

The primary database can be either a single-instance Oracle database or an Oracle Real Application Clusters (RAC) database. Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle RAC database.

View 7 Replies View Related

Server Administration :: Script To Automate Startup / Shutdown Of Multiple Instance In One Database

Jun 24, 2010

Find 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 Related

Error In Identifying Control File / Database Not Mounted ORACLE Instance Shut Down

Nov 21, 2012

i have a problem when i try to login to oracle...i found this message error.

ora-01033 oracle initialization or shutdown in progressafter i logged on with / as sysdba...i did the following

SQL> shutdown immediate;
ORA-01507: database not mountedORACLE instance shut down.
SQL> startup mount;
[code]....

View 6 Replies View Related

Real Application Clusters :: Convert 10g Single Instance (uses ASM) Database To RAC - Reconfigure Fails?

Oct 5, 2012

I have 11gR2 GI installed on two nodes. I am trying to convert a 10g single instance (uses ASM) database to RAC and getting this error. I am trying using 12c as well as manually by using rconfig.

[main] [21:19:15:145] [ASMInstance.initialize:135] First record =[Ljava.lang.String;@958bb8
java.lang.NullPointerException
at oracle.sysman.assistants.rconfig.engine.ASMInstance.initialize(ASMInstance.java:153)
at oracle.sysman.assistants.rconfig.engine.Step.execute(Step.java:283)

[code]...

View 1 Replies View Related

Networking And Gateways :: Maintaining Single Listener In Multi-instance Database Server With 3 Different Oracle Home

Sep 29, 2011

We've been administering a multiple instance production dB server with 3 different versions of Oracle installed.Currently, each of Oracle version had corresponding listener.Oracle 9i had 2 instances, 10g 6 instances & 11g 2 instances also.how I can integrate this 3 listeners into 1.

View 2 Replies View Related

Server Administration :: Multiple Database With Multiple Instance On Same Machine?

Mar 16, 2011

can we have multiple database version running in a single machine with multiple instances provided there are enough resources.Can we do in RAC only?

View 15 Replies View Related

Multiple Alert Log In 10g RAC

Jan 9, 2013

We have Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit RAC in Linux and syslog server also in Linux.

syslog server is a centralize server to monitor all the system and database log.

is there any way to create a multiple alert log file. so that we can keep one alert log file in default location and another alert log file in centralize syslog server for monitoring purpose.

View 3 Replies View Related







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