RAC & Failsafe :: Oracle User Equivalence Not Working After Two Nodes Configured?

Feb 22, 2011

i am have a problem with Oracle user equivalence. long time ago, we have created Two node RAC. that time, we configured Oracle user equivalence.

today when i am trying to install Oracle Agents on this RAC pair, installation was failed due to Oracle user equivalence. not sure how it happened, and i was confused too.

if i configure Oracle user equivalence again, will it cause any problem to my RAC setup?

is there any way to find, when was the Oracle user equivalence was changed/ ssh keys got changed?

View 2 Replies


ADVERTISEMENT

RAC & Failsafe :: DNS Response Time For Nodes

Feb 24, 2011

I'm trying to install 2 nodes oracle RAC 11gR2 on SLES11. I configured DNS for public,virtual, private and scan IPs. when I check with nslookup, everything seems ok. but when I run runcluvfy.sh, it says that:

" PRVF-5636 : The DNS response time for an unreachable node exceeded 15000 ms on following nodes: rac1,rac2"

How can I decrease the response time?

View 4 Replies View Related

Real Application Clusters :: Removing 2 Nodes From A Cluster Of 4 Nodes?

Nov 6, 2012

[URL] I arrived at step 2 (Step 2: Delete Nodes from the Cluster) point 4 and 5.

I executed this correctly (on 2 nodes):

For a nonshared home:

To delete a node from a cluster:

./runInstaller -updateNodeList ORACLE_HOME=Oracle_home CLUSTER_NODES="" –local

Output:

[oracle@server03 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES="" -local
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 20127 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.then I executed:

To deinstall the Oracle home from the node you are deleting, run the following command from the Oracle_home/oui/bin directory:

./runInstaller -deinstall -silent "REMOVE_HOMES={Oracle_home}" -local

Output:
[oracle@server03 bin]$ ./runInstaller -deinstall -silent "REMOVE_HOMES=$ORACLE_HOME" -local
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 20127 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2012-11-06_12-05-36PM. Please wait ...[oracle@server03 bin]$ Oracle Universal Installer, Version 11.1.0.7.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

[code]....

When I arrive to the point 5 I see one resource ora.DPCTTest.db ONLINE on one server (server02 or server03 that are the nodes I want to remove).
If I execute:

crs_relocate ora.db_name.db

I obtain:
[oracle@server03 bin]$ ./crs_relocate  ora.DPCTTest.db
Attempting to stop `ora.DPCTTest.db` on member `server02`
Stop of `ora.DPCTTest.db` on member `server02` succeeded.
Attempting to start `ora.DPCTTest.db` on member `server03`

[code]....

View 5 Replies View Related

JDeveloper, Java & XML :: Extracting Sub-nodes From XML With Multiple Nodes?

Oct 27, 2011

how to extract sub nodes from multi nodes in this file.

<?xml version="1.0" encoding="utf-8"?>
<Orders>
<LeasingCoNum>123456</LeasingCoNum>
<DateTime>10/05/2011 10:00:00 AM</DateTime>
<NewOrders>
<Order>

[code]....

View 9 Replies View Related

RAC & Failsafe :: Two Nodes Active / Active Configuration

Oct 15, 2013

I am getting starting with rac environments. I need to configure a two nodes active/active with rac and I need to know if always using rac both nodes will be active or if I have to do that at some point when installing. I have reading some docs from oracle and others authors about rac and its configuration process but that is not understood for my yet.

View 5 Replies View Related

SQL & PL/SQL :: Compound Trigger Equivalence?

Jun 23, 2011

I have a table T_TEST, i will update the table rows, i want to add a single record in some other table let say T_A, which contains the sum of the updated difference of all the records.

let say, if i have T_TEST with values of 100, 200 and if i update it to 500, 600 (oldvalue+200) then my T_A should contain a record which is 400.

I was able to implement the solution in Oracle 11.2.0.1 using compound triggers. I would like to know how to do it in earlier versions of oracle or Is ther any other way to do it.

create table t_test ( a number);

begin
insert into t_test values (200);
insert into t_test values (200);
insert into t_test values (200);
insert into t_test values (200);

[code]...

View 12 Replies View Related

Forms :: Configured Webutil For OAS On Oracle EBS R12 Linux 64?

May 1, 2010

I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.

Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"

webutil configuration steps on R12 or the error solution,

View 1 Replies View Related

Oracle 10gR2 - OEM Database Control Configured For DBs

Jul 24, 2013

 I have multiple oracle (10gR2) databases running on a linux (5.8) server. How can I check that for which of the databases has the OEM Database Control been configured and on what port is it listening?

View 7 Replies View Related

From Oracle 10g Single Instance To 11g R2 Two Nodes RAC

Aug 17, 2011

Initial situation: Oracle 10g database single instance on Windows 2008 (datafile within NTFS partition)
Final situation: same database upgraded to Oracle 11g r2 on a two nodes RAC on Windows 2008 (datafile within ASM)

In your opinion, is this the best way to achieve the job ?

1) on the two nodes install grid 11gr2, asm, rdbms 11g r2 (SE)
2) export full from 10g
3) create a new empty 11g r2 database in the RAC 11g r2 infrastructure with the same tablespace layout of 10g database
4) import full from 10g to 11g r2

View 1 Replies View Related

Possible To Have Oracle RAC Standard Edition With 3 Nodes Of Intel Quad Core

Feb 5, 2013

I read that Oracle RAC which is bundled in Standard Edition can support at max 4 sockets. One of my client has a proposal of using RAC but for 3 nodes each using single 1 quad core Intel processor. As far as i understood, an Intel quad core is a multi chip module and actually is a combination of 2 modules dual core, so each Intel quad core may be counted as 2 sockets. Which yield to the proposal of my client will be failed, as the total number of sockets in it will be: 2*3=6 that exceed the max 4 support.

View 4 Replies View Related

RAC & Failsafe :: Cluster Does Not Recognize DBA Group Membership Assignment To User

Aug 18, 2011

It appears that the Oracle RAC cluster does not recognize the 'dba' group membership assignment to a user, unless it is assigned as the user's primary group.This also only affects newly created users, older users do not have this issue.

This affects us in the following way:

We are unable to create new cluster resources with the SAPCTL tool with the <sid>adm user.

When we try to create a resource using sapctl as the <sid>adm user we receive the following error:

CRS-0259: Owner of the resource does not belong to the group. SAP ABAP VIP creation failed.

The description of this error is that the resource owner (<sid>adm) is not a member of the group defined by 'osdbagrp' (what the cluster expects group membership for os users to control cluster resources), in our case this group is 'dba'.This is despite the user definitely being a member of the group.

Resource creation workaround:We are able to get around the resource creation by creating the resources either as root user, or by assigning 'dba' as <sid>adm's primary group.However, although we are able to control the VIP cluster resource, we are unable to control the other SAP enqueue resources as we assume that they need to be created by a user with 'sapsys' as a primary group (i.e. the resources do not start or it appears that there is not even an attempt to start the resources as there are no SAP startup logs created).

We have attempted multiple variations of creating and controlling cluster resources: changing <sid>adm primary group, changing cluster resource permissions, with nothing working for us.

The bottom line is that we need to be able to create these sapctl resources with a <sid>adm user that has 'sapsys' as a primary group while also being a member of the 'dba' group.

View 1 Replies View Related

Security :: Authenticating Oracle User Based On Windows User ID?

Mar 11, 2011

We are trying to implement the following security to our database.

As of now, the access rights are same for all the windows users logging into the Oracle application with the same Oracle user Id.

But now, we want to improve our security by granting different levels of rights to the users based on their Network Id even though they use the same Oracle User Id to log into the application.

We are not looking for the users to be identified externally.

(CREATE USER "OPS$ORACLE-BASE.COMTIM_HALL" IDENTIFIED EXTERNALLY;
GRANT CONNECT TO "OPS$ORACLE-BASE.COMTIM_HALL";
)

View 3 Replies View Related

OS User Occupying Shared Memory As Oracle User

Dec 11, 2012

we are trying ti implement BMC monitoring tool for our oracle 11g2 RAC/solaris10 environment. for the purpose we create a user called bmcuser in OS level, this user connecting database to monitor, this user occupy shared memory as oracle. Explain why this user taking that much shared memory just to connect database using sqlplus.

oracle taking 55% bmcuser taking 44%,

SQL> show parameters memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3232M
memory_target big integer 3232M
shared_memory_address integer 0
SQL> show parameters sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3232M
sga_target big integer 0
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
6449 bmcuser 47M 44M sleep 23 10 0:57:31 0.2% PatrolAgent/1
[code]........

pga & uga usage sessionwise

SID     ORA_USR     OS_USR     S_PROG     S.MACHINE     S.PGA_MEM     S.PGA_MEM_MAX     S.UGA_M     S.UGA_M_MAX
252     (null)     oracle     oracle@racdev1.zakathouse.org (ARC3)     racdev1.     31054584     32168696     181056     181056
227     (null)     oracle     oracle@racdev1.zakathouse.org (ARC2)     racdev1.     31054584     32168696     181056     181056
177     (null)     oracle     oracle@racdev1.zakathouse.org (ARC0)     racdev1.     31054584     32168696     181056     181056
576     (null)     oracle     oracle@racdev1.zakathouse.org (LGWR)     racdev1.     16693544     21281064     181056     181056
326     (null)     oracle     oracle@racdev1.zakathouse.org (LMS0)     racdev1.     13753080     13753080     181056     181056
376     (null)     oracle     oracle@racdev1.zakathouse.org (LMS2)     racdev1.     13556472     13556472     181056     181056
[code]........

View 6 Replies View Related

Configured 2 Listeners Through Netca In Different Ports

Mar 15, 2011

I have 2 databases( A and B).. which shares common ORACLE_HOME.i configured 2 listeners through netca in different ports and both listener names are different...

But when I stop LISTENER.. both the listeners are getting stop and when i start both the listeners are up and running.. and I could see database B's services.. and vice versa.and when i tnsping , i am able to see port 1521 default port for database A.

when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..if so, which SID should I add A or B? from where listener picks the default information???

>> when I run I bash, i have included ORACLE_HOME path... so should i add oracle_SID also there..

Yes, among MANY other things.

CODE#*************************************************************
# Create an alias for every $ORACLE_SID on the UNIX server  
#*************************************************************
for DB in `cat /var/opt/oracle/oratab|\
       grep -v \#|grep -v \*|cut -d":" -f1`
[code]....

"ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

View 4 Replies View Related

Forms :: Configured Formsweb - Webutil Error?

Nov 24, 2011

We have configured formsweb with webutil. When we run the application and try to use webutil file operations the file open dialogue box is coming, but when we press ok, it is showing error. and we have found that error is

Quote:
WUC-15 [FileFunctions.fopen()] Unexpected error, Exception: java.lang.NullPointerException

View 2 Replies View Related

Networking And Gateways :: Listener Configured At Non-Default Port?

May 16, 2011

I have configured oracle listener at Non-Default port 1526.

Is it mandatory to mention LOCAL_LISTENER parameter at pfile?

LOCAL_LISTENER='listenerr_alias'

View 2 Replies View Related

Server Administration :: Database Buffer Cache Configured As 2M

Jan 26, 2011

Say Database Buffer Cache configured as 2M and my updates may use 4m size,will it throw an error message or update will happen perfectly without any issues?

View 2 Replies View Related

Application Express Listener :: 2.0 Configured But Can't Start In Standalone Mode

Feb 25, 2013

I am trying to use the Apex listener 2.0 (instead of HTTP server). I installed and went thru the configuration of the listener, but I must be missing something. When I do the java -jar apex.war to start it up in standalone mode, I get the configuration properties etc., but when I open up my browser and try to bring up APEX with http://localhost:8080/apex/ I get a 500 - Internal Server error with the info below.

***********ERROR*********** init: # headers=43 declare nm owa.vc_arr := ?; vl owa.vc_arr := ?; begin owa.init_cgi_env( ?, nm, vl ); htp.init; htp.HTBUF_LEN := 63; ? := sys_context('USERENV','SID'); end; SID:880 CALL: begin apex; commit; end; BINDS PAGE CALL: declare nlns number := 999999; l_clob CLOB; lines htp.htbuf_arr; l_buff varchar2(32767); l_clob_init boolean:= false; l_file varchar2(5); l_doc_info varchar2(1000); begin OWA.GET_PAGE(lines, nlns); if (nlns > 1) then for i in 1..nlns loop if ( length(lines(i)) > 0 ) then if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then if (NOT l_clob_init) then dbms_lob.createtemporary(l_clob, TRUE); dbms_lob.open(l_clob, dbms_lob.lob_readwrite); l_clob_init:=true; end if; dbms_lob.writeappend(l_clob,length(l_buff),l_buff); l_buff := lines(i); else l_buff := l_buff || lines(i); end if; end if; end loop; end if; if (l_clob_init) then

[code]....

View 4 Replies View Related

Performance Tuning :: Different Timings Between 2 Nodes?

Jun 26, 2013

A select statement in our Performance environment running through toad/sql developer takes 1 min in NOde1 and same select takes 2 mins in Node2.

I have run multiple times on both the nodes and making it run first on 2 then on 1 and vice versa, timings remains same.. Node2 takes more time.

Configs,parameters,SGA and other settings are same between 2 Nodes, This is on 2 Node 11g RAC Oracle 11g Release 2.

View 2 Replies View Related

Replication :: Setup ASR Running Between 2 Nodes

May 5, 2011

We have 2 Sun Solaris (Solaris 10) nodes each has an oracle db, and OID of the above versions.There is an ASR running between both nodes, and it has been setup as follow:

$ ./ldap/bin/remtool -asrsetup -v
------------------------------------------------------------------------------
ASR Setup for OID Replication

Make sure that the replication administrator that you enter below does not exist already in any of the nodes that will be part of the DRG to be created now. If the user exists, that user will be dropped and will be created newly.

------------------------------------------------------------------------------
Enter replication administrator's name : repadmin
Enter replication administrator's password :
Reenter replication administrator's password :
Enter Master Definition Site (MDS) details :
Enter global name of MDS : node1
[code].....

We ran a perl script which is using ldapmodify to change the value of one attribute in all records (7 Millions records).That has been done by creating many of LDIF files each of 10,000 records in 26.04, and by mistake this script has ran 3 times in parallel.Currently the replication between both nodes are stuck, and when I query the ods_chg_log on the master node (node1):

SQL> select count(*) from ods_chg_log;

COUNT(*)
----------
6690594
And the number is not decreasing.
And I queried on the asr_chg_log on the master node (node1):
SQL> select count(*) from asr_chg_log;
[code]....

View 1 Replies View Related

Data Guard :: ARCH Wait On SENDREQ While Configured With LGWR ASYNC Attributes?

Oct 5, 2010

In statspack I find a lot of wait events "ARCH wait on SENDREQ". The database is configured with the LGWR ASYNC attribute. In the documentation I can read that the "ARCH wait"-events may happen in case the database is configured with the ARCH attribute.How is it possible I get these "ARCH wait"-envents and do these wait events have any effect on the "on line" performance of the database? Is it possible that a user that saves data in the database has to wait for thest "ARCH wait"-events?

View 1 Replies View Related

RMAN :: Configured Recovery Catalog / Started Full Online Backup Using EMC Networker

Nov 27, 2012

I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

My question is, if I need to restore Backup of last 15 days then I can ?.

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

RAC & Failsafe :: RPM For Oracle Installation

Nov 28, 2010

i need to make RAC database setup ,so where can i get the operating system Rpm like bleow

compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386

send me link for the above require rpm for linux AS4.

View 1 Replies View Related

RAC & Failsafe :: SCAN IP For Oracle 11g R2?

Sep 1, 2011

I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.

View 6 Replies View Related

RAC & Failsafe :: FAILOVER In ORACLE 10g

Dec 20, 2012

My application uses below jdbc url for database connectivity. Today one of the db node was down for one hour and FAIL OVER did not happen.

<connection-url>
jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON )(ADDRESS=(PROTOCOL=TCP)(HOST=viphost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=viphost2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serv ice_name)))
</connection-url>

View 5 Replies View Related

Data Guard :: Find Out Number Of Standby Databases Configured For Primary Database From OS Level?

Nov 14, 2013

How can find the number of standby databases configured for primary database from os level

View 9 Replies View Related

Duplicate RAC Database With ASM And 2 Nodes To A Single Node?

Apr 30, 2010

i'm trying to duplicate my RAC database with ASM and 2 nodes to a single node, non ASM with rman duplicate database for standby with active database on windows. The problem is i dont know how to remove RAC configuration when duplicating the database.

Here is the procedure:

On standby i've:
- installed database software,
- configured listener and tnsnames,
- added instance service (oradim -new -sid STANDBY -intpwd PASSWORD -startmode M),
- configured initora (with only db_name = STANDBY)
- configured orapwd file
- startup nomount

on RAC node1:

rman target sys/PASSWORD@RAC
connected to target database
RMAN> connect auxiliary sys/password@STANDBY
connected to auxiliary database: STANDBY (not mounted)

now for the duplicate command:

RMAN> duplicate target database
2> for standby
3> from active database
4> spfile
5> parameter_value_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY'
6> set db_unique_name='STANDBY'
7> set log_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY'
8> set db_file_name_convert = '+DATA/RAC','D:\oracle\11.2.0\DATAFILES\DATA\STANDBY';

i have tried adding this parameter - set cluster_database='false' but no luck.

View 7 Replies View Related

ORA-00932 - Sample Code Working Fine In 10g And Not Working Now In 11g

Apr 1, 2013

Below is the sample code working fine in 10g and not working now in 11g.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "PSTest" AS
import java.sql.SQLData;
import java.sql.SQLException;
import java.sql.SQLInput;
import java.sql.SQLOutput;
import java.util.List;
[code]....

we got the below error: ORA-00932: inconsistent datatypes: expected an IN argument at position 1 that is an instance of an Oracle type convertible to an instance of a user defined Java class got an Oracle type that could not be converted to a java class

Current Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit and the version we are upgrading is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

View 3 Replies View Related

RAC & Failsafe :: Oracle 11gR2 RAC On Unix

Aug 8, 2011

I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?

View 3 Replies View Related







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