Bring Down The Databases In Oracle Fail Safe Environment?

Jun 28, 2013

How can we bring down the databases in oracle fail safe environment?

We have one database X in two server�s windows A & B with oracle fail safe environment.
What procedure should we fallow to bring down the database X.

Today I was strangling to bring down the database because database was automatically coming up once brought down the database. what procedure should we follow to bring down the database in OFS environment.

View 1 Replies


ADVERTISEMENT

Clusterware :: Fail Safe Virtual IP?

Jul 3, 2012

I have a Windows 2008 R2 SP1 2 node active/passive cluster with fail safe 3.4.2 installed. I also have 11G database software installed. My problem is I am unable to successsfully add an oracle virtual IP to the oracle group within fail safe. I receive the below error when I try. I need to get this resolved so that I can add my databases to the cluster.

Oracle Fail Safe Manager

FS-10890: Oracle Services for MSCS failed during the create operation
FS-11220: Failed to create the virtual address
FS-10012: Failed to bring the cluster resource Network Name HHVHAVELP01 online. Check the Windows event log for messages.
FS-10726: Resource Network Name HHVHAVELP01 is in a failed state

I don't see any message in the event log when I check...

View 2 Replies View Related

RAC & Failsafe :: Can Server (node) Have More Than One Databases In RAC Environment

Feb 7, 2013

Can a server (node) have more than one databases in RAC environment?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Oracle RAC Private Connection Fail

Feb 7, 2013

I would like to know that when the private network in oracle rac down, which is the preferable node in the cluster (cluster of 2 nodes) to takeover the cluster.

Can I set/get the failover policy to point to one node in the cluster?

View 8 Replies View Related

Enterprise Manager :: Client V9.2.0 Fail When Access Oracle Database 8.1.7?

May 12, 2010

behaviour of oracle enterprise manager. i want to edit a table of a database. after i clicked on the table the oem crashes without any messages - simply disappearing.

i installed oracle9i release2 V9.2.0.1.0 windows client and want to access an oracle8i V8.1.7 server on linux.

View 4 Replies View Related

Server Utilities :: Safe To Kill Full DB Export?

Jan 7, 2011

We started a full db export using exp, and we need to kill it. Is it "safe" to do so? Killing it won't affect the database in any way, right?

$ORACLE_HOME/bin/exp system/xxxxxx BUFFER=140000 FULL=Y FILE=/export/<sid>.exp VOLSIZE=2000M GRANT
S=Y INDEXES=Y COMPRESS=Y

View 1 Replies View Related

Backup & Recovery :: Migrating Databases / Task To Migrate Total Databases

Mar 27, 2012

I have the task to migrate the total databases(Exact copy to be moved to another server).The current server is going for format.After I did the following steps I am getting the tablespaces(databases)-4 sizes same ,but I am facing issue like some default tablespaces i.e temp,system are not matching.

temp tablespace
***************
current server - 4.0(approximately)
Migrating server - 160 MB

System tablespace
*****************
current server - 580 MB
Migrating server - 220 MB

Also I checked the tables are also matching for the 4 databases.Also Provide the solution or method which is correct.

steps done for migrating(By me)
********************************
EXPORTING DATA USING DATAPUMP
*********************************

1 From command prompt MKDIR 'c:oraclexeapp mp';

2 From SQL prompt conn system/kotak;

3 create or replace directory dmpdir as 'c:oraclexeapp mp';

4 grant read,write on directory dmpdir to kotak;

5 From command prompt

expdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=expdpxe.log;
IMPORTING DATA USING DATAPUMP
*****************************
in another server machine

1 From SQL prompt conn system/kotak;

2 create or replace directory dmpdir as 'c:oraclexeapp mp';

3 grant read,write on directory dmpdir to kotak;

4 From command prompt set ORACLE_SID=xe;

5 impdp system/kotak@xe full=Y directory=dmpdir dumpfile=xe.dmp logfile=impdpxe.log;

IN OUR PROCESS we created the below tablespaces and user before IMPORTING created 4 tablespaces

1. kotak
2. kotakdb
3. wired_data
4. ferrari

Created Users which are there in 219 server
1. KOTAK
2. KOTAKDB
3. FC_80
4. DEMOINTERNETBANK
5. DEMOINTERNETBANKDB
6. CREDITCARD

View 1 Replies View Related

Backup & Recovery :: Moving From One Windows Environment To Another Linux Environment?

Jun 19, 2012

I'm trying to move my backup sets from windows database environment, to OEL 5.7 environment on another server.

I've found a manual [URL] by which I am trying to do it.I took backup sets from last night's backup using RMAN,and the current parameter(initSID.ora) file from the running live database.Now i need to configure control files in the pfile accordingly.

1. can i take current control files from the running system, to restore and recover backup sets from last night, to the state the database was at backup time?

2. how can i find out if control files are backed up and know by RMAN? "list backup completed after '2012-JUN-19';" >> gives me Archive redo logs, datafiles, but don't see the control files(or don't reconize them).

View 15 Replies View Related

Enterprise Manager :: Unable To Bring Up OEM When Using Different Pfile

Jun 5, 2010

what is missing in this pfile that would cause enterprise manager not to appear ?

In the Oracle Database 10g: Administration Workshop II The chapter 8 excercise calls for the database to be started using the pfile init_sgalab.ora . The purpose of this I suppose is to simulate a memory error.

When I get to the part where I need to use OEM to fix the problem, OEM does not come up. The contents of init_sgalab.ora are :
--------------------------------------------
background_dump_dest='/u01/app/oracle/admin/orcl/bdump'
compatible='10.2.0.1.0'
control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl','/u01/app/oracle/oradata/orcl /control03.ctl'
core_dump_dest='/u01/app/oracle/admin/orcl/cdump'
db_block_size=8192
[code].......

I am not sure what is missing in this file to be able to bring up OEM.

Also, I looked at the logs and this is the only error message I found that might be relevant in

/u01/app/oracle/product/10.2.0/db_1/jhlinux.home.com_orcl/sysman/log/emoms.log

2010-06-04 23:33:59,809 [HttpRequestHandler-8546123] ERROR eml.OMSHandshake processFailure.619 - OMSHandshake failed.(AGENT URL = http://jhlinux.home.com:3938/emd/main)(ERROR = INTERNAL_ERROR)

View 24 Replies View Related

Server Administration :: ORA01403 Bring A Database Down?

Jul 8, 2011

We came in this morning with one of the servers down. After bringing it back up and checking the alert log, the only indicators that something was wrong were the hundreds of ora_01403 and the resulting trace files that were created.

The trc files for the most part indicated 'knpssamsg encountered 1304; end of error statck dumped in slave;' date and time and service name being sys$users.

View 4 Replies View Related

Bring Record To Top Without Changing Ascending Order Of Dep-id?

Jul 18, 2010

i have a table named employees in which there are 2 columns dep_id and name. One record having name as annie has dep_id=null .

When i arrange the records of the table in ascending order using order by dep_id the record with name annie and dep_id is placed in the last because null is consired largest. How can I bring that record to the top without changing the ascending order of the dep_id.

View 7 Replies View Related

Force Query To Always Bring Back Certain Amount Of Rows

Jun 24, 2010

Is there a way to force a query to ALWAYS bring back a certain amount of rows, even if some of the rows are blank?

I know there's a way in MSSQL but not sure how to in SQL+

View 7 Replies View Related

SQL & PL/SQL :: Write Outer Query Which Will Bring Individual Records Which Don't Sum Up To Zero

May 9, 2011

I have to write a sub query / build a logic for the below.

There are several accounts which should have a zero balance i.e sum of all the amoutns in that account should be zero. If they are non zero , i have to report which amounts make up non zero balance.

If i have amts as +20 , -20 , -30,-10 i.e the sum is -40 indicating a non zero amount. I need the entire details of the records which makes up non zero sum. So in above case details related to -30 aand -10.

I'm using a sum group clause on several fields at which sum is required to be checked ie. date , account , currency . query that will bring individual records that don't make the sum zero.

Is it possible to write a outer query which will bring individual records which don't sum up to zero.

View 14 Replies View Related

Oracle Example Databases And Tables

Oct 3, 2011

I'm just wondering because i didn't find any example / test databases for Oracle. Thus MS has its "northwind", mysql its "world" or "sakila".

Additionally, the tables view is quiet confusing, referring to all those generated tables (

[URL]........

I tried right-click + apply filter *remove generated* but it didn't work.

View 3 Replies View Related

SQL & PL/SQL :: How To Synch Two Oracle Databases

Aug 2, 2010

I have cloned the database into another using DBMS_METADTA API (export the metadata in xml form and recreate it on destination). I need to synch these two periodically. I need to update the XML to synchronize the databases.

I don't have 11g to use DBMS_METADATA_DIFF API.

View 7 Replies View Related

Oracle 9i For Linux Environment (64 Bit)?

Jul 18, 2013

link where can i get oracle 9i for Linux OS??Is 9i available for 64 bit ?

View 4 Replies View Related

How To Put Same Oracle Environment On Two Machines

Aug 23, 2012

we are planing to put the same oracle environment on two machines.

what is the best way to realize that.installation on each machine or installation on one machine and copy the environment to the second?

View 8 Replies View Related

ShadowProtect To Backup Oracle Databases?

Mar 22, 2013

if you are using ShadowProtect to backup your Oracle databases. What are your experiences and the pros and cons in using ShadowProtect as the one and only backup/recovery tools for Oracle databases? Can the potential of ShadowProtect replaces the commonly use Oracle backup/recovery tools?

The reason why I raise this question is because my boss has the idea that ShadowProtect is THE best backup/recovery tools. Personally I don't think so, because there can be cases where we only need to recover the database and not the whole OS.

View 6 Replies View Related

Upgrade From Oracle 11.2.0.2 To 11.2.0.3 In A Test Environment

Aug 29, 2012

recently i have tried to upgrrade from oracle 11.2.0.2 to 11.2.0.3 in a test environment (virtual machine).

there i have mentioned the SID as ORCL, but when we took the same snapshot to other machine (VM). iam unable to connect to the VM, unless i gave the local net service configuration as ORCL but it is unable to connect. but when i ran the query "select * from GLOBAL_NAME" output was ORCL. domain. com again i have configured in LNSC as ORCL.DOMAIN.COM it is working.

but i have given the sid as ORCL..

View 5 Replies View Related

Oracle Clustered Production Environment

May 26, 2013

I have a requirement to upgrade Oracle Data Integrator(ODI) from 10.1.3.5 to 11.1.1.6.3 We have a Clustered production environment where N1 will be up when N2 be down and viceversa.

Here N1 and N2 are the ODI servers as well as DB(11g Release 2) servers. They both access the SHARED CLUSTERED database. From ODI we will generally point the Oracle clustered IP(Virtual IP) which will internally point either N1 or N2 whichever is active. ODI application wise we are clear about the procedure.

Having some issues on DB related activities.

1. Should I break the cluster definitely? Cant I do the activity without breaking the cluster?
2. Do I need to point N1, N2, Clustered IP (Virtual IP) while doing the activities?
3. Since its a clustered database, do I need to db related activities once or twice? (Twice means, manually on both the servers)
4. As they are using same file structures (RAC), If the Virtual IP points N1 by default, assume that I create two new users a

View 1 Replies View Related

Migrate MySQL And Access Databases Over To Oracle 9i

Oct 2, 2008

I need to migrate MySQL and Access databases over to Oracle 9i. Is there a tool that will do this and also migrate sql scripts?

I heard of Oracle Workbench as one tool I could use?

View 4 Replies View Related

Server Administration :: Migrate Two Different Databases To Oracle?

Jul 11, 2012

I have to migrate two different databases to oracle.i have made two Migration Repository for each to do the migration, migration is done.but i would like to know can it be done with one migration repository.if yes then with one is best way to do it.data of two databases is different but table and sp are 99% same.

View 3 Replies View Related

Queueing :: How To Configure Oracle AQ For Distributed Environment

Sep 23, 2013

I have a scenario In which I have say 4 AQ in which I will post the message.Also i have say 2 database.I am planning to create an MDB which will poll on these AQ's,  so whenever I post message the MDB will read it and perform a specific action.I believe I can create only one MDB per queue, if it is so then I have to create 8 MDB.

As there 2 datasource and 4 MDB. Is there any other way to handle this I mean without creating 8 MDB as the Data sources can increase to 10 to 20 so the number of MDB will be 20 to 40.I guess this will affect the application performance. Can I make some changes in application so that only few MDB's are required? 

View 0 Replies View Related

SQL & PL/SQL :: Give Grant To Schema Of Different Versions Of Oracle Databases?

Aug 8, 2012

I have a task assigned to "grant select on sys.link$" to a user which exists on 500 different databases.

This needs to be done in Oracle database.

View 6 Replies View Related

List Exiting Databases In Oracle Server Using SQL Plus Command?

Feb 14, 2013

I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?

View 1 Replies View Related

Server Administration :: Change Character Set For Oracle 8i Databases?

Aug 15, 2013

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

View 11 Replies View Related

How To Use Perl DBI Script To Poll Logs From Oracle Databases

Jul 27, 2010

I have 2 separate servers each with oracle database installed.I am trying to pull oracle logs from these 2 databases to my main linux server using perl DBI. On this linux server I have 1 dbipoll.pl script and 2 wrapper scripts that pass in parameters to dbipoll.pl.

Here is the sample wrapper script that I've used to call dbipoll.pl(separate script with different parameters for each databases used):

CODE#!/bin/sh
#
export ORACLE_HOME=/ora-main/app/oracle/product/11.1.0.6/db
export ORACLE_SID=rmdev1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
#

[code]....

As you can see,the script should retrieve logs and write to oracledb1.log and update the countfile1 with the latest timestamp.The wrapper scripts are scheduled to run at 5mins interval.

The first wrapper script,which I've named as call_dbipoll1.sh runs fine. I am able to retrieve events and both oracledb1.log and countfile1 are successfully updated.

However,the second wrapper script,call_dbipoll2.sh is successful only for the first run. For subsequent runs,I've noticed that countfile2 does not get updated with the latest timestamp(ie. the file returns to blank) and oracledb2.log returns to blank as well. Therefore,am unable to pull new events then. Unable to determine what went wrong here..

Here is sample of my second wrapper script that tries to retrieve events from the 2nd database:

CODE#!/bin/sh
#
export ORACLE_HOME=/ora-main/app/oracle/product/11.1.0.6/db
export ORACLE_SID=rmdev2
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME
#

[code]....

View 1 Replies View Related

Installation :: Environment Variable Path Failed In Oracle 11g?

Dec 13, 2012

i am reinstalling oracel 11g in my window 7 64 bit machine after i uninstalled it. however, i got an issue that is environment variable path failed in the installation process. this didn't happen when i firstly successfully installed oracle.

View 7 Replies View Related

Precompilers, OCI & OCCI :: Oracle 8i Environment - Segmentation Fault?

Jul 15, 2008

I am running a job that is using Pro C code. I am running it on an Oracle 10g database with an Oracle 9 client on a UNIX platform. The code compiled fine. The job runs fine sometimes but other times it fails with a Segmentation Fault error.

I have the same job running in an Oracle 8i environment with no problems.

View 1 Replies View Related

Data Guard :: Change Non-SYS Password On Oracle 11g Environment?

Jul 26, 2012

how to change non - SYS oracle users' password in data guard envirnment. We all know that for SYS password change in data guard. DBA has to change in primary database by either "alter user SYS identified by xxxx" or create password file with orapwd.

Then scp password file to standby database. However, if I want to change SYSTEM or DBSNMP passwords, I change on primary with " alter user ....." SQL, then new passwords will be login dictionary. But this new SYSTEM pqssword will be shipped with redo log to standby and SYSTEM password on standby will be updated? I need technical answer on this question

View 7 Replies View Related







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