Error During 19c GI installation : [INS-44000] Passwordless SSH connectivity is not setup from the local node node1

 Cause - Installer requires that a minimum of 2 nodes remain for the Oracle Grid Infrastructure configuration to proceed.  

Action - Ensure that at least 2 nodes remain for the configuration to proceed, otherwise specify a single cluster node information.  

Additional Information:

 - [INS-44000] Passwordless SSH connectivity is not setup from the local node node1 to the following nodes: 

 [node1] 

 These nodes will be ignored and not participate in the configured Grid Infrastructure.   - 

 Action: Refer to the logs for more details or contact Oracle Support Services. 

 

Cause - Installer requires that a minimum of 2 nodes remain for the Oracle Grid Infrastructure configuration to proceed.  

Action - Ensure that at least 2 nodes remain for the configuration to proceed, otherwise specify a single cluster node information.  

Additional Information:

 - [INS-44000] Passwordless SSH connectivity is not setup from the local node node2 to the following nodes: 

 [node2] 

 These nodes will be ignored and not participate in the configured Grid Infrastructure.   - 

 Action: Refer to the logs for more details or contact Oracle Support Services. 

 

 

 Before installation, as root user: ( change the path if the location of your "scp" is not the same with below)

# Rename the original scp.

mv /usr/bin/scp /usr/bin/scp.orig

# Create a new file </usr/bin/scp>.

vi /usr/bin/scp

# Add the below line to the new created file </usr/bin/scp>.

/usr/bin/scp.orig -T $*

# Change the file permission.

chmod 555 /usr/bin/scp

or 

 mv /usr/bin/scp /usr/bin/scp.orig

 echo "/usr/bin/scp.orig -T $*" > /usr/bin/scp

 chmod 555 /usr/bin/scp

After installation:

mv /usr/bin/scp.orig /usr/bin/scp

cluvfy - pre installation check

 

runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup -fixupnoexec -verbose -method root

runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup -fixupnoexec -verbose -method 

To install Oracle Clusterware/Grid Infrastructure using the Oracle Universal Installer

1. Ensure that the Oracle grid user has the following capabilities:

   CAP_NUMA_ATTACH, CAP_BYPASS_RAC_VMM, and CAP_PROPAGATE

   To check existing capabilities, enter the following command as root; in this example, the Oracle grid user is grid:

   # lsuser -a capabilities grid

   To add capabilities, enter a command similar to the following:

   # /usr/bin/chuser \
   capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid

2. The ncargs attribute controls the maximum command line length, including the environment variables on the AIX nodes. Verify the current value of the ncargs attribute.

   # lsattr -l sys0 -a ncargs -E

   If the value is less than 128, change the attribute to a larger value before invoking the Oracle Installer.

   # chdev -l sys0 -a ncargs=128

3. set DISPLAY varraible

4. execute $GI_HOME/gridSetup.sh as grid 

profile parameter setup to show on user prompt unix

 export PS1=`hostname`:$(whoami)\['$ORACLE_SID'\]'$ '

Move RMAN backupset from disk to tape

To back up backup sets from disk to tape:

1. Assuming that you have configured an automatic sbt channel, issue the BACKUP BACKUPSET command at the RMAN prompt. This example backs up all disk backup sets to tape:

   RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL;
   
   

   This example backs up all disk backup sets to tape and then deletes the input disk backups:

   RMAN> BACKUP DEVICE TYPE sbt BACKUPSET ALL DELETE INPUT; 
   
   

2. Issue a LIST command to see a listing of backup sets and pieces.

DB Lit CDB & Non CDB

cat dblist.sh
#!/bin/sh
rm -rf DB_Stat.log sp_db_status.log
status_db () {
DB=`ps -ef |grep pmon |egrep -v "grep|ASM|CDB|MGMTDB" |awk '{print $8}'|cut -d '_' -f3`
#DB=`cat $LOG_DIR/before_patch.log`
for i in `echo $DB`
do
#sleep 1
export ORACLE_SID=$i
export ORAENV_ASK=NO
echo "connecting to the databbase $i"
. oraenv $i
#sqlplus -s "/ as sysdba" <> $LOG_DIR/db_stop_start_log
stat_db=`sqlplus -s "/ as sysdba" <                set lines 100
                set pages 5
                col inst_id for 99
                col instance_name for a10
                col name for a10
                col open_mode for a25
                col i.logins for a14
                set feedback off hea off time off timing off
                spool sp_db_status.log append
                select i.instance_name,d.name ,d.open_mode, i.logins from v\\$instance i, v\\$database d  order by 1 ;
                spool off;
exit;
EOF`
#echo "$stat" | tee -a CDB_Stat.log
#echo "INSTANCE_N NAME       OPEN_MODE      LOGINS" >> DB_Stat.log
#echo "---------- ---------- -------------- ----------" >> DB_Stat.log
echo "$stat_db" >> DB_Stat.log
#cat DB_Stat.log -n > DB_Stat.log
done
export i=
export DB=
}

status_cdb () {
CDB=`ps -ef |grep pmon |egrep CDB |awk '{print $8}'|cut -d '_' -f3`
#DB=`cat $LOG_DIR/before_patch.log`
for i in `echo $CDB`
do
#sleep 1
export ORACLE_SID=$i
export ORAENV_ASK=NO
echo "connecting to the databbase $i"
. oraenv $i
#sqlplus -s "/ as sysdba" <> $LOG_DIR/db_stop_start_log
stat_cdb=`sqlplus -s "/ as sysdba" <                col inst_id for 99
                set pages 20
                set lines 100
                col status for a30
                col name for a10
                col open_mode for a25
                col restricted for a14
                set feedback off hea off time off timing off
                spool sp_cdb_status.log append
                select p.name ,c.name ,p.open_mode ,p.restricted from v\\$pdbs p, v\\$database c where  p.name <> 'PDB\\$SEED'  order by 2,1 ;
                spool off;
exit;
EOF`
#echo "$stat" | tee -a CDB_Stat.log
echo "$stat_cdb" >> DB_Stat.log
cat DB_Stat.log -n >> DB_Stat.logn
done
export i=
export DB=
}


status_db
status_cdb
#rm DB_Stat.lo
#awk NF DB_Stat.logn > DB_Stat.log

#echo "" >> DB_Stat
#echo "INSTANCE_N NAME       OPEN_MODE      RESTRICTED" > DB_Stat
#echo "---------- ---------- -------------- ----------" >> DB_Stat
awk NF DB_Stat.log > DB_Stat
cat DB_Stat -n > DB_Statn
sed -i '1 i\ ' DB_Statn
sed -i '2 i\        INSTANCE_N NAME       OPEN_MODE                 RESTRICTED' DB_Statn
sed -i '3 i\        ---------- ---------- ------------------------- ----------' DB_Statn

#cat DB_Stat.lo
cat DB_Statn
exit;

Database Activities

Activities Here

SQL Server Administration Pages and Links

Put your SQL Server Administration pages link