Oracle tnsping and connection testing

tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))(CONNECT_DATA=(SID=oem)))' 10


tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))(CONNECT_DATA=(SID=oem)(SERVICE_NAME= empdbrepos)))' 10

tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=192.168.1.197)(Port=1521))(CONNECT_DATA=(SERVICE_NAME= empdbrepos)))' 10


=======
tnsping '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=192.168.1.197)(Port=1521))(CONNECT_DATA=(SID=oem)(SERVICE_NAME= empdbrepos)))' 10

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 26-JAN-2025 11:49:54

Copyright (c) 1997, 2024, Oracle.  All rights reserved.

Attempting to contact (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=192.168.1.197)(Port=1521))(CONNECT_DATA=(SID=oem)(SERVICE_NAME= empdbrepos)))
OK (0 msec)
OK (0 msec)
OK (10 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
OK (0 msec)
=========


connection test via sqlplus 


for i in {1..2} ; do sqlplus -L -s sys/sys@//192.168.1.197/empdbrepos as sysdba <<< 'select name,open_mode,instance_name from v$instance , v$database;'; done


for i in {1..2} ; do sqlplus -L -s sys/sys@//192.168.1.197/empdbrepos as sysdba <<< 'select DUMMY from dual;'; done

D
-
X


D
-
X

=====

SQL> grant dba to anuj identified by vihaan123 ;


Grant succeeded.


sqlplus 'anuj/vihaan123@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521))(CONNECT_DATA=(SID=oem)(SERVICE_NAME= empdbrepos)))'


[oracle@ORAOEM admin]$ sqlplus 'anuj/vihaan123@empdbrepos'

======

while true do for i in {1..2} ; do sqlplus -L -s sys/sys@//192.168.1.197/empdbrepos as sysdba <<< 'select name,open_mode,instance_name from v$instance , v$database;'; done done



while true
do
  for i in {1..2} ; do sqlplus -L -s sys/sys@//192.168.1.197/empdbrepos as sysdba <<< 'select name,open_mode,instance_name from v$instance , v$database;'; done
  sleep 5
done

unix while loop

while true
do
echo Filesystem           Size  Used Avail Use% Mounted on
  df -Ph | grep home
  sleep 4
df -k | grep home
done


=====================================
output 


Filesystem Size Used Avail Use% Mounted on
/dev/mapper/cl-home   96G   42G   55G  44% /home
/dev/mapper/cl-home 100298908 43191548  57107360  44% /home
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/cl-home   96G   42G   55G  44% /home
/dev/mapper/cl-home 100298908 43191552  57107356  44% /home
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/cl-home   96G   42G   55G  44% /home
/dev/mapper/cl-home 100298908 43191552  57107356  44% /home