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


ADVERTISEMENT

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

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

RAC & Failsafe :: Service Always Offilne

Oct 26, 2013

OS :
6100-01-09-1015
oralce:
11.2.0.1.0 - 64bit RAC

View 1 Replies View Related

RAC & Failsafe :: Why Sessions Are Not Disconnected After Service Reallocation

Feb 2, 2013

i have 2 nodes RAC with service piodbserv2 which is active only on 2nd node. client is connected for (100% sure) to piodbserv2 on node2. i am doing relocation of this service to node1 using -f (force) option:

[oracle@rac1 ~]$ srvctl relocate service -d piodb -s piodbserv2 -i piodb2 -t piodb1 -f
[oracle@rac1 ~]$ srvctl start service -d piodb -s piodbserv2 -i piodb1
PRKP-1064 : Service piodbserv2 is already running on instance piodb1.
[oracle@rac1 ~]$ srvctl start service -d piodb -s piodbserv2 -i piodb2

-f (force) option is described as this which forcibly rellocate users from one to another node simply disconnecting sessions from node2 in my example

but i am surprised because my session is still opened on node2 after piodbserv2 relocation

SQL> select sys_context('userenv','instance') from dual;

SYS_CONTEXT('USERENV','INSTANCE')
-------------------------------------------------------------

2

SQL> select sys_context('userenv','instance') from dual;

SYS_CONTEXT('USERENV','INSTANCE')
-------------------------------------------------------------

2

SQL> select instance_number from v$instance;

INSTANCE_NUMBER
---------------
2

SQL>

at this moment piodbserv2 is only on node2. when i kill my user session and try connect again it will connect to node1. but i suspected that after forcibly rellocated service, my sessions will be disconnected from node2 forcibly also.

View 6 Replies View Related

RAC & Failsafe :: ORA-29760 - Instance Number Parameter Not Specified?

May 7, 2012

I am getting above error when i ma starting my rac data guard on linux. i specify instance number but still its asking

this is my pfile

timsdr1.__db_cache_size=4345298944
timsdr2.__db_cache_size=4395630592
timsdr2.__java_pool_size=33554432
timsdr1.__java_pool_size=33554432

[code]...

View 3 Replies View Related

RAC & Failsafe :: ASM Instance Not Started On Node 2 In Clusterware

Jan 11, 2011

i am configuring asm on clusterware when i create instance on node1 and node 2 a message screen appear " Cant start asm instance on node 2)When i start asm instance manually on node 2 i found the below error in alert log file.

ORA-27508 IPC error sending a message
ORA-27300 OS system dependent operation:send msg failed with status: 101
ORA-27301 OS failure message: Network is unreachable
ORA-27302 failure occurred at: sskgxpsnd1

View 3 Replies View Related

RAC & Failsafe :: Rac.vip.lsnr Instance Shutdown And Restart Itself?

Jul 7, 2011

'm using oracle rac 10.2.0.4.0 with 3 node and os SLES 10 sp 3 in early days we get error vip and lsnr service on my rac shutdown n restart itself,what happen to my rac ?

View 1 Replies View Related

RAC & Failsafe :: Hierarchy To Stop And Start Oracle RAC Instance

Apr 20, 2013

What is the hierarchy to stop and start oracle RAC instance ?

View 10 Replies View Related

RAC & Failsafe :: ORA-15077 / Could Not Locate ASM Instance Serving Required Diskgroup

Oct 7, 2013

When I try to start the database or ASM instance its showing the following error.

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+FLASH_RECOVERY_AREA/XXXXX/spfileXXXXX.ora'
ORA-17503: ksfdopn:2 Failed to open file +FLASH_RECOVERY_AREA/XXXXX/spfileXXXXXX.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
SQL>

when am trying to view the data's by below Sql its show name as null for FLASH_RECOVERY_AREA. so I couldn't even set compatible ATTRIBUTE

SQL> select NAME , COMPATIBILITY, DATABASE_COMPATIBILITY from V$ASM_DISKGROUP;
NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------- ---------------------- -----------------------------------
RUBIKON_DATA 10.1.0.0.0 10.1.0.0.0

SQL> show parameter asm_disk
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string RUBIKON_DATA, FLASH_RECOVERY_A
REA
asm_diskstring string /dev/mapper/Rubikon_data1, /dev/mapper/Rubikon_data2, /dev/mapper/Rubikon_fb

because of name is null mount mode as CLOSED and HEADER_STATUS as INCOMPATIBLE.

SQL> select name, mount_status, header_status,mode_status,state, path from v$asm_disk ;
NAME MOUNT_S HEADER_STATU MODE_ST STATE PATH
-------------- ------- ------------ ------- -------- -------------------------
CLOSED INCOMPATIBLE ONLINE NORMAL /dev/mapper/Rubikon_fb
RUBIKON_DATA_0000 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data1
RUBIKON_DATA_0001 CACHED MEMBER ONLINE NORMAL /dev/mapper/Rubikon_data2

View 1 Replies View Related

RAC & Failsafe :: Can't START Instance After Apply Critical Patch And Reboot

Apr 21, 2011

This is 2 node RAC database. Usually every month my system admin was applying OS critical patch then reboot the server.

While doing this activity i have stop all CRS and DB services. As usual i have did same in both the nodes and applied the patch and reboot the server.

After tried to start the CRS service and database services was used the following command. Except node1 instances all services are started.

E:oraclecrsproduct11.1.0crsBIN>crs_Stat -t
Name Type Target State Host
------------------------------------------------------------
ora....main.db application ONLINE ONLINE inf-...b-03
ora....n1.inst application ONLINE OFFLINE
ora....n2.inst application ONLINE ONLINE inf-...b-04
ora....SM1.asm application ONLINE ONLINE inf-...b-03

[code].....

Then i have tried to applied to old ocr backup also, then also i am getting same error.

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

SQL & PL/SQL :: Interchange The Value Which Has Foreign Key Dependency

Mar 29, 2011

I need to interchange the value which has foreign key depednecy,

For ex: I have a table dept

deptno| dname|dseq|
10 | CS | 1
20 | SC | 2

and in emp table

eno | ename | deptno |
1 |Raj | 10 |
2 |Ram | 10 |
3 |Vip | 10 |
4 |Muk | 10 |
5 |Sn | 20 |
6 |Snj | 20 |
7 |Asj | 20 |

there is a forign key define :

ALTER TABLE emp ADD (
CONSTRAINT rop_fk
FOREIGN KEY (deptno)
REFERENCES dept (deptno));

Now I want to change the deptno from 10 to 20 and 20 to 10 in dept table . So the ouput will be like

deptno| dname|dseq|
20 | CS | 1
10 | SC | 2

when i am deleting that row I am getting error "ORA-02292: integrity constraint (ROP_FK) violated - child record found".IF i am trying to update i am getting unique key contractin failure.

(Even I cannot update the rest of the column values in dept table as it is also having foreign key dependency) i need to put a sql script in production so that it will interchange.

View 10 Replies View Related

RAC & Failsafe :: Query Doesn't Have Any Parallel Hints

Jul 10, 2013

Below query doesn't have any parallel hints. Though, it is without where clause, so full scan is must but why "PX Deq Credit: send blkd" occurred?

SELECT ROWID, REGION, STATE, CITY, DEALERNAME, DEALERCODE, DEALERID, BUSINESSUNIT, GARDEALERID, MASTERCLAIMNUMBER, CLAIMNUMBER, COMPANY, POLICYNUMBER, STARTDATE, ENDDATE, POLICYISSUEDEALERNAME, ISSUEDEALERCODE, CUSTOMERNAME, CUSTOMERADDRESS, ACCIDENTDATE, ACCIDENTTIME, INTIMATIONDATE, INTIMATIONTIME, REGISTRATIONDATE, REGISTRATIONTIME, DRIVERNAME, ACCIDENT_DESCRIPTION, INTIMATION_DELAY_REASON, INTIMATORNAME, INTIMATORMOBILENO, CLAIM_INTIMATED_BY, TOWING_ASSISTANCE, ACCIDENTPLACE, ACCIDENTLOCATION, GARAGENAME, WORKSHOPADDRESS, WORKSHOPMOBILENO, MANUFACTURINGYEAR, CHASSISNUMBER, ENGINENUMBER, REGISTRATIONNUMBER, VEHICLEMODEL, BUSINESSTYPE, TOTALSI, CLAIMEDAMOUNT, ESTIMATEDAMOUNT, "LABOUR(E)", "PARTS(E)", "PAINTING(E)", EXCESS,
[code]....

understand about "PX Deq Credit: send blkd"..

View 1 Replies View Related

SQL & PL/SQL :: Role Dependency - Additional Privileges

Aug 6, 2012

I want to find role dependency on another role.

1. If its a basic role (made of priviliges), what data dictionary view I should query?

2. If the role is made of some other role and additional priviliges, what query I should fire to find that?

3. Role is granted to which users?

View 15 Replies View Related

SQL & PL/SQL :: Finding Dependency Of Function In Oracle

Nov 26, 2012

Is it possible to find the dependency of a Function whether it is used somewhere in the package or procedure or some other functions?

Suppose I have function named get_valid_loc , Now my question is how to find out in which place this function has been used.

View 13 Replies View Related

SQL & PL/SQL :: Where Conditions That Have Dependency Don't Get Executed In Order

May 26, 2010

While there's numerous QAs about inserting an image into the DB using the Data Block, how does one remove an image? Obviously there's the "UPDATE ... SET X = EMPTY_BLOB();", however, that kills the Data Block/Form's flow, and it doesn't update.

I've tried a few things:

* :CONTROL.IMG1 := NULL; (bad bind variable)
* :CONTROL.IMG1 := EMPTY_BLOB(); (some other error, probably as above)

View 10 Replies View Related

Create Dimension - Functional Dependency Between Levels

Sep 28, 2010

the literature equates dimension hierarchies with fuctional dependencies between the levels. I like to tst the strength of this assumption with the implementation of 'CREATE DIMENSION' which allows you to create roll-up hierarchies.

My question to put it simply is this: Given:

CREATE DIMENSION location_dim
LEVEL location IS (location.loc_id)
LEVEL city IS (location.city)
LEVEL state IS (location.state)
HIERARCHY geog_rollup (
location CHILD OF
city CHILD OF
state CHILD
)

Can I insert the following rows into the dimension:
loc_id, city, state
1, Epping, NSW
2, Epping, VIC

Please note that the two Eppings are different cities.

Given the roll-up hierarchy City -> State, will it require that for every city there can be only one state in which case the FD between City and State cannot hold. Or, is it that the roll-up hierarchy defined here has nothing to do with FD.

The second part of the question is if the answer to the above question is that the roll-up is not the same as FD, then is the ATTRIBUTE clause meant to define the n:1 (functional dependency) instead?

View 4 Replies View Related

Server Administration :: Create New Service For Database?

Jul 16, 2010

create a new DB service and apply the load , then I need to verify the service load from Enterprise Manager or table V$SERVICEMETRIC .

Below are what I did

Quote:I tried to add service in tnsnames.ora like below

SERVICE = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SID=tgc4)))

/************
Also I tried the serviceName like below, but not working when I conneted SALES1 from sqlplus
SALES1 = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=25057)(HOST=dadvmc))(CONNECT_DATA=(SERVICE_NAME=host.us.xxx.com)))
**********/

and login as

sqlplus scott/tiger@SERVICE[/email][/email]

then lock table EMP in exclusive mode in two session.

I can see the load is added to service SYS$USERS , but I can't see the new service from V$SERVICEMETRIC or Enterprise Manager.

select
SERVICE_NAME
from V$SERVICEMETRIC

How could we create the new DB service?

View 5 Replies View Related

Clusterware :: Unable To Connect Database Service?

Apr 29, 2013

We are getting problem while installing OID Infrastructure on one node.

metadata repository database: 10g R1 (10.1.0.2.0)
OID: 10g R1 (10.1.0.2.0)

We had installed in node 1 & now the partition is shifted to node2 ,But installation on OID infrasturcture, when we aretrying to connect repository database, it says, hostname:<PORT> service may not be avaialble, listener may not be up.unable to connect
orcl.test.com

whereas the service is running & listener is up. We copied inventory location and oraInst.loc and oratab file from node1 to node2, But still unable to connect metadata repository from infrastructure node.What are we missing here..

View 0 Replies View Related

PL/SQL :: Legacy Data Migration Project - Cyclic Dependency Records

Mar 1, 2013

It's been a while since I worked with SQL Plus . I am using Oracle 11g. We are working on a legacy data migration project. I have a table of records with circular dependency records. i am trying to identify the records. I have the foll. columns- Product,Source,target. I want o identify the records which form a loop. For e.g.

Source Target
A B
B C
C D
D A

Last record forms a loop-I need to identify these records. My query is below-

SELECT DISTINCT SOURCE,TARGET FROM RULESELIB WHERE CONNECT_BY_ISCYCLE=1 CONNECT BY NOCYCLE SOURCE=PRIOR TARGET;

I ran this query on 2 tables- one with 75000 records and the other with 25000 records. It works fine on the table with 75000 records completes within a minute but it does not complete on the other table. I can't seem to be able to figure out the issue with the query or is there something about the data that is causing this query to loop infinitely?

View 11 Replies View Related

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

Size Of Typical Oracle Database Install Plus Service Pack?

Aug 25, 2011

I was just asked by one of the sysadmins what the typical size of an oracle database install plus service pack be?

View 1 Replies View Related

Cloud Service :: Installing Oracle Management Agent In 11g Database (11.2.0.3)?

May 6, 2013

Error occurred, While installing the agent in 11g database.
Error is listed below

[oracle@grid agent]$./agentDeploy.sh AGENT_BASE_DIR=/ebiz/oracle RESPONSE_FILE= agent.rsp
AGENT_BASE_DIR=/ebiz/oracle
Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /ebiz/oracle/core/12.1.0.1.0/jdk/bin/java -classpath /ebiz/o

[code]./..

Executing agent install prereqs... Executing command: /ebiz/oracle/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSys rereqs -prereqchecker -silent -ignoreSysPrereqs -waitForCompletion -prereqlogl c /ebiz/oracle/core/12.1.0.1.0/cfgtoollogs/agentDeploy -entryPoint oracle.sysma .top.agent_Complete -detailedExitCodes PREREQ_CONFIG_LOCATION=/ebiz/oracle/core 12.1.0.1.0/prereqs -J-DORACLE_HOSTNAME=grid.4iapps.com -J-D

[code]...

View 5 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

RAC & Failsafe :: Difference Between RAC And Non-RAC Database

Sep 13, 2012

Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?

View 4 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







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