SQL & PL/SQL :: How To Check If The Cluster Exist In Database

Apr 27, 2010

We can use the clause "CREATE CLUSTER mycluster.." to create a cluster.

How to check if the cluster exist in my database, so I don't have to create the cluster again.

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: How To Check Record Exist In Table

Feb 13, 2013

Usually we check 1 row of data in table and compare if they exist, i want to compare different set of row all together to comapre and take the decisions

eg.

emp table_source
d_key emp_no invol
1 103499 1
1 99262 2
2 103499 1
3 103499 1
3 99262 2

target table

emp_no invol
103499 1
99262 2
103499 1

in the above example i have to check for d_key for set of row exist in target or not, so by above example d_key 1 and 3 has save value in 2 different rows so i want to check if the combination of rows

103499 1
99262 2

as a set appear in source then do nothing else insert so first time d_key 1 both records will insert but for d_key has same set in 2 rows will not be inseted. the number of row can be more than 2 also . so for the given key if we have 3 rows in source then i have to compare all the 3 same set of row in target exist of . in the target i don't have any extra column.

View 3 Replies View Related

Intermediate State / Check Cluster Resources By Srvctl Status Resource

Oct 17, 2013

We are in 11gR2 in windows 2008. Our database is 2 nodes rac. I got alert message below.

Host=xxxx.xxxx.xxxx.xx.xxTarget type=Cluster Target name=ora-scan Message=ora.registry.acfs has 1 instances in INTERMEDIATE State Severity=Warning Event reported time=Oct 17, 2013 6:40:45 AM EDT Operating System=Windows Platform=x64 Associated Incident Id=xxxx Associated Incident Status= New Associated Incident Owner=SYSMAN Associated Incident Acknowledged By Owner=No Associated Incident Priority=Low Associated Incident Escalation Level=0 Event Type=Metric Alert Event name=resource_status:crs_event_composite_status Metric Group=Resource StateMetric= State ChangeMetric value=PARTIALLY_INTERMEDIATEKey Value=resource_ora.registry.acfs.type_ora.registry.acfsKey Column 1=KeyRule Name=EDC - Metric Alert,Warning Rule Owner=SYSMAN Update Details:ora.registry.acfs has 1 instances in INTERMEDIATE State Incident created by rule (Name = EDC - Metric Alert, Warning; Owner = SYSMAN).

I did check the cluster resources by srvctl status resource -t and all of resources are in online and none of them i saw in intermediate state. Is there any other command and option to investigate this error?

View 6 Replies View Related

SQL & PL/SQL :: Check If Object Exist Or Not While Creating Procedure?

Mar 5, 2012

I have to create a stored procedure having some 10 cursors and i have to display the data's fetched by select statement in cursors using dbms_output.put_line().

for ex:
-------
CREATE OR REPLACE PROCEDURE PROC AS
CURSOR C1 AS SELECT * FROM EMP;
BEGIN
FOR R IN C1
LOOP

[code].....

My question is while creating procedure i want to check if the object exist in database or not.

If EXIST
NO PROBLEM MY CODE CREATE THE PROC AND EXECUTED FINE
IF NOT EXIST

I don't want an exception to be thrown stating "OBJECT DOES NOT EXIST" I wanted PL/SQL engine not to execute the particular select statement itself and continue executing other select statements.

The reason why have such kind of wierd requirement is my program displays all the CEMLI objects in any 11.5.10 instance. I don't know whether they have installed discoverer or not. if they installed it no problem else my program have to eliminate.EXECUTE IMMEDIATE, REF CURSOR becoz i tried it and works fine.but not able to wrap in WRAPPER UTILITY 8.0 versions.

View 14 Replies View Related

SQL & PL/SQL :: Check If Table Exist In Scheme - If Not Create As Original DDL

Aug 13, 2013

I have 20 or so tables, partitioned by range, indexed etc...soon these tables will be gone and i have to recreate them with the same definitions. I have to write a procedure(or script, it's up to me) which must:

1- check if table A exist in the scheme
2- if not create the table as the original ddl.

for 1 i've used smth like
-------------------------
SELECT count(*)
INTO a
FROM user_objects
WHERE object_name='A';

[code]....

so my question is how and what is the cleanest and fastest way to do this.? it's a lot DDLs,

View 17 Replies View Related

Oracle Standalone Database To (RAC) Real Application Cluster Migration

May 16, 2011

How to migrate Oracle Standalone Database to Oracle Real Application Cluster?

View 1 Replies View Related

Forms :: Put One Check Box To Check All The Check Boxes?

Jul 30, 2011

I want to put one check box to check all the check boxes.how can i do this?

View 5 Replies View Related

Server Administration :: Inserting Data To Oracle Database - Shared Memory Realm Does Not Exist

Sep 24, 2013

i am continuously inserting data to oracle database after some time like 2 hours oracle disconnects,it creates erros like

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0

after restarting the database with shutdown immediate ans startup if i start inserting records it will show erros like

ORA-01653: unable to extend table SYSTEM.GLT_PROT_TRAFFIC_SUM_VOIP by 8192 in tablespace GLCOMM

but i have created the Tablespace with BigFile Auto Extend and max size unlimited, i am having 400GB disk space created Redo logs with 15gb,i have tried serveral times reinstalling the oracle but problem is not solved.

same problem is happenging with small datafiles also,

operating system: windows server 2008 R2 standard
oracle server : 11g
oracle client : 64 bit

View 14 Replies View Related

Client Tools :: Unable To Connect Database / ORA-27101 / Shared Memory Realm Does Not Exist

Feb 21, 2012

[oracle@localhost ~]$ sqlplus system/password
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

But when i am using SID name while connecting to database i am able to connect...

[oracle@localhost ~]$ sqlplus system/password@apple
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>

I have only one database...

TNS.......
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
APPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 72.0.0.11)(PORT = 1521))

[code]...

View 6 Replies View Related

How To Check Locks In Database

Apr 13, 2013

oracleDatabase version:11gR2

Os:solaris

how to check locks on database objects .it might be any lock? any select sql query to check database object levlel locks?what basis locks will occur?

View 3 Replies View Related

Database File 1 Failed Verification Check

Apr 3, 2011

i did the following steps for resolving.

1 alter database backup controlfile to trace;

2 startup nomount;

3 recover database using backup controlfile;//in this step generate error msg "database not mounted"

4 alter database open// this is also happend above error

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/app/oracle/oradata/DB11G/system01.dbf'
ORA-01207: file is more recent than control file - old control file

View 6 Replies View Related

SQL & PL/SQL :: How To Check Open Http Connections In Database

Apr 13, 2012

How to check the open http connections in the database as I am getting.

ORA-29270: too many open HTTP requests

View 7 Replies View Related

Check If Database Is Idle Or Not From Batch File?

Aug 4, 2012

I am running Oracle Database 10g R2 on windows 2003, I want to create a batch file to check if the database is idle or not, and if it is idle shut it down and start it up.

View 13 Replies View Related

PL/SQL :: How To Check Where Table Field Was Used As Foreign Key In Database

May 9, 2013

i have a field in my table office i got field office_code ,this field is been used in diffirent tables as foreign key is there a sql i can wirte to see all tables who have used this field as foreign key.

View 12 Replies View Related

SQL & PL/SQL :: Check Recently Updated Columns / Tables In Database?

Aug 4, 2011

i want a query/function/procedure to check recently updated columns/tables in a database...

View -1 Replies View Related

Server Administration :: How To Check Whether Database Is Dedicated Or Shared

Feb 3, 2012

How to check whether database is dedicated or shared ?

View 1 Replies View Related

Performance Tuning :: How To Check Table Has Changed 10% In Database

Dec 13, 2011

By default the DBMS_STATS package runs once every 24 hours to collect statistics for database objects and Oracle collects new statistics when enough of the data (about 10%) has changed.

My question here is how to check the table has changed 10% in database?

View 23 Replies View Related

Server Administration :: How To Check Oracle Database Uses Java Or Not

Jul 23, 2010

Actually in our environment , sysadmins are upgrading java versions on Unix (HP & Solaris) Machines and they have asked the query whether oracle database uses Java or not?

If it uses then all the databases need to be shut down for their planned activities and if not no need to shutdown the databases.

View 17 Replies View Related

SQL & PL/SQL :: Query To Check Database Running Using Spfile Or Pfile

Nov 23, 2011

provide me the query to check our database is running using spfile or running using pfile.

View 2 Replies View Related

Security :: Check Users / IPs Who Connect To Database In Specific Time

Jan 22, 2013

Is there a way where I can check users/IPs who connect to the database in a specific time 2 days ago?

View 5 Replies View Related

Data Guard :: Check If Database Encrypted Or Not On Primary / Standby?

Jul 25, 2013

We have a primary and a standby (Physical Dataguard) site.

1. How do i check if the database is encrypted or not on primary as well as standby ?
2. If primary and standby are encrypted, does the data that gets replicated from primary to standby also in encrypted form ? If not, does it make sense to encrypt that ?

View 2 Replies View Related

SQL & PL/SQL :: Check Listener Time Zone Settings / Values In Oracle 10g Database?

Nov 28, 2011

How to check the listener time zone settings/values in Oracle 10g database?

View 5 Replies View Related

Stopping Cluster Along With HAS?

Sep 17, 2013

I wanted to make my11g cluster down along with high availability.Documents says, Stop the cluster stack by using crsctl stop cluster and then execute crsctl stop crs command to stop HA. What is the difference if I am using the following commands?

1. crsctl stop cluster
crsctl stop crs

OR

2. crsctl stop crs

As per my understanding, crsctl stop crs command stops entire cluster stach plus has.

View 1 Replies View Related

Scan In 4 Node Cluster

Jun 24, 2013

We are going to setup a 4 node rac cluster. So i think we need to configure only one SCAN with 3IP's. And how the scan listeners are configured on these 4 nodes.

View 1 Replies View Related

RAC & Failsafe :: Cluster In Oracle

Apr 23, 2013

Are Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?

View 6 Replies View Related

To Query The Cluster Name From Server

Dec 20, 2012

We have few Solaris RAC Clusters. When I try to query the cluster name from server using the following command i get the same result for all the clusters.

soc02n02-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

soc03n01-oracle> cemutlo -n -w
ORA_CRS_01
2:1:

While in the OEM Grid Console it shows the separate name given to each of them. Check the attached .pdf

Q.Why the cluster names are same from the OS level but different in the OEM console.
Q.Is there any way we can find out the individual cluster names other than cemutlo commands.
Q.In OEM why is the "Cluster" different from the "Cluster name"

Attached File(s)

SOC_Cluster.pdf ( 27.63K )
Number of downloads: 2 

View 1 Replies View Related

Combining Hash Cluster And Indexes

Oct 28, 2010

A basic select and group by query I am optimising for my Database course has returned results that indicate it will perform better on a clustered index when returning a smaller number of rows (5% of the largest table) and on a hash clustered index when returning higher volumes (50% and 80%). I understand that it is possible to use more than one index type on a table to improve performance, but I am struggling to understand how I might establish a hash cluster and a cluster on the same table? and then use hints to drive the query down one access path or the other.

Site admin - this site is a very useful resource.

View 5 Replies View Related

Consolidate RAC Databases In Single GI For A Cluster

Jul 11, 2012

I had installed grid infrastructure for a cluster, and RAC database. The ASM is the storage option. The configurations as follows:

Grid Home: /u01/grid/app

Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1

Can I have another RAC Database to use the existing Grid infrastructure ? The second RAC database will have different owner than db1.

The configurations as follows:

Grid Home: /u01/grid/app

DB1 Oracle RAC Home: /oracle/db1/app/product/11.2/dbhome1 and Database Name: RACDBA so the current instances are RACDBA1 and RACDBA2

DB2 Oracle RAC Home: /oracle/db2/app/product/11.2/dbhome2 and database name: RACDBB so the future instances will be RACDBB1 and RACDBB2

View 1 Replies View Related

RAC & Failsafe :: Oracle Cluster 10 Installation

Oct 27, 2010

Steps for installing Oracle Cluster 10?

View 9 Replies View Related

SQL & PL/SQL :: How To Create Single Table Cluster

Mar 6, 2010

I have one table called posh, which has about 50,000 ids (millions of rows) so far. It is currently at about 50 gb. So each series of rows for a particular id is about 1 mb.

CREATE CLUSTER posh_cluster (id int)
SIZE 2M
STORAGE (initial 2000K next 2000K)
PARALLEL 4;
CREATE INDEX posh_cluster_index ON CLUSTER posh_cluster;

[code].......

According to the Oracle documentation size is "the average cluster key size", I am not really sure what that means. Is this the 1mb in posh table space I am using for each series of rows for an id, or the space used for the index? Secondly, the storage parameter for 'CREATE CLUSTER' should be what?

View 11 Replies View Related







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