RAC & Failsafe :: Unable To Configure SSH For RAC

Dec 30, 2010

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

[URL].......

View 7 Replies


ADVERTISEMENT

RAC & Failsafe :: Configure 10G On LINUX 5.0 Machine

Mar 9, 2011

provide me the online material or some links where i can follow the instructions step by step to configure 10G RAC on LINUX 5.0 machine.

I have 3 separate machines having Linux 5.0 . I want to do this for R&D purpose.

View 1 Replies View Related

RAC & Failsafe :: How To Configure SAN Device For Setup On ASM

Aug 6, 2012

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

View 7 Replies View Related

RAC & Failsafe :: Oracle Grid Infrastructure Configure Failed

Feb 15, 2011

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...

The following environment variables are set as:

ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2/grid

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

[code]....

View 1 Replies View Related

RAC & Failsafe :: Windows 2003 X 64 Using NAS - How To Configure Shared Storage

Aug 14, 2008

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.

View 6 Replies View Related

RAC & Failsafe :: Configure Oracle Dataguard For 2 Node Database

Oct 28, 2010

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.

View 7 Replies View Related

RMAN :: Unable To Configure FSA (11g R1 Windows)

Jun 26, 2012

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..

View 6 Replies View Related

RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?

Sep 13, 2012

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).

View 3 Replies View Related

RAC & Failsafe :: Unable To Communicate With CRS Services

Sep 13, 2010

i have a problem with DATABASE i have 2 nodes where all application on Node2 are tunning properly

[oracle@node2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora....de1.gsd application ONLINE ONLINE node1
ora....de1.ons application ONLINE ONLINE node1
ora....de1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
[code]....

View 3 Replies View Related

RAC & Failsafe :: Unable To Mount Ocfs2 Filesystem

Feb 7, 2011

I am configuring RAC with two nodes. I have mapped iscsi targets successfully. I am unable to mount the ocfs2 filesystem.

mount -t ocfs2 -o datavolume,nointr -L "oracrsfiles" /u02

When execute the above command, it displays the follwing error:

ocfs2_hb_ctl: Device name specified was not found while reading uuid
mount.ocfs2: Error when attempting to run /sbin/ocfs2_hb_ctl: "Operation not permitted"

View 2 Replies View Related

RAC & Failsafe :: ORA-29701 / Unable To Connect To Cluster Manager

Aug 8, 2011

when i'm creating ASM instance, i'm getting an error

Quote:ora-29701: unable to connect to cluster manager

for this there were some workaround given to start css.

i tried everything from /etc/init.d/init.cssd start/enable but nothing worked, then i tried with executing

localconfig delete
localconfig add====>it failed and recommended to go for reset option

when i executed localconfig reset i get this following error:

Quote:
[root@rac2 bin]# sh localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

[code]....

This is the same case when i used reset option.

View 3 Replies View Related

RAC & Failsafe :: RMAN Backup / Unable To Open Database

Aug 31, 2013

I tried to run the duplicate script after transferring new rman backup to standby. Even after transferring the backup, duplicate command and was unable to open the database.

View 1 Replies View Related

SQL & PL/SQL :: How To Configure RAC TO RAC Dataguard

Apr 27, 2012

i want to configure rac to rac dataguard 10g( primary is having 2 nodes and standby also 2 nodes).

oracle 10g/os linux5.

View 1 Replies View Related

Configure Oracle 11g RAC With ASM Setup?

Aug 26, 2013

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.

View 2 Replies View Related

How To Configure Charset Unicode

Aug 15, 2012

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.

View 2 Replies View Related

Forms :: Configure Webutil For Use With 11g?

Jun 14, 2010

have a link to install/configure webutil for use with Forms 11g?

View 2 Replies View Related

Forms :: Configure Webutil In 10g?

Aug 3, 2012

how configure webutil in forms 10g. send me all the doc related to this.

View 2 Replies View Related

Windows :: Cannot Configure Listener

Aug 31, 2013

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.

View 12 Replies View Related

Configure RMAN Backup To Disk?

May 27, 2011

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..

how to configure rman to backup to this location

View 1 Replies View Related

Configure Failover And Load Balancing?

Jun 28, 2013

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)

This is my actual setup :

(DESCRIPTION_LIST=(FAILOVER=ON)
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1234))

[Code]....

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 ?

View 1 Replies View Related

How To Configure Network Service By Script

Jul 5, 2013

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.

DBNAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wsName)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = dbname)
)
)

 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.

View 9 Replies View Related

RAC/ASM Clusterware Installation :: How To Configure DNS For Using Oracle GNS

Sep 24, 2012

I 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.

View 2 Replies View Related

Data Guard :: Configure Non-RAC DG For RAC Instance

Jun 13, 2011

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

View 1 Replies View Related

Configure CASCADED Physical Standby Server

Oct 29, 2010

I want to configure CASCADED Physcial Standby Server...Can i give the DB_FILE_NAME_CONVERT parameter in the primary DB Server as

*.DB_FILE_NAME_CONVERT=(
'C:\ORACLE\ORADATA\PRIMARY\','E:\ORACLE\ORADATA\STANDBY1\','E:\ORACLE\ORADATA\STANDBY2\',
'E:\ORACLE\ORADATA\PRIMARY\','B:\ORACLE\ORADATA\STANDBY1\','G:\ORACLE\ORADATA\STANDBY2\')

Or in the Standby1

*.DB_FILE_NAME_CONVERT=(
'E:\ORACLE\ORADATA\STANDBY1\','E:\ORACLE\ORADATA\STANDBY2\',
'B:\ORACLE\ORADATA\STANDBY1\','G:\ORACLE\ORADATA\STANDBY2\')

I searched in google but could not able to find anything in this regard.

View 1 Replies View Related

Enterprise Manager :: Can't Configure 11g R2 - Database Instance Not Available

Dec 12, 2010

I've checked ALL the parameters. It seems to be OK.The db is running and OK.But when I try to configure the EM I get the following error Says that the databse instance is not available.But, tnsping works ok, and I can connect as sys without problems. the DB is OK.

EMCA iniciado en 12-dic-2010 12:54:17
Asistente de Configuraci¾n EM, Versi¾n 11.2.0.0.2 Producci¾n
Copyright (c) 2003, 2005, Oracle. Todos los Derechos Reservados.
[code]....

View 3 Replies View Related

Networking And Gateways :: Configure Listener Using Net Manager

Oct 29, 2011

When i configure a listener using net manager,if found that the red text box in the picture can fill "the value of the global name " or "the value of the service_names".

View 7 Replies View Related

Enterprise Manager :: Configure Gmail ID For Notification?

Aug 25, 2010

how to configure gmail id in enterprise manager.

it has smtp address but still i'm getting a error message

smtp.gmail.com: Test failed with message: "Sending failed; nested exception is: javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS command first. t18sm1156251qco.20 "

View 1 Replies View Related

Performance Tuning :: How To Configure SGA_MAX_SIZE Parameter

Sep 24, 2013

The Memory tuning advisor has recommended that I increase the size of the SGA_TARGET to 5G, from my current size of 3G.

SQL> select * from v$sga_target_advice order by sga_size;

SGA_SIZE SGA_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR ESTD_PHYSICAL_READS
---------- --------------- ------------ ------------------- -------------------
1536 .5 1555141 1.667 7251211
2304 .75 949130 1.0174 4572127
3072 1 932898 1 2258733
3840 1.25 930939 .9979 2168835
4608 1.5 929819 .9967 2005529
5376 1.75 929166 .996 2005529
6144 2 928980 .9958 2005529

7 rows selected.However, the SGA_MAX_SIZE parameter is set to 3G, so when I do:

SQL> ALTER SYSTEM SET sga_target=5376M scope=both;
ALTER SYSTEM SET sga_target=5376M scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00823: Specified value of sga_target greater than sga_max_size

My database used spfile. I know that the procedure to change this is the following: Create pfile from spfile, shutdown immediate, change value in pfile, startup with pfile..However, the pfile does not have any parameter called max_sga_size. It only has the following:

<dbsid>.__sga_target=3221225472
*.sga_target=3221225472

how to change sga_max_size?

View 7 Replies View Related

Security :: How To Configure End User Open Only One Session

Jun 10, 2011

I want to configure this

my end user open only one session

means one session per one user only

View 8 Replies View Related

Enterprise Manager :: Configure OEM Dbconsole For Two Database?

Jan 20, 2010

I have two database in my system but when i open

[URL].....it always defaults for one database..in the service name also there is dbconsoledba1 written....my other database is dba2...do i need to create another service for dbconsole

View 1 Replies View Related







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