RAC & Failsafe :: Differences Of Enabling Thread As Public Or Private?

Aug 25, 2012

differences of enabling thread as public or private?

lets assume that i have two threads (1, 2) for two instances (1, 2) and each of thread consists of 2 redolog groups - minimum configuration.in case i need add third node i need third thread.

what will be difference if i set this thread as public instead private?

View 7 Replies


ADVERTISEMENT

RAC & Failsafe :: Change Cluster Interconnection From Public To Private?

Jul 3, 2013

how to change the cluster interconnection from public to private.

View 6 Replies View Related

Networking And Gateways :: Testing Private Database Link With Same Name As Public

Oct 13, 2010

We are currently replacing all public database links with private db links in our prod environment. The requirement is

1) private db link name should be same as public
2) Need to create and test out private db links before we can drop public db links.

How can we test out private db links while public db links are still there with the same name?

when I execute SELECT * FROM DUAL@DBLINK from user who created this private db link, which db link it will be using- public or private?

View 9 Replies View Related

Real Application Clusters :: Node Crashes When Enabling RDS For Private Interconnect

Jan 10, 2013

OS: oel6.3 - 2.6.39-300.17.2.el6uek.x86_64
Grid and DB: 11.2.0.3.4

This is a two node Standard Edition cluster.

The node crashes upon restart of clusterware after following the instructions from note:751343.1 (RAC Support for RDS Over Infiniband) to enable RDS. The cluster is running fine using ipoib for the cluster_interconnect.

1) As the ORACLE_HOME/GI_HOME owner, stop all resources (database, listener, ASM etc) that's running from the home. When stopping database, use NORMAL or IMMEDIATE option.

2) As root, if relinking 11gR2 Grid Infrastructure (GI) home, unlock GI home: GI_HOME/crs/install/rootcrs.pl -unlock

3) As the ORACLE_HOME/GI_HOME owner, go to ORACLE_HOME/GI_HOME and cd to rdbms/lib

4) As the ORACLE_HOME/GI_HOME owner, issue "make -f ins_rdbms.mk ipc_rds ioracle"

5) As root, if relinking 11gR2 Grid Infrastructure (GI) home, lock GI home: GI_HOME/crs/install/rootcrs.pl -patch

Looks to abend when asm tries to start with the message below on the console. I have a service request open for this issue but

kernel BUG at net/rds/ib_send.c:547!
invalid opcode: 0000 [#1] SMP
CPU 2

[code]....

View 9 Replies View Related

JDeveloper, Java & XML :: How To Get Thread ID

Dec 18, 2010

I want to do concurrency program analysis, how can I get the id of the thread when this thread started dynamic in the progress of execution?

View -1 Replies View Related

Thread 1 Cannot Allocate New Log / Sequence In Alert Log

Jul 11, 2012

I am getting the below message in my alert log

System: AIX6.1 - Oracle 11r2

GROUP#     THREAD#     MEMBER                                  ARCHIVED     STATUS             MB
1     1     +DATA01/mydb/redolog_group1_member1     NO         INACTIVE             1536
1     1     +DATA01/mydb/redolog_group1_member2     NO         INACTIVE             1536
2     1     +DATA01/mydb/redolog_group2_member2     NO         CURRENT          1536
2     1     +DATA01/mydb/redolog_group2_member1     NO         CURRENT          1536
3     1     +DATA01/mydb/redolog_group3_member2     NO         INACTIVE             1536
3     1     +DATA01/mydb/redolog_group3_member1     NO         INACTIVE             1536Tue Jul 10 18:37:48 2012
[code]....

Could an increase on the redo log file sizes solve this problem? Unfortunately I do not have a test platform, where I could have tested this.

View 14 Replies View Related

Find Thread That Opened A Session In AIX

Sep 3, 2012

As stated in "Determining which Oracle database session is being used by a specific Siebel user session [ID 863771.1]":

On the Oracle database side, you can query the V$SESSION table (make sure you are logged in as the tableowner) using the following WHERE clause format:

WHERE PROCESS='XXXX:YYYY'

XXXX = Server PID
YYYY = Thread ID

So querying v$session, sessions opened by windows clients have in the PROCESS column values like "12345:876", where 12345=process id and 876=thread id.

Our application servers are installed in AIX, which is also multithreaded, but in the PROCESS column only process id is stored. Is there any way to find thread id?

View 17 Replies View Related

ORA-00338 - Log 3 Of Thread 1 Is More Recent Than Control File

May 9, 2013

I encountered error ORA-00338 while performing incomplete database recovery:

ORA-00283: recovery session canceled due to errors
ORA-00338: log 3 of thread 1 is more recent than control file
ORA-00312: online log 3 thread 1: '+DG_REDO/dbase/onlinelog/group_3.267.814820795'
Recovery Manager complete.

I performed this recovery on oracle 10g, ASM database.

1. What are possible causes behind this error ORA-00338 ?

2. This error occurs at the start of media recovery, while RMAN is applying archived logs. So does RMAN apply "online REDO" logs after applying "archived" logs required for recovery or before them ?

3. How does rman come to know that online log 3 is more recent than control file ? How can I get scn of online log & control file in my environment ?

Following are few details related to checkpoint scn/change# info. I found in my environment..Before recovery:

view
v$datafile: 642935
v$datafile_header: 642935
v$database: 642935
v$log: 640956

After unsuccessful recovery (ORA 338 :( )
v$datafile: 640917
v$datafile_header: 640056
v$database: 640906
v$log: 640906

View 26 Replies View Related

Backup & Recovery :: ORA-00314 - Log 3 Of Thread 1 - Expected Sequence 207 Does Not Match 198?

Nov 30, 2011

While starting up my database i am getting this error.by mistake i had moved log files, and after some time again i inserted those log files again into same directory i am getting this error.

View 13 Replies View Related

Data Guard :: ORA-00314 / Log 1 Of Thread 1 - Expected Sequence# 77 Doesn't Match 0

Feb 29, 2012

When i open the primary database in my dataguard env,it raise error?

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00314: log 1 of thread 1, expected sequence# 77 doesn't match 0
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/oracl/redo01.log'

View 9 Replies View Related

SQL & PL/SQL :: DB Differences?

May 17, 2012

I have two Schemas

DMS_NS_STG_1,DMS_NS_STG_2

Both are having same tables but with diffrent data. I want to write a generic code piece for a table to get that diffrences out, it can be for multiple tables. There will be a DB link between two DB.

View 10 Replies View Related

The Differences Between CAT And TAB Table

Jan 1, 2013

1. What's the differences between CAT and TAB?

2. Why doesn't TAB exist in dict?

3. What the appropriate situation for CAT and TAB?

sys@ORCL> desc cat
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)

sys@ORCL> desc tab
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER

sys@ORCL> select * from dict where table_name='CAT';

TABLE_NAME COMMENTS
---------- -----------------------------------
CAT Synonym for USER_CATALOG

sys@ORCL> select * from dict where table_name='USER_CATALOG';

TABLE_NAME COMMENTS
-------------------- -----------------------------------------------------------------
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user

View 2 Replies View Related

Security :: Audit - Without Enabling

Sep 28, 2011

In our database without enabling audit file, we are getting audit file.find the audit parameter output

SQL> show parameter aud

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /app/oracle10g/admin/ytr/adu
mp
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string NONE

View 1 Replies View Related

Unable To Create Public Synonym

May 22, 2011

I have exported and imported a schema from one server to another. In the source schema, I have a public synonym. I do not know the name of that synonym. In the destination schema, the public synonym is missing. How to create the public synonym which is missing in the destination database? In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.

View 2 Replies View Related

Forms :: Enabling In Detail Block

Jun 22, 2011

I have an existing form which i need to customize..In the form in the query block whatever strings we enter..and press the search button..it sets the where clause and use execute query.which populates the detail block which is read only and only 1 column is enabled.

For the Enabled column X I need to enable a button.It has to be done only if the cursor go in the column X

View 1 Replies View Related

SQL & PL/SQL :: Enabling Constraint With Enable No Validate?

Sep 5, 2013

Is there any way to enable the constraint with out validating for the existing information.

As We can accomplish the same functionality when we are adding the constraint for the first time.

Ex: alter table scott.emp add constraint fk_deptno foreign key(deptno) references scott.dept(deptno) enable novalidate

The above SQL statement will enable the constraint with out validating for the existing information. So there is possibility of data will be there only in the child table but not in the parent table for existing information.

But in the future it will not allow to do so,if the constraint is in ENABLE staus.So i am just trying to disable the constraint to insert only into child table & trying to enable it with NOVALIDATE option .

But the following exception is coming .

SQL> alter table scott.emp ENABLE constraint fk_deptno enable NOVALIDATE;

alter table scott.emp ENABLE constraint fk_deptno enable NOVALIDATE

ORA-00905: missing keyword

SQL> alter table scott.emp ENABLE constraint fk_deptno NOVALIDATE;

alter table scott.emp ENABLE constraint fk_deptno NOVALIDATE

ORA-00933: SQL command not properly ended

Instead of dropping & recreating the same constraint , is there any alternate way to do this ?

View 3 Replies View Related

Forms :: Record History Is Not Enabling?

May 1, 2012

I developed a custom form upon which I developed a query find block to query the data on the main form. I have WHO columns in the table and referencing them in the main form. But Some reason when I query the data by pressing the find button on the query block it is retreiving the data properly, but record history is not enabling.

In the query find block I have 3 text fields, 1 check box and 2 date fields.

View 1 Replies View Related

Security :: Encrypt File With GPG Using PGP Public Key?

Oct 21, 2010

I need to encrypt a file with GPG using a pgp public key I never done this, what are the commands..

View -1 Replies View Related

PL/SQL :: Creating View And Public Synonym With The Same Name?

Feb 15, 2013

I am able to create view and the public synonym with the same name but when I am quering view result is showing .

Is there any logic behind this .

CREATE OR REPLACE VIEW emp_dtls as SELECT * FROM emp;
CREATE PUBLIC synonym emp_dtls for emp;
SELECT * FROM emp_dtls;

view result is showing

View 3 Replies View Related

SQL & PL/SQL :: Differences Between Explicit And Implicit Cursor?

Nov 16, 2011

what are the main points that these examples are considered cursors? and why are they called explicit and implicit cursor.

explicit
for x in (select * from emp) loop
dbms_output.put_line('emp no: '||x.empno);
end loop;

implicit
select empno
into vEmpno
from empno
where empname = 'SCOTT';

for all we know that these are not clearly defined on the declaration area as cursor.

View 16 Replies View Related

Build And Load Differences Between Dumps?

Jun 19, 2012

we get daily a full dump from our customer. We have to build the differences of tables (deltas) and load them in separate tables.

There some questions, requiremenst and restrictions:

1) Is it possible the merge the dumps ?

2) How to build the differences as the easiest ?

3) The whole process (import, merge, extract) should be run in batch.

4) We have only a solid knowledge and liitle time for doing.

View 1 Replies View Related

PL/SQL :: Differences Between Calling SQL Statement / Procedure?

Apr 22, 2013

I am planing to write the web-application which use Oracle DB 11g.I would like to understand what are the differences (specially, performance issues, steps of execution, optimizer possibilities) between calling SQL statements and PL/SQL procedures/functions. Which approach is more appropriate, and why?

Examples:
a) WebApp->Call("select * from employees where department_id = ?", 10) ;

b) WebApp->Call("? := mypackage.get_emp(?)", refCursor, 10);

create package mypackage is
function get_emp(dep_id in number) return sys_refcursor is
   begin
    open cur for select * from employees where department_id = dep_id;   
end;
end;==========================================
Requirements: High-concurrency, 100+ db sessions, DB will not be used for business-logic.

View 10 Replies View Related

Enabling Oracle OEM Job To Skip Errors And To Run Continuously

Sep 26, 2010

I have scheduled a ADHOC Oracle JOB in OEM to gather statistics for the database with 100% estimation during weekend. This JOB currently fails because of a batch Job that runs at the same time and drops few old partitions. This OEM job runs for 1 hour and fails because few partitions are getting dropped at the same time.

How i can enable this statistics JOB to skip/Ignore errors and to continue to run to gather complete statistics of the entire database. I have scheduled this job in OEM. how can i enable this SKIP/IGNORE errors for this job.

View 1 Replies View Related

SQL & PL/SQL :: How Make Complete Schema Public Synonym

Apr 15, 2013

how to make the complete schema public synonym, instead of creating public synonym object by object.

View 2 Replies View Related

Forms :: Enabling All Checkboxes When Block Is Loaded

Dec 6, 2012

My requirement is as below,

I have one main form and there is one button when i click on it, another form should be opened which should display multi records with check box for each record.

I have implemented so far. When the new form is opened by default all the records should be checked. if user does not want some of them then it can be unchecked(This can done manually)..

I have put below code in when-new-block instance trigger

set_item_property('LOCKBOX_DETAILS.CB_SUBMIT', ENABLED, PROPERTY_TRUE);

Unable to load the block with all the records checkboxes checked.

View 4 Replies View Related

Application Express :: Deletion Of Public Reports In 4.0?

Sep 4, 2012

As far as I know, in APEX 4.0 no other user other than the one who created a Public report can delete it. Can this behavior be changed somehow?

View 3 Replies View Related

Security :: Grant Privileges To Public User

Jul 9, 2011

grant insert,update,delete,select on staging_tb1 to public;

What is public here? i know something about public user like it is users exist in the database .

View 5 Replies View Related

Server Administration :: Enabling Primary Key On A Big Table

Jun 22, 2012

I have a partioned table that has close to 2 billion rows and a PK of all columns. Becuase of time constrains my APP team wants the PK disabled while they pump into hundreds of thousands of rows with a batch process.

Now I am finding when I enable the PK its eating up close to close to 200GB of temp space.

Is there something I can do to reduce the amount of temp space being used?

View 6 Replies View Related

8i - Read Data From Teradata Using Public Link And Views?

Aug 12, 2011

I am using oracle 8i and need to read data from teradata using public link and views.

View 4 Replies View Related

Security :: Enabling Audits Can They Be Applied On Tables Or Whole Schema

Apr 19, 2013

Enabling of auditing in oracle database, can this be done on some tables or applied on the whole schema/user.

View 5 Replies View Related







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