Clusterware :: Oracle Installation On Windows Operating System?
Jun 14, 2012install oracle clusterware on Windows Operating system
View 4 Replies
ADVERTISEMENT
RAC/ASM Clusterware Installation :: Adding New OCFS Disk To Oracle Cluster On Windows
Oct 17, 2013We have 2 servers running Oracle 11gR2 Window server 2008 64 bit RAC. Today I add new shared disk visible from both servers. All our data placed on ASM partitions, but we need Windows volume for exchanging some data between servers & users;Actions:then i have prepare disk on shared storage from 1st node, run diskmfmt.msc & rescan disks when windows recognizes new hdd, initialize it.create an Extended partition & Logical drive & Assign drive letter. from another nodes, make sure no drive letter is assigned.
Sometimes Windows automatically assign drive letter. If drive letter is assigned, right click & Change drive letter & Remove. from 1st node, format this logical drive using ocfsFormat.exe after execute below scripts i have face some issues
E:app11.2.0gridcfs>ocfsformat /m P: /c 1024 /v DATA /f /d /aReg Get Cluster Name(): Reg Query ValueEx for CFS_CLUSTER_NAME failed with error 203
This indicates that the Cluster Name has not been configured on this node for OCFSThe volume formatted in this condition will be seen by all nodes running OCFS.
RAC/ASM Clusterware Installation :: File System Storage Option On 10g?
Sep 30, 2013We have two database servers(10g with OEL 5) to be clustered and two visible disk groups to each of those nodes. So question is can we choose only one disk group as a shared storage leaving the rest one as the redundant copy during database a creation window while installing the database. Because some of us argue that oracle database has a built-in capability to decide on what level of RAID we store our data.
View 7 Replies View RelatedRAC/ASM Clusterware Installation :: Where To Take GI Patch Set Update For Windows
Sep 14, 2012Where to take and how to find the latest versions of patches GI Patch Set Update for Windows?
For a DB there is article "*ALERT: Oracle 11g Release 2 (11.2) Support Status and Alerts [ID 880782.1]*". I am signed on notification messages by mail. When article *880782.1* changes, to me the notification message comes. From *880782.1* it is possible to pass in article "*Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms [ID 161549.1]*". Here there are links to the latest versions of patches.
The latest versions for GI Patch Set Update it is possible to look in article "*Oracle Recommended Patches - Oracle Database [ID 756671.1]*" but here is not present Windows platform.
1). Where to take and how to find the latest versions of patches GI Patch Set Update for Windows?
2). Whether It is possible GI Patch Set Update for Windows to find by means of searching on tab MOS "*Patches & Updates*"?
RAC/ASM Clusterware Installation :: Shared Storage In Windows
Aug 6, 2012I am trying to install Oracle RAC 11g on Oracle Linux via Virtual Box. My host server is windows. How to create shared storage on windows?
View 5 Replies View RelatedForms :: How To Know Operating System Current Path In Oracle 10g Forms
Apr 19, 2011How to Know Operating System Current Path in oracle 10g forms ?
View 4 Replies View RelatedWindows :: Installation Process Trying To Create Database On System
Dec 7, 2010I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.
View 1 Replies View RelatedHow To Get Free Space On Operating System Drive
Nov 5, 2013is it possible to get information about free space on drive/path for example with some DBMS_*, UTL_* package or with stored function based on Java
(e.g. CREATE OR REPLACE FUNCTION GetFreeSpace(driveLetter IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'DiskSpace.getFreeBytes(java.lang.String) return java.lang.String') but for JDK 1.3
RAC/ASM Clusterware Installation :: Oracle RAC Installation With Guest OS OracleLinux6 On Virtualbox / Mac OS
Jun 7, 2013I am trying to install Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox/Mac OS.But getting problem to set network & ip setting and yum is not able to reach oracle repository.
if anyone tried installing Oracle RAC installation w/ guest OS OracleLinux6 on Virtualbox on intel based Mac OS.
Host Operating System Experiencing Significant Paging
Feb 1, 2013I"Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host."
My database run on Windows Server 2008 R2 and have 12GB of physical RAM.
Oracle version is 10.2.0.4.0 and my sga and pga are:
sga_max_size 4000M
sga_target 3904M
pga 1200M
I try to find out something about this issue and read many blogs but unfortunately I didnt find anything which worked. Should this have something to do with the fact that on the server we have oracle database and terminal server with 30-40 users?
RAC/ASM Clusterware Installation :: ORA-03114 / Not Connected To ORACLE Error With Oracle DB Installation
Dec 3, 2012I am getting "ORA-03114: not connected to ORACLE" while installing "Oracle Database 11GR2" on "Oracle RAC 11R2" cluster setup. I am getting this error at the time of "Oracle Database Configuration Assistant" configuration reaches till 39% on HP-UX 11.31 IA64 platform.
View 25 Replies View RelatedRAC/ASM Clusterware Installation :: Oracle 11GR2 Rac Installation In Vmware
Aug 28, 2013I am installing RAC 11GR2 in VMWARE on OEL 6.3. Everything went smooth but when i tried to configure ASM , I get below messages.
[oracle@RAC1 ~]$ /etc/init.d/oracleasm configure-bash: /etc/init.d/oracleasm: No such file or directory.
Server Administration :: Unable To Claim Space For Operating System?
Sep 15, 2012We are in the process of gaining some space in our database. We identified a tablespace that occupied around 400GB of space. The datas are required for us. Hence, we truncated (with drop storage) the tables, gathered statistics and shrinked the tables. After doing that we found the datafile occupied around 32GB of space. We tried to resize it to 5 GB and we got "ORA-03297: file contains used data beyond requested RESIZE value". We could see that size in dba_free_space against that tablespace. We would like to give back everything to OS.
We also tried exporting the tablespace without rows, dropped the tablespace and re-created and imported again. But the datafile grows to around 32G and we are unable to resize it.
We are sure that the tablespace has only the table definitions without data. But we do not know why is it occupying around 32G of space and we could see that size in dba_free_space. We would like to give back everything to OS. How can we do that?
Forms :: Uploading Image Which Is Not Database Item From Operating System?
Sep 13, 2010uploading an image item which is not a database item from the operating system. I am using forms 10g on db 10g. My platform is windows Vista sp1.
I am trying to use
GO_ITEM('BEEEE');
Set_Custom_Property( 'SALGRADE.BEEEE',1, 'READIMGFILE', 'C:/users/ajayia/Desktop/Beeee.jpg' ) ;
But I just get a blank image on runform. I am using WHEN-NEW-BLOCK-INSTANCE trigger. I have tried it on when-new-form-instance, but also not working. The file am trying to upload is a JPG file format, but i cant find the file type in forms image item property. What can I change it to. Or how to i go about changing it.
Server Administration :: Remove Datafile From Operating System After Dropping Its Tablespace
Jul 26, 2012I want to remove a tablespace with it's datafile.
I've ran: DROP TABLESPACE x_tbs INCLUDING CONTENTS;
I've read(should have read it prior to action) [URL]tm
and I understand now that I should have stated "AND DATAFILES", However, too late now. the tablespace is removed, but the datafile x_tbs is still present in a folder of my OS.
Is it safe to manually remove it by deleting it from the operating system?
RAC/ASM Clusterware Installation :: Oracle Grid 11g R2 Installation
Jul 11, 2013I want to install Oracle Grid software 11g R2. What is the Latest Oracle Grid software 11g R2 version available?Is it 11.2.0.1 or 11.2.0.3?If it is 11.2.0.3, is it available in metalink download, because I see only 11.2.0.1 version in metalink download?
View 2 Replies View RelatedRAC/ASM Clusterware Installation :: Oracle Rac 11g Installation?
Sep 16, 2013Am planning to install oracle RAC 11g on linux server. Have doubt on installation of clusterware or grid infrastructure first .?I think grid infrastructure covers clusterware and ASM both and then oracle 11g software to be installed. But how to download grid insfrastructure software. Will it come with oracle 11g software..? or need to download it seperately.? Because when i try to download oracle RAC 11g which gives link to download the 11g software not grid.
View 4 Replies View RelatedRAC/ASM Clusterware Installation :: How To Configure DNS For Using Oracle GNS
Sep 24, 2012I need some professional article about how to configure DNS for using Oracle GNS with explanation.
I want to understand the role of DNS server for GNS.
I tried to search but what I found is not enough or they are not written with accuracy.
RAC/ASM Clusterware Installation :: Installing Oracle 11g With ASM?
Feb 28, 2013Here we are going to configure a new set up on new hardware :
clients requirements :
oracle 11g with ASM :
Number of instance = Single database
Platform = IBM AIX 6.1
RAC/ASM Clusterware Installation :: Oracle RAC 11G - Service Configuration?
Jul 9, 2012I have been reading a lot of documentation regarding oracle services and I have an ok understanding of how they work. However, I have a general question regarding configuring services using Oracle RAC. For instance, if I have a 2 node oracle 11GR2 RAC on a Linux Redhat server. I have an application that connects to a service I have created. I create the service as follows.
srvctl add service -d ORCL_RAC -s APP_SERVICE -r ORCL_RAC1,ORCL_RAC2
The tnsnames contains:
APP_OLTP =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
[code]...
My questions are as follows:
1) When I do a 'srvctl status service -d ORCL_RAC', should I see the service running on both nodes of the RAC? Or does it run only one node, then it will fail over to the other when needed?
2) If I have a RAC environment where I see two services created (RAC_SRV1 and RAC_SRV2). I see that RAC_SRV1 is only running on node1 and RAC_SRV2 is only running on node2. There are two applications sharing the same database, one application is using RAC_SRV1 and the other application is using RAC_SRV2. Am I correct in thinking that there is no failover available here? If node1 goes down, the application connecting to RAC_SRV1 will not be able to connect to node2 right?
3) In the case of the scenario in question 2 above, would it be best practise to simply create one service and have both applications connecting to the one service? Could I configure the one service to point connections from one application to node1 and connections from the other application to node2?
RAC/ASM Clusterware Installation :: Oracle Client Need To Upgrade
Mar 19, 2013We are in process of upgrading 10g (RAC) database to 11g(RAC), does the oracle client software must also be upgraded to 11g or the 10g client can be used for 11g database connectivity, since there are thousands of end users it is very difficult to upgrade all the clients.What is the best approach for client software?
View 3 Replies View RelatedRAC/ASM Clusterware Installation :: Oracle Grid Infrastructure
Jan 28, 2013I'm installing Oracle Grid 11gr2 on windows 2003 server. I installed successfully without domain controller. But when i try to install with Active Domain controller i faced following error
INS-20802 Grid Infrastructure Failed
Cause:Plugin failed
Installation :: Oracle 11G Database For 64 Bit Windows Installation Error
May 6, 2013I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).
View 10 Replies View RelatedRAC/ASM Clusterware Installation :: Adding New Oracle 11g R2 Rac Node On Solaris 10
Feb 18, 2013While adding new oracle 11g R2 rac node on solaris 10, getting below error.
Checking user equivalence...
PRVF-4007 : User equivalence check failed for user "grid"
Check failed on nodes:
sr3
[code]...
RAC/ASM Clusterware Installation :: Virtual IP For Oracle 11gr2 Cluster?
Sep 8, 2012I created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create
INS-40911: Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.
RAC/ASM Clusterware Installation :: Oracle RAC Private Connection Fail
Feb 7, 2013I would like to know that when the private network in oracle rac down, which is the preferable node in the cluster (cluster of 2 nodes) to takeover the cluster.
Can I set/get the failover policy to point to one node in the cluster?
Clusterware :: Active / Passive Installation For Oracle 11gR2
Nov 20, 2012I want to install an active / passive Oracle Configuration for our new 11gR2 system. We do not want to go full blown RAC as yet. We already have an 11gR2 instance that I plan to CLONE to the production server(s).
So. detail the steps that I need to follow .
i.e.
configure the 2 servers (VIFs/Interconnects)
Install GRID/CRS
Clone over the database (do I do this as a SINGLE NODE RAC?)
RAC/ASM Clusterware Installation :: CPU Usage On Oracle Cluster On AIX 6.1 With No Load
Aug 22, 2012After installing a 4 node cluster 11.2.0.3 with 16 CPU's (4 on each node) on IBM 795 with aix 6.1 each server is using 0.5 CPU with no user load on the system. Running SIHA on one server typically uses 0.05 CPU with no user load on the system.
View 5 Replies View RelatedRAC/ASM Clusterware Installation :: OLR Integrity Error During Oracle Database Install
Sep 12, 2012OS=Redhat 5
Oracle=11gr2
Grid=11gR2
I am trying to install Oracle Database 11gR2 database on Oracle Grid 11gR2. I successfully installed Grid without errors. However, when installing the database, I got an OLR Integrity error during the prerequisit Check
OLR Integrity - This test checks the integrity of OLR on the local node.
Expected Value : n/a
Actual Value : n/a
List of errors:
- Permissons of file
"/u01/app/oracle/product/11.2.0/grid/cdata/localhost/localhost.olr" did not match the expected value. [Expected = "0600"; Found = "0660"]
- Cause: Cause of Problem Not Available
- Action: User Action Not Available.
RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle
Mar 18, 2013In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?
They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?