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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jun 14, 2010
have a link to install/configure webutil for use with Forms 11g?
View 2 Replies
View Related
Aug 3, 2012
how configure webutil in forms 10g. send me all the doc related to this.
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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