(2) Whats the difference between CSR_HOME and GRID_HOME ??
(3) If not using ASM in RAC environment, should I still need to create "storage administration role" (i.e. SYSASM/OSASM..) ?
(4) Is password file necessary for RAC instances in each node ?
We have 2 node cluster with 10.2.0.4 home and 11.2.0.2 home under 11gr2 grid infrastructure with ASM in LINUX environment. We are planning to add 3rd node to this cluster. Is there any issues to add 3rd node to existing environment or running fine.
I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
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).
I faced a problem in our production primary DB like the listener was running but it was not connecting through the remote system, when i accessed the primary database.
But when i restarted the listener it started connecting. I want to know the reason for this crash/freeze.
Oracle version: Oracle Database 11g release 11.2.0.1.0 SE1 64 - bit production
We have a 10g environment with DataGuard running for reporting purposes. Our application team is getting ready to upgrade their application and it requires that several SQL Scripts be run to perform the primary database updates. A couple of them are over 1 MB in length. My concern is that these scripts will break DataGuard. I am not a DBA by any stretch, but I seem to remember there are certain limitations with DataGuard.
I have reached back to the team and asked them to have the Vendor confirm these scripts are validated for a DataGuard environment and I have also reached out to the System DBAs for review. I am wondering if there is an utiility available that can check the SQL to confirm if there are any DDL or DML statements that will not work in DataGuard. Likewise, we are going to run these scripts in a non-production DataGuard enabled environment first, but I want to have some level of confidence, that this will be a success.
We have an application, where we invoke a URL pointing to a folder on the Application Server, so that users can download files from the same.
There is user authentication provided for the URL.
Example :
Our application ABC (example) which is built with Oracle Forms 10g, hosted on Application server (itxxx123) inovkes a module GEN9999 which on pressing a button calls a URL which is open in the Internet Explorer browser.
If the URL has been called from the Forms or the Application (ABC), then it should be allowed.
If the URL is called standalone, by Opening IE Browser and invoking the URL, this should not be allowed.
However, there have been security concerns raised during Audit, saying that users can access the URL directly from the Browser instead of the Application. Also the URL is saved the Browser history, so even if the user is no longer working in the Application Team, and has moved out of the team, then the ex-user can still access the URL and view and download files.
Is there any way to restrict access to the URL such that is only accessible when it is called from the Application, and that access is restricted when directly called from the Browser.
I have seen that environment variables in httpd.conf may be usable for the above. However, not sure how to use them from Oracle Forms.
Questions about implementing ARCHIVELOG mode in RAC environment.
Oracle 11gR1 RAC + ASM database. I'd like to implement ARCHIVELOG mode. Each node will have its own archive log.
Does it make sense to place archivelogs on ASM (shared storage)? Or the best practice would be to have some aside "BACKUP" server to place and keep archivelogs from all the RAC nodes there?
Additional question is about archive logs space required estimation. If it's correct to know estimate archive logs space required to get the daily avg number of switch logs
CODEselect round(avg(n_of_switch_logs), 3) avg_num_of_switch_logs from (select trunc(first_time), count(*) n_of_switch_logs from gv$log_history group by trunc(first_time)) and multiply it on size of single redolog?
I am calling a select query inside a procedure but i need to set environment variable 'set linesize 200' inside that procedure but i am not able to create the procedure due to some error. I am attaching the procedure query here with:
before the select query i need to insert this environment variable : "set linesize 200"
I have to create/configure the environment for the database having high volume of the transactions nearly 10000 transactions per day and at peak time nearly 1500 transactions per second.
RAC can be one of the solution but that comes up with high cost. I googled for this type of environment configuration, what could be possible settings need to be configured for this environment configuration in both RAC and Non-RAC.
Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment . When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in UNIX environment
REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed
I am working in all 3 environments: development , Test and Production. How can we access the tables created in one environment in the other environment. Also, request to share the SQL code for the same.
Need patch strategy specially for production environment?? We have production environment and we are planning to patch our databases using PSU pacthes with no downtime. Our production environment has standby. We have one option that we can make standby to primary. Is there any other options that we can use?
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.
We have a RAC in a test environment.It's 2 nodes connecting to an IBM DS3512. The DS3512 has one pool of 8 hard disks (RAID10) which has been then sliced into logical drives:
2 x 1GB then 2 * 400GB
I have been tasked with changing the current configuration as follow:
2 pools of 4HDs in a RAID10 configuration
Then from the first pool: 2 * 1GB 1 * 398GB
from 2nd pool: 1 * 400GB
What I intend to do: 1) shutdown SQL> shutdown immediate; ./srvctl crs stop 2) backup dd if=votingdisk of=voting_disk_backup I already got backups of OCR in $CRS_HOME/cdata/crs/ 3) Perform changes on SAN 4) recreate ocfs2 partitions 5) mount the disks to their folder. 6) recovery recover voting from backup recover ocr from backup 7) Turn service on again ./srvctl crs start SQL> startup;
Would this scenario work. There can be some glitches like the disk names changing after the reconfiguration but I only need to modify fstab for that.
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
I have an 11g installation on a school harddrive that doesn't seem to have any of the environment variables set properly. Even ORACLE_HOME is not set. How can I fix that situation and how many environment variables need to be defined?
Also some of the Oracle scripts seem to use the forward-slash rather than the back-slash for paths. Will Win7 care?
I have to drop some partitions in table on production environment (to get free space). The environment have to be continuously available. I was considering of use ALTER TABLE ... DROP PARTITION ... UPDATE INDEXES but it is slow, because of use clause UPDATE INDEXES. Is there another possibility to remove these data?
I have created a trigger in a different server and is working fine. But then when I implemented the same trigger in a different server (secured) then I'm encountering this error:
PLS-00049: bad bind variable
Below is the code for the trigger for reference:
create or replace TRIGGER TRG_ROLE_RIGHT_HISTORY BEFORE INSERT OR UPDATE OR DELETE ON MAS_BPI.LOS_SEC_ROLE_RIGHT_MAPPING FOR EACH ROW DECLARE
An application uses one user as a container of objects(this user is stripped of ALL privileges), and other users that can access objects in this unique schema depending on their privileges.
There can be multiple installations of the application in one database, therefore many such schemes. An environment variable APP_UNIQUE_SCHEMA points to a current unique schema.
So instead of typing
select * from my_unique_schema.my_table I want to set a current schema for sqlplus session in glogin.sql.
It would have been nice if I could have entered in glogon.sql the following line
alter session set current_schema=$APP_UNIQUE_SCHEMA;
BUT it does not work. sqlplus does not resolve the reference to an environment variable. I cannot figure out how to get the value of an environment variable in sqlplus.
I'm using forms 9i. Let's say I have a Block in the form B1. It has two items I1 and I2. I have a table called T1 that has a column say C1. The data in the only record in T1 is 'NAME_IN(''B1.I1'') = 1 OR NAME_IN(''B1.I2'') = 2'..In forms I need to execute the following at POST-QUERY trigger of the block:-
DECLARE VAR1 VARCHAR2(1000); BEGIN SELECT C1 INTO VAR1 FROM T1; [code]....
As you could see that the IF statement is wrong. But I get the condition (for IF condition) as a string value from some database table.
In order to install XE 11g I downloaded 'Oracle Software Packager and Installer, Release 2.2.0.16.0' as compressed jar file ouiosp220160.jar.I unjared it, got to folder win32-> setup.exe.When trying to run the file, I got the message:Java Runtime Environment was not found at binjavaw.exe , hence Oracle Universal Installer cannot be run.
