It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.
I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,
I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.
Node 1 -------- [oracle@node1 ~]$ id uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) [oracle@node1 ~]$ date Thu Dec 30 05:14:10 IST 2010 [oracle@node1 ~]$ ------------ Node2 ---------- [oracle@node2 ~]$ id uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba) [oracle@node2 ~]$ date Thu Dec 30 05:15:32 IST 2010 [oracle@node2 ~]$ --------- OS ---------- [oracle@node2 .ssh]$ cat /etc/redhat-release CentOS release 5.4 (Final) [oracle@node2 .ssh]$ date --------- Host for both node -------- [oracle@node2 .ssh]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost # Public 10.1.1.10 node1 10.1.1.11 node2 #Private 20.1.1.10 node1-priv 20.1.1.11 node2-priv #Virtual 10.1.1.21 node1-vip 10.1.1.22 node2-vip ------------------------ I am using the command to configure SSH provide in the link
I need to configure a watchdog (or any other) utility which will constantly monitor database health. And if something goes wrong with the database, the utility should restart the DB instance.
I have 9i RDBMS Software and RHEL 4. I want to install a Oracle Names server. I install RDBMS.But Where I run netmgr and want to configure and start Oname server it says.
$ORACLE_HOME/bin/names file not exists.
How Can I configure OracleNames Server using Oracle 9i On Linux.
I have a SAN Storage device of 8TB size . I am new to rac setup ,i dont know how to configure the SAN device for RAC SETUP on ASM..how to configure the SAN device for RAC setup on ASM
How many disks we need to have? which and sholud be on ASM ? how to impliment raid10 for database file disk and raid5 for arhcive log files
i am trying to install 2 node RAC on Oracle VMs. Before the installation during the -preinst check there were few issues which were resolved (ex user equivalence). After that during the installation process of the Grid it failed at step "Configure Oracle Grid Infrastructure for a cluster". After it failed at this step, subsequent steps too failed which I asked OUI to ignore and then I ran both the post installation scripts. And then ran post crsinst which failed. Pasting below the output of the root.sh script, post crsinst and other checks.
************************************* [root@bsfrac01 grid]# sh root.sh Running Oracle 11g root.sh script...
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created.Finished running generic part of root.sh script.Now product-specific root actions will be performed.
2011-02-13 00:11:55: Parsing the host name 2011-02-13 00:11:55: Checking for super user privileges 2011-02-13 00:11:55: User has super user privileges
we don't have system or storage admin available..I have to create the development environment. I have 2 Dell 2950 Power Edgde Servers and 500 GB Buffalo NAS with Windows 2K3 X64 EE, tell me whether I can install Oracle RAC with this kit.
If yes , how can I configure shared storage and present it to OS so that both nodes can see it.
We have to configure Dataguard for our 24x7 critical banking 2 Node RAC database(10.2.0.4). Before proceeding with the configuration we have to make sure what steps we should follow to have minimum or no downtime.
1) Document covering DG setup in RAC environment. 2) We have to perform switchover as well so need its steps too. Either the normal switchover steps would be used or have to stop/start rac services as well.
In my production ENV there is two node RAC database is running , and on both machine RAM size is (35GB on node1,41GB on Node2) and other configuration is like below.
I have two node RAC database running on linux machine (Oracle10G SE), our requirnment is to install new oracle binaries for Oracle10G EE on diffrent home location.after install Oracle10G EE binaries on new oracle home , i want to point our existing database to new Oracle10G EE home to adotp a features of Oracle10G EE features.
But at the same time i dont want to deinstall our Oracle10G SE binaries.So it is possible to rollback our process to point our database back to Oracle10G SE from Oracle10G EE in case anything going wrong.
We are configuring NAS device on linux for RAC installation.
ISSUE: I had mounted NAS device to Linux server.As root user I can create directory but cannot change owner of cifs mount.It say permission denied.When I try to change permission it doesn't work.The mount point show the uid and gid as 33 and permissions drwxr-xr-x
I would like get more details about single node RAC.. What is single Node RAC?..
1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ... 2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...
is there any advantage using single node rac(other than online upgrade to full RAC).
working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.
i install oracle 10g on linux on perform the following step but my database is not auto start with the machine
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.
The scripts are, $ORACLE_HOME/bin/dbstart $ORACLE_HOME/bin/dbshut
Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.
-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.
In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.
If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.
Automate Startup/Shutdown of Oracle Database on Linux
Step 01: Be sure that oratab file is correct and complete.
Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.
Database entries in the oratab file have the following format:
$ORACLE_SID:$ORACLE_HOME:Y Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.
If in my database there is two database named arju and arjudup then my oratab file will contain the entry like, arju:/var/opt/oracle/product/10.2.0/db_1:Y arjudup:/var/opt/oracle/product/10.2.0/db_1:Y where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.
Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.
a) Login as root. b) Change directories to /etc/init.d c) Create a file called dbora and chmod it to 750.
# touch dbora # chmod 750 dbora d)Edit the dbora file and make the contents of it like below.
We wish to configure an Oracle 11g RAC with ASM setup for the internal employee training purpose. The requirement is as follows
1. Operating system Linux, Software Oracle 11g Release 2 2. Need to build total 5 individual clusters. 3. Each cluster with 2 Node 4. Need to configure ASM as a shared storage with real hardware. (No virtualization, Openfiler, NFS) 5. Need to configure RAC database.
provide me the hardware details for configuring Shared storage. Is there any specific Storage which we can use to configure ASM as a storage.
I need to configure character set for my database. I have 2 options:
AL16UTF16 - require 2 bytes per character (fixed length) UTF8 - character length - 1 until 4 bytes. (variable length)
until here ok...
The AL16UTF16 certainly will occupy more space than UTF8. So my question is, When would I need use AL16UTF16 character set mode?
I hear one time, when a database write many values with the same length. it does it in the same HD cylinder. So the HD arm could with a single movement read all the fields in cylinder completely. Improving the read/write performance.
I've been trying to rebuild our Oracle 11g server. I started off by wiping Oracle completely and kicked off the install again. The install goes smoothly, but does not create the Listener. I've been trying to use netca to create it myself. The below is the output from netca:
Listner Control complete. Listener start failed.
Looking in the netca trace file, I see the following error (note I'm only including the error with a few lines before):
[AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:91] NativeResult: The String obtained is1|SUCCESSFUL [AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:99] The status string is: 1 [AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [NativeResult.<init>:112] The result string is: SUCCESSFUL 1 [AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:787] _WS_: deleting service2 OracleRemExecService on AUSYD5756 ignoreNotExist = true [AWT-EventQueue-0] [ 2013-08-31 22:55:08.337 EST ] [WindowsSystem.deleteService:793] _WS_ deleteService2: node AUSYD5756 Service OracleRemExecService result: 0|Access is denied. [code]....
The OracleRemExecService services does not exist. I've tried re-installing the whole instance a number of times but each time I hit this error.
Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U' ; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U'; new RMAN configuration parameters are successfully stored starting full resync of recovery catalog full resync complete
Here is my rman script
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; run { crosscheck archivelog all;
[Code]....
instead its backups but to my ORACLE_HOME\database directory..
configure correctly my application, Oracle is version 11R1
My physical configuration is :
Site 1 (main building) database on cluster : server1, server2 database : BASE1 available
Site2 (Backup Site) database on cluster : server3, server4 database : DGBASE1 not available for users (dataguard)
I want to acces BASE1 first in load balancing server1,2 (normal usage) and DGBASE1 in load balancing server3,4 in case of failover after 5 retries of 10 secondes (in case of main buiding out of order, DGBASE1 will be available for users)
My trouble is that with this configuration, access it randomly BASE1 or DGBASE1 but DGBASE1 is not available for users then I have failure
What could be the right configuration to obtain BASE1 first in load balancing (normal usage) and DGBASE1 in load balancing in case of failover of the BASE1 after 5 retries of 10 secondes ?
I have created a batch for silent DB Creation through DBCA. I want to add a script to also create the Network Service after. I was told it can be done only with Response File. Is a response file a script also that can be executed after the DBCA scripts?Where can I find a manual with the available commands so I can produce what I need? On the internet I find only examples for Silent DB instalation. EDITOS is Windows 7 Oracle 11.2.0.1 I want to create the Network Service that will add these lines to the tsnames.ora.
on both the client and the server.How can i do it automatically through a batch script, so to add it to DBCA scripts after creation? I was told once in atopic that it could be done through a response file.
I've been asked to configure RMAN on an existing Oracle 11g R1 database running on Windows Server 2003 (32-bit) & when I connect using RMAN client to the database instance, I'm getting the following error setting the Fast Recovery Area and don't know why:
C:>rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Mon Jun 25 14:39:45 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: ORCL11G (DBID=825621007)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
database closed database dismounted Oracle instance shut down [code]....
RMAN-01007: at line 1 column 1 file: standard inputAccording to Oracle documentation, I appear to be entering the correct command sequence but it's not working for some reason..
We are in project design phase and following is the hardware setup:
Database (2 node RAC)-Solaris 10 Application server server (2 server) -Solaris 10 Web server (2 server for Failover)= RHEL
For DR Database (1 node)-Solaris 10
need to know 1.What are the best practice to implement and to configure DR as Non-RAC physical standby for RAC database server. 2.What are implication if we go for single node except failover node unavailability for DR. 3.What are the steps of Switchover in this case. 4.What's the recommended backup solution for 8-10 Terabyte database