facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post

RMAN COLD BACKUP FOR RAC , HOW ?

Written By askMLabs on Thursday, August 26, 2010 | 6:05 AM

What is meant by COLD BACKUP? Is it possible to take COLD BACKUP with RMAN?

In the normal backup and recovery terms , COLD BACKUP is the backup taken when the database is completely down. Then how do we connect to database with RMAN when the database is down?
The RMAN differentiates between "inconsistent" and "consistent" backups on the basis of whether the database is OPEN or not during the Backup. It will not use the terms "COLD BACKUP" and "HOT BACKUP".

For consistance RMAN RAC backup :


  1. Shutdown all the instances in a cluster

  2. connect to any one node and execute the following script

$rman target / nocatalog
RMAN>
run{
startup mount;
allocate channel backup_disk1 type disk format '+FRA';
backup full database;
shutdown immediate;
release channel backup_disk1;
}



Now we have the RMAN cold backup. Does it include online redo logs. How do we restore the RMAN backup taken earlier. Can we directly restore and open the database.

No.

RMAN will not backup online redologs. So when you restore the database from the backup taken above , you cant directly open the database as you dont have the online redologs. You have to open the database with reset logs.

This article is an example to backup RAC database with ASM. When the RAC with ASM Storage provides the high availability , why should we think of cold backup !!!!!!. This articles is only for concepts purpose and the real time RAC backups with RMAN  are completely different.

Hope it helps ....

--SRI

Tracing DBCA

Written By askMLabs on Wednesday, August 25, 2010 | 9:05 AM

The present article discusses the tracing of DBCA. Sometimes you may be landing into issues when using the DBCA and you may not have any clue for the  error. Enabling the tracing for DBCA will give more detailed output showing some clue for the issue.

Till release 10g , we have to manually enable tracing ...

Modify the jre command at the end of the  file : $ORACLE_HOME/bin/dbca  as ...

$JRE_DIR/bin/jre -DORACLE_HOME=$OH -DJDBC_PROTOCOL=thin -mx64m -DTRACING.ENABLED=true -DTRACING.LEVEL=2 -classpath $CLASSPATH oracle.sysman.assistants.dbca.Dbca $ARGUMENTS

But from Release 10g onwards , this tracing is automatically enabled.

We can find the tracing file at

$ORACLE_HOME/cfgtoollogs/dbca/trace.log   ==> in 10g

$ORACLE_BASE/cfgtoollogs/dbca//trace.log  ==> in 11g

Hope it helps

--SRI

$ORACLE_HOME/bin/db

oracle exp/imp and expdp/impdp

Written By askMLabs on Tuesday, August 24, 2010 | 9:14 AM

If you dont know how to use the exact options of the exp/imp and expdp/impdp utilities for your requirement, here is a front end tool to use

http://www.alderprogs.com/

It is a licenced software but you can install the trial version to test.

Hope it helps

--SRI

How to add quick launch toolbar in windows 7

Written By askMLabs on Monday, August 23, 2010 | 11:45 AM

By default Quick Launch is disabled in Windows 7. This will show you how to enable or disable Quick Launch on the taskbar in Windows 7 as a toolbar with small or large icons.

Pls follow the below link to have the step by step procedure to enable quick launch tool bar in windows 7.

http://www.howtogeek.com/howto/windows-7/add-the-quick-launch-bar-to-the-taskbar-in-windows-7/

Hope it helps

SRI

exporting objects to different schema with different tablespace

Written By askMLabs on Sunday, August 22, 2010 | 8:58 AM

Assume that we have some objects in a schema TEST1 with default tablespace TS1. Suppose if there is an application running on this database which requires these objects to be in two different schemas.
Say the second schema is TEST2 with default tablespace TS2.
Now we have to move some objects from TEST1 schema to TEST2 schema.

Consider the following syntax ..
SQL>alter table TEST1.TABLE1 rename to TEST2.TABLE1; ==> Syntax error.
sql>alter table TEST1.TABLE1 move tablespace TS2; ==> This moves the object to tablespace TS2, but still in schema TEST1.

Does export and import work ?   Lets try ....
$exp system/manager file=TABLE1.dmp tables=TEST1.TABLE1 log=exp_TABLE1.log
$imp system/manager file=TABLE1.dmp fromuser=TEST1 touser=TEST2 tables=TABLE1 log=imp_TABLE1.log

This should actually move the table TABLE1 from TEST1 to TEST2.
But if you observe the table TABLE1 after the import it is in schema TEST2 which is ok but tablespace is still TS1. WHY ?
The user TEST2 has default tablespace TS2, so when we import the table it should be created in TS2 tablespace. Why is it created in TS1?

Then what is the solution to move an object to TEST2 with tablespace TS2. !!!!!!!

Follow the following steps to move the objects to different schema with different tablespace.
SQL>alter user TEST2 quota 0 on TS1 quota unlimited on TS2;
SQL>revoke unlimited tablespace from TEST2;

$imp system/manager file=TABLE1.dmp fromuser=TEST1 touser=TEST2 tables=TABLE1 log=imp_TABLE1.log

Then verify the object schema and tablespace. It should be TEST2 with TS2.

Hope it helps ....

-- SRI


Exporting/Importing table partitions

Written By askMLabs on Friday, August 20, 2010 | 5:03 PM

This article shows the table partition management and also how to export and import the table partitions.
SQL> CREATE TABLE "SH"."PART_TABLE"
2     (       "PARAMETER" VARCHAR2(32) NOT NULL ENABLE,
3     "TIMESTAMP" NUMBER NOT NULL ENABLE,
4     "VALUESUM" NUMBER NOT NULL ENABLE,
5     "VALUECOUNT" NUMBER DEFAULT 1 NOT NULL ENABLE,
6      CONSTRAINT "PK_INDEX01" PRIMARY KEY ("PARAMETER", "TIMESTAMP") ENABLE,
7      CONSTRAINT "VALUECOUNT_POS" CHECK ( valuecount > 0 ) ENABLE
8     ) ORGANIZATION INDEX COMPRESS 1 PCTFREE 10 INITRANS 2 MAXTRANS 255  LOGGING
9    TABLESPACE "TS1"
10    STORAGE(
11    BUFFER_POOL DEFAULT)
12   PCTTHRESHOLD 50
13    PARTITION BY RANGE ("TIMESTAMP")
14   (PARTITION "PART_1"  VALUES LESS THAN (1277596800001)
15    PCTFREE 10 INITRANS 2 MAXTRANS 255
16    STORAGE(INITIAL 50331648 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
17    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
18    TABLESPACE "TS1" );

Table created.

SQL> select segment_name,tablespace_name from dba_segments where segment_name='PART_TABLE';

no rows selected

SQL> select partition_name,tablespace_name from dba_segments where segment_name='PART_TABLE';

no rows selected

SQL> select table_name,tablespace_name from dba_tables where table_name='PART_TABLE';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
PART_TABLE

SQL> select partition_name,tablespace_name from dba_tab_partitions where partition_name='PART_1';

PARTITION_NAME                 TABLESPACE_NAME
------------------------------ ------------------------------
PART_1

SQL> select index_name,partition_name,subpartition_count,status from dba_ind_partitions where tablespace_name='TS1';

INDEX_NAME                     PARTITION_NAME                 SUBPARTITION_COUNT STATUS
------------------------------ ------------------------------ ------------------ --------
PK_INDEX01                     PART_1                               0 USABLE

SQL> select owner,table_name,index_name,status from dba_indexes where index_name='PK_INDEX01';

OWNER      TABLE_NAME                     INDEX_NAME              STATUS
---------- ------------------------------ ------------------------------
SH         PART_TABLE                     PK_INDEX01              N/A

SQL> SELECT PARTITION_NAME FROM DBA_TAB_PARTITIONS WHERE TABLE_NAME='PART_TABLE' and PARTITION_NAME like 'PART_%' ORDER BY PARTITION_NAME;

PARTITION_NAME
------------------------------
PART_1

SQL> select segment_type,count(1) from dba_segments where tablespace_name='TS1' group by segment_type;

SEGMENT_TYSH         COUNT(1)
------------------ ----------
INDEX PARTITION             1

SQL> ALTER TABLE SH.PART_TABLE ADD
2    PARTITION "PART_2"  VALUES LESS THAN (1282910400001)
3     PCTFREE 10 INITRANS 2 MAXTRANS 255
4     STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
5     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
6    TABLESPACE "TS1" ;

Table altered.

SQL> SELECT PARTITION_NAME FROM DBA_TAB_PARTITIONS WHERE TABLE_NAME='PART_TABLE' and PARTITION_NAME like 'PART_%' ORDER BY PARTITION_NAME;

PARTITION_NAME
------------------------------
PART_1
PART_2

SQL> select segment_type,count(1) from dba_segments where tablespace_name='TS1' group by segment_type;

SEGMENT_TYSH         COUNT(1)
------------------ ----------
INDEX PARTITION             2

Insert some  data

SQL> select count(1) from SH.PART_TABLE;

COUNT(1)
----------
700257971

$exp SH/SH@RACDB file=part3.dmp log=part3_exp.log tables=SH.PART_TABLE:PART_2 feedback=10000 statistics=none constraints=n

Export: Release 10.2.0.4.0 - Production on Thu Aug 26 07:27:56 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: constraints on tables will not be exported


About to export sSHcified tables via Conventional Path ...
. . exporting table PART_TABLE
. . exporting partition              PART_2
...........................................................................
.....
809310 rows exported
Export terminated successfully without warnings.


SQL> alter table SH.PART_TABLE drop partition PART_2;

Table altered.

SQL> SELECT PARTITION_NAME FROM DBA_TAB_PARTITIONS WHERE TABLE_NAME='PART_TABLE' and PARTITION_NAME like 'PART_%' ORDER BY PARTITION_NAME;

PARTITION_NAME
------------------------------
PART_1

SQL> select count(1) from SH.PART_TABLE;

COUNT(1)
----------
699448661

SQL>    alter table SH.PART_TABLE add
2    PARTITION "PART_2"  VALUES LESS THAN (1282910400001)
3     PCTFREE 10 INITRANS 2 MAXTRANS 255
4     STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
5     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
6    TABLESPACE "TS1" ;

Table altered.

SQL> SELECT PARTITION_NAME FROM DBA_TAB_PARTITIONS WHERE TABLE_NAME='PART_TABLE' and PARTITION_NAME like 'PART_%' ORDER BY PARTITION_NAME;

PARTITION_NAME
------------------------------
PART_1
PART_2

SQL> select count(1) from SH.PART_TABLE;

COUNT(1)
----------
699448661

$ imp SH/SH@RACDB file=part3.dmp log=part3_imp.log fromuser=SH buffer=200000 recordlength=6400 tables=PART_TABLE:PART_2 feedback=10000 ignore=y constraints=n statistics=none

Export: Release 10.2.0.4.0 - Production on Thu Aug 26 07:27:56 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by SH, not by you

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing SH's objects into SH
. . importing partition "PART_TABLE":"PART_2"
...........................................................................
.....
809310 rows imported
Import terminated successfully without warnings.


SQL> select count(1) from SH.PART_TABLE;

COUNT(1)
----------
700257971


Hope it helps ...
--SRI

Issues and solutions for 10g RAC Database creation on 11gR2 grid infra

Written By askMLabs on Thursday, August 19, 2010 | 5:58 PM

Issues and solutions for

10g RAC Database creation on 11gR2 grid infra:



Issue 1 :

Oracle Single instance creation screen appears instead of RAC database creation screen.



Solution : Note ID 1073926.1

Issue 2 :

From the above note 1073926.1, it is also required to apply the patch 8288940 to fix 11g ASM Incompatibility for 10g


Issue 3 :

While creating the database using dbca , getting the following error.
"Encountered file error when copying listeners from home=/o001/home/11.2.0/grid/"





Solution : Note ID : 762304.1

Issue 4 :

Invalid specification for system parameter "REMOTE_LISTENER" …..



Solution :

Modified the remote_listener init parameter to point to "<scan-name>:1521"

Issue 5:



Found the following messages in alert log file
ORA-15025: could not open disk '/dev/oracleasm/disks/DATAVOL1'

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 2

Fri Aug 20 09:41:54 2010

SUCCESS: diskgroup RACDB_DATA was mounted

SUCCESS: diskgroup RACDB_DATA was dismounted

Fri Aug 20 09:41:54 2010

Errors in file /o001/home/oracle/admin/rac10g/udump/rac10g1_ora_14539.trc:

ORA-00200: control file could not be created

ORA-00202: control file: '+RACDB_DATA/rac10g/control01.ctl'

ORA-15012: ASM file 'rac10g/control01.ctl' does not exist

ORA-17502: ksfdcre:5 Failed to create file +RACDB_DATA/rac10g/control01.ctl

ORA-15081: failed to submit an I/O operation to a disk

Work Around :

SQL> select name,state from v$asm_diskgroup;

NAME             STATE

------------------------------ -----------

CRS             MOUNTED

FRA             MOUNTED

RACDB_DATA MOUNTED

SQL> select name,path from v$asm_disk;

NAME PATH

--------------------------------------------------------------------------------

CRS_0000 /dev/oracleasm/disks/CRSVOL1

FRA_0000 /dev/oracleasm/disks/FRAVOL1

RACDB_DATA_0000 /dev/oracleasm/disks/DATAVOL1

SQL> !

[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/DATAVOL1

brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:53 /dev/oracleasm/disks/DATAVOL1

[grid@rac1 disks]$ id oracle

uid=1659(oracle) gid=501(dba) groups=501(dba),552(admin2),503(oper),1000(oinstall),1201(asmdba)

[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*

brw-rw---- 1 grid asmadmin 8, 48 Aug 20 11:54 /dev/oracleasm/disks/FRAVOL1

brw-rw---- 1 grid asmadmin 8, 32 Aug 20 11:54 /dev/oracleasm/disks/DATAVOL1

brw-rw---- 1 grid asmadmin 8, 64 Aug 20 11:54 /dev/oracleasm/disks/CRSVOL1

[grid@rac1 disks]$ chmod 777 /dev/oracleasm/disks/*

[grid@rac1 disks]$ ls -lrt /dev/oracleasm/disks/*

brwxrwxrwx 1 grid asmadmin 8, 48 Aug 20 11:55 /dev/oracleasm/disks/FRAVOL1

brwxrwxrwx 1 grid asmadmin 8, 32 Aug 20 11:55 /dev/oracleasm/disks/DATAVOL1

brwxrwxrwx 1 grid asmadmin 8, 64 Aug 20 11:55 /dev/oracleasm/disks/CRSVOL1

[grid@rac1 disks]$

Issue 6 :

PRKP-1001 : Error starting the instance rac10g2 on node rac2

CRS-0215 Could not start resource 'ora.rac10g.rac10g2.inst'

This error can be ignored. The instance is started automatically.

RAC SSH setup / User equivalence

Written By askMLabs on Saturday, August 14, 2010 | 5:20 PM

During the installation of Oracle RAC , OUI needs to copy files to and execute programs on the other nodes in the cluster. In order to allow OUI to do that, you must configure SSH to allow user equivalence. Establishing user equivalence with SSH provides a secure means of copying files and executing programs on other nodes in the cluster without requiring password prompts.

The first step is to generate public and private keys for SSH. There are two versions of the SSH protocol; version 1 uses RSA and version 2 uses DSA, so we will create both types of keys to ensure that SSH can use either version. The ssh-keygen program will generate public and private keys of either type depending upon the parameters passed to it.

From ORACLE DATABASE 11gR2, this process is automated in OUI itself. You can find the script "sshUserSetup.sh" in the 11gR2 grid media.

You can use this script for ssh setup in releases prior to 11gR2 RAC.
[oracle@rac1 ~]$ cd /tmp/askm/grid/sshsetup/
[oracle@rac1 sshsetup]$ ./sshUserSetup.sh -user oracle -hosts "rac1 rac2"

The output of this script is also logged into /tmp/sshUserSetup_2010-08-22-09-36-53.log
Hosts are rac1 rac2
user is oracle
Platform:- Linux
Checking if the remote hosts are reachable
PING rac1.localdomain (192.168.1.109) 56(84) bytes of data.
64 bytes from rac1.localdomain (192.168.1.109): icmp_seq=1 ttl=64 time=0.164 ms
64 bytes from rac1.localdomain (192.168.1.109): icmp_seq=2 ttl=64 time=0.051 ms
64 bytes from rac1.localdomain (192.168.1.109): icmp_seq=3 ttl=64 time=0.047 ms
64 bytes from rac1.localdomain (192.168.1.109): icmp_seq=4 ttl=64 time=0.045 ms
64 bytes from rac1.localdomain (192.168.1.109): icmp_seq=5 ttl=64 time=0.049 ms

--- rac1.localdomain ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4002ms
rtt min/avg/max/mdev = 0.045/0.071/0.164/0.046 ms
PING rac2.localdomain (192.168.1.110) 56(84) bytes of data.
64 bytes from rac2.localdomain (192.168.1.110): icmp_seq=1 ttl=64 time=0.442 ms
64 bytes from rac2.localdomain (192.168.1.110): icmp_seq=2 ttl=64 time=0.475 ms
64 bytes from rac2.localdomain (192.168.1.110): icmp_seq=3 ttl=64 time=0.339 ms
64 bytes from rac2.localdomain (192.168.1.110): icmp_seq=4 ttl=64 time=0.380 ms
64 bytes from rac2.localdomain (192.168.1.110): icmp_seq=5 ttl=64 time=0.283 ms

--- rac2.localdomain ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4004ms
rtt min/avg/max/mdev = 0.283/0.383/0.475/0.073 ms
Remote host reachability check succeeded.
The following hosts are reachable: rac1 rac2.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
The script will setup SSH connectivity from the host rac1.localdomain to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host rac1.localdomain
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes

The user chose yes
Please specify if you want to specify a passphrase for the private key this script will create for the local host. Passphrase is used to encrypt the private key and makes SSH much more secure. Type 'yes' or 'no' and then press enter. In case you press 'yes', you would need to enter the passphrase whenever the script executes ssh or scp.
The estimated number of times the user would be prompted for a passphrase is 4. In addition, if the private-public files are also newly created, the user would have to specify the passphrase on one additional occasion.
Enter 'yes' or 'no'.
yes

The user chose yes
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host
Enter passphrase (empty for no passphrase):  <ENTER>
Enter same passphrase again:  <ENTER>
Generating public/private rsa key pair.
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
06:74:f9:b0:91:8a:a3:19:76:aa:b0:e3:2c:ff:e4:8b oracle@rac1.localdomain
Creating .ssh directory and setting permissions on remote host rac1
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host rac1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host rac1.
Warning: Permanently added 'rac1,192.168.1.109' (RSA) to the list of known hosts.
oracle@rac1's password:      <ENTER RAC1 ORACLE USER PASSWORD>
Done with creating .ssh directory and setting permissions on remote host rac1.
Creating .ssh directory and setting permissions on remote host rac2
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host rac2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host rac2.
Warning: Permanently added 'rac2,192.168.1.110' (RSA) to the list of known hosts.
oracle@rac2's password:      <ENTER RAC2 ORACLE USER PASSWORD>
Done with creating .ssh directory and setting permissions on remote host rac2.
Copying local host public key to the remote host rac1
The user may be prompted for a password or passphrase here since the script would be using SCP for host rac1.
oracle@rac1's password:      <ENTER RAC1 ORACLE USER PASSWORD>
Done copying local host public key to the remote host rac1
Copying local host public key to the remote host rac2
The user may be prompted for a password or passphrase here since the script would be using SCP for host rac2.
oracle@rac2's password:      <ENTER RAC2 ORACLE USER PASSWORD>
Done copying local host public key to the remote host rac2
The script will run SSH on the remote machine rac1. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
The script will run SSH on the remote machine rac2. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--rac1:--
Running /usr/bin/ssh -x -l oracle rac1 date to verify SSH connectivity has been setup from local host to rac1.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine rac1. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Sun Aug 22 09:39:35 IST 2010
------------------------------------------------------------------------
--rac2:--
Running /usr/bin/ssh -x -l oracle rac2 date to verify SSH connectivity has been setup from local host to rac2.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
The script will run SSH on the remote machine rac2. The user may be prompted for a passphrase here in case the private key has been encrypted with a passphrase.
Sun Aug 22 09:39:36 IST 2010
------------------------------------------------------------------------
SSH verification complete.
[oracle@rac1 sshsetup]$


Note : Password only 4 times
Note : Enter password carefully

Verification :
[oracle@rac1 sshsetup]$ ssh rac1 date;hostname
Sun Aug 14 09:41:33 IST 2010
rac1.localdomain
[oracle@rac1 sshsetup]$ ssh rac2 date;hostname
Sun Aug 14 09:41:39 IST 2010
rac1.localdomain
[oracle@rac1 sshsetup]$

1. ssh both public hostname
2. ssh both private hostname
3. ssh both public ip address
4. ssh both Private ip address

Screen shots showing how this is implemented in 11gR2 RAC ....





Hope it helps ...

--SRI
 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger