select sid,
username,
round(total_user_mem/1024/1024,2) mem_used_in_mb,
round(100 * total_user_mem/total_mem,2) mem_percent
from
(select
b.sid sid,
nvl(b.username,p.name) username,
sum(value) total_user_mem
from
sys.v_$statname c,
sys.v_$sesstat a,
sys.v_$session b,
sys.v_$bgprocess p
where
a.statistic#=c.STATISTIC# and
p.paddr (+) = b.paddr and
b.sid=a.sid and
c.name in ('session pga memory','session uga memory')
group by
b.sid, nvl(b.username,p.name)),
(select
sum(value) total_mem
from
sys.v_$statname c,
sys.v_$sesstat a
where
a.statistic#=c.STATISTIC# and
c.name in ('session pga memory','session uga memory'))
order by 3 desc;
Wednesday, 2 February 2011
Oracle which session are hogging the database
select
sid,
serial,
username,
round(100 * total_user_io/total_io,2) tot_io_pct
from
(select
b.sid sid,
serial# serial,
nvl(b.username,p.name) username,
sum(value) total_user_io
from
sys.v_$statname c,
sys.v_$sesstat a,
sys.v_$session b,
sys.v_$bgprocess p
where
a.statistic#=c.statistic# and
p.paddr (+) = b.paddr and
b.sid=a.sid and
c.name in ('physical reads',
'physical writes',
'physical writes direct',
'physical reads direct',
'physical writes direct (lob)',
'physical reads direct (lob)')
group by b.sid,serial#, nvl(b.username,p.name)),
(select sum(value) total_io
from
sys.v_$statname c,
sys.v_$sesstat a
where
a.statistic#=c.statistic# and
c.name in ('physical reads',
'physical writes',
'physical writes direct',
'physical reads direct',
'physical writes direct (lob)',
'physical reads direct (lob)'))
order by 3 desc;
=======
from Web ---
set serveroutput on
declare
cursor c1 is
select version from v$instance;
cursor c2 is
select
host_name
, instance_name
, to_char(sysdate, 'DD-MON-YY HH24:MI:SS') currtime
, to_char(startup_time, 'DD-MON-YY HH24:MI:SS') starttime
from v$instance;
cursor c4 is
select * from (SELECT count(*) cnt, substr(event,1,50) event
FROM v$session_wait
WHERE wait_time = 0
AND event NOT IN ('smon timer','pipe get','wakeup time manager','pmon timer','rdbms ipc message',
'SQL*Net message from client')
GROUP BY event
ORDER BY 1 DESC) where rownum <6;
cursor c5 is
select round(sum(value)/1048576) as sgasize from v$sga;
cursor c6 is select round(sum(bytes)/1048576) as dbsize
from v$datafile;
cursor c7 is
select 'top physical i/o process' category, sid,
username, total_user_io amt_used,
round(100 * total_user_io/total_io,2) pct_used
from (select b.sid sid, nvl(b.username, p.name) username,
sum(value) total_user_io
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name in ('physical reads', 'physical writes',
'physical reads direct',
'physical reads direct (lob)',
'physical writes direct',
'physical writes direct (lob)')
and b.username not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP')
group by b.sid, nvl(b.username, p.name)
order by 3 desc),
(select sum(value) total_io
from v$statname c, v$sesstat a
where a.statistic# = c.statistic#
and c.name in ('physical reads', 'physical writes',
'physical reads direct',
'physical reads direct (lob)',
'physical writes direct',
'physical writes direct (lob)'))
where rownum < 2
union all
select 'top logical i/o process', sid, username,
total_user_io amt_used,
round(100 * total_user_io/total_io,2) pct_used
from (select b.sid sid, nvl(b.username, p.name) username,
sum(value) total_user_io
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name in ('consistent gets', 'db block gets')
and b.username not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP')
group by b.sid, nvl(b.username, p.name)
order by 3 desc),
(select sum(value) total_io
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name in ('consistent gets', 'db block gets'))
where rownum < 2
union all
select 'top memory process', sid,
username, total_user_mem,
round(100 * total_user_mem/total_mem,2)
from (select b.sid sid, nvl(b.username, p.name) username,
sum(value) total_user_mem
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name in ('session pga memory', 'session uga memory')
and b.username not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP')
group by b.sid, nvl(b.username, p.name)
order by 3 desc),
(select sum(value) total_mem
from v$statname c, v$sesstat a
where a.statistic# = c.statistic#
and c.name in ('session pga memory', 'session uga memory'))
where rownum < 2
union all
select 'top cpu process', sid, username,
total_user_cpu,
round(100 * total_user_cpu/greatest(total_cpu,1),2)
from (select b.sid sid, nvl(b.username, p.name) username,
sum(value) total_user_cpu
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name = 'CPU used by this session'
and b.username not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP')
group by b.sid, nvl(b.username, p.name)
order by 3 desc),
(select sum(value) total_cpu
from v$statname c, v$sesstat a,
v$session b, v$bgprocess p
where a.statistic# = c.statistic#
and p.paddr (+) = b.paddr
and b.sid = a.sid
and c.name = 'CPU used by this session')
where rownum < 2;
cursor c8 is select username, sum(VALUE/100) cpu_usage_sec
from v$session ss, v$sesstat se, v$statname sn
where se.statistic# = sn.statistic#
and name like '%CPU used by this session%'
and se.sid = ss.sid
and username is not null
and username not in ('SYS', 'SYSTEM', 'SYSMAN', 'DBSNMP')
group by username
order by 2 desc;
begin
dbms_output.put_line ('Database Version');
dbms_output.put_line ('=================');
for rec in c1
loop
dbms_output.put_line(rec.version);
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line('Hostname');
dbms_output.put_line ('========================');
for rec in c2
loop
dbms_output.put_line(rec.host_name);
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line('SGA Size (MB)');
dbms_output.put_line ('=======================');
for rec in c5
loop
dbms_output.put_line(rec.sgasize);
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line('Database Size (MB)');
dbms_output.put_line ('=======================');
for rec in c6
loop
dbms_output.put_line(rec.dbsize);
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line('Instance start-up time');
dbms_output.put_line ('=======================');
for rec in c2 loop
dbms_output.put_line( rec.starttime );
end loop;
dbms_output.put_line( chr(13) );
for b in
(select total, active, inactive, system, killed
from
(select count(*) total from v$session)
, (select count(*) system from v$session where username is null)
, (select count(*) active from v$session where status = 'ACTIVE' and username is not null)
, (select count(*) inactive from v$session where status = 'INACTIVE')
, (select count(*) killed from v$session where status = 'KILLED')) loop
dbms_output.put_line('Active Sessions');
dbms_output.put_line ('=======================');
dbms_output.put_line(b.total || ' sessions: ' || b.inactive || ' inactive,' || b.active || ' active, ' || b.system || ' system, ' || b.killed || ' killed ');
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line( 'Sessions Waiting' );
dbms_output.put_line( chr(13) );
dbms_output.put_line('Count Event Name');
dbms_output.put_line('=======================');
for rec in c4
loop
dbms_output.put_line(rec.cnt||' '||rec.event);
end loop;
dbms_output.put_line( chr(13) );
dbms_output.put_line('=======================');
dbms_output.put_line('TOP Physical i/o, logical i/o, memory and CPU processes');
dbms_output.put_line ('=======================');
for rec in c7
loop
dbms_output.put_line (rec.category||': SID '||rec.sid||' User : '||rec.username||': Amount used : '||rec.amt_used||': Percent used: '||rec.pct_used);
end loop;
dbms_output.put_line('=======================');
dbms_output.put_line('TOP CPU users by usage');
dbms_output.put_line ('=======================');
for rec in c8
loop
dbms_output.put_line (rec.username||'-'||rec.cpu_usage_sec);
dbms_output.put_line ('=======================');
end loop;
end;
/
Oracle Top 10 most resource intensive queries
Oracle most resource intensive queries
set pagesize 200
select sql_text,
username,
disk_reads_per_exec,
buffer_gets,
disk_reads,
parse_calls,
sorts,
executions,
rows_processed,
hit_ratio,
first_load_time,
sharable_mem,
persistent_mem,
runtime_mem,
cpu_time,
elapsed_time,
address,
hash_value,
sql_id
from
(select sql_text ,
b.username ,
round((a.disk_reads/decode(a.executions,0,1,a.executions)),2)
disk_reads_per_exec,
a.disk_reads ,
a.buffer_gets ,
a.parse_calls ,
a.sorts ,
a.executions ,
a.rows_processed ,
100 - round(100 * a.disk_reads/greatest(a.buffer_gets,1),2) hit_ratio,
a.first_load_time ,
sharable_mem ,
persistent_mem ,
runtime_mem,
cpu_time,
elapsed_time,
address,
hash_value,
a.sql_id
from
sys.v_$sqlarea a,
sys.all_users b
where
a.parsing_user_id=b.user_id and
b.username not in ('SYS','SYSTEM','SYSMAN','ORACLE_OCM','DBSNMP','MDSYS','XDB','EXFSYS')
order by 3 desc)
where rownum < 11
-- SYSMAN
-- The SYSMAN user represents the Enterprise Manager super admin account.
-- This EM admin can create and modify other EM admin accounts as well as admin the database
-- -- instance itself.
-- DBSNMP
-- The DBSNMP user is used by EM to monitor the database. EM uses this account to access
-- performance stats about the database.
-- The DBSNMP credentials sometimes referred to as the monitoring credentials.
/
default user list
http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml
set pagesize 200
select sql_text,
username,
disk_reads_per_exec,
buffer_gets,
disk_reads,
parse_calls,
sorts,
executions,
rows_processed,
hit_ratio,
first_load_time,
sharable_mem,
persistent_mem,
runtime_mem,
cpu_time,
elapsed_time,
address,
hash_value,
sql_id
from
(select sql_text ,
b.username ,
round((a.disk_reads/decode(a.executions,0,1,a.executions)),2)
disk_reads_per_exec,
a.disk_reads ,
a.buffer_gets ,
a.parse_calls ,
a.sorts ,
a.executions ,
a.rows_processed ,
100 - round(100 * a.disk_reads/greatest(a.buffer_gets,1),2) hit_ratio,
a.first_load_time ,
sharable_mem ,
persistent_mem ,
runtime_mem,
cpu_time,
elapsed_time,
address,
hash_value,
a.sql_id
from
sys.v_$sqlarea a,
sys.all_users b
where
a.parsing_user_id=b.user_id and
b.username not in ('SYS','SYSTEM','SYSMAN','ORACLE_OCM','DBSNMP','MDSYS','XDB','EXFSYS')
order by 3 desc)
where rownum < 11
-- SYSMAN
-- The SYSMAN user represents the Enterprise Manager super admin account.
-- This EM admin can create and modify other EM admin accounts as well as admin the database
-- -- instance itself.
-- DBSNMP
-- The DBSNMP user is used by EM to monitor the database. EM uses this account to access
-- performance stats about the database.
-- The DBSNMP credentials sometimes referred to as the monitoring credentials.
/
default user list
http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml
dbms_sqltune with example
First find out the sqlid from
select sid,serial#,sql_id from v$session where username='user name ';
or
find the top sql in particulate schema
SELECT * FROM
(SELECT
sql_fulltext,
sql_id,
child_number,
disk_reads,
executions,
first_load_time,
last_load_time
FROM v$sql
where PARSING_SCHEMA_NAME='ANUJ'
ORDER BY elapsed_time DESC)
WHERE ROWNUM < 10
/
First create the tuning task:
set serveroutput on
set long 10000 longchunksize 5000
DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id => 'c6u1g74vugzxz',
scope => 'COMPREHENSIVE',
time_limit => 3000,
task_name => 'c6u1g74vugzxz_tune',
description => 'Task to tune a query');
END;
/
Execute the task
SYS AS SYSDBA>exec dbms_sqltune.execute_tuning_task('c6u1g74vugzxz_tune');
PL/SQL procedure successfully completed.
Now run the report for task
SYS AS SYSDBA>set long 20000
set longchunksize 20000
set linesize 400
select dbms_sqltune.report_tuning_task('c6u1g74vugzxz_tune') from dual;
select sid,serial#,sql_id from v$session where username='user name ';
or
find the top sql in particulate schema
SELECT * FROM
(SELECT
sql_fulltext,
sql_id,
child_number,
disk_reads,
executions,
first_load_time,
last_load_time
FROM v$sql
where PARSING_SCHEMA_NAME='ANUJ'
ORDER BY elapsed_time DESC)
WHERE ROWNUM < 10
/
First create the tuning task:
set serveroutput on
set long 10000 longchunksize 5000
DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id => 'c6u1g74vugzxz',
scope => 'COMPREHENSIVE',
time_limit => 3000,
task_name => 'c6u1g74vugzxz_tune',
description => 'Task to tune a query');
END;
/
Execute the task
SYS AS SYSDBA>exec dbms_sqltune.execute_tuning_task('c6u1g74vugzxz_tune');
PL/SQL procedure successfully completed.
Now run the report for task
SYS AS SYSDBA>set long 20000
set longchunksize 20000
set linesize 400
select dbms_sqltune.report_tuning_task('c6u1g74vugzxz_tune') from dual;
Tuesday, 1 February 2011
How to check the Opatch version?
/opt/oracle/product/10.2/OPatch
-bash-3.00$ ./opatch version
Invoking OPatch 10.2.0.4.3
OPatch Version: 10.2.0.4.3
OPatch succeeded.
-bash-3.00$ ./opatch -help
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Usage: opatch [ -help ] [ -r[eport] ] [ command ]
command := apply
lsinventory
napply
nrollback
rollback
query
version
prereq
util
-report Print the actions without executing.
example:
'opatch -help'
'opatch apply -help'
'opatch lsinventory -help'
'opatch napply -help'
'opatch nrollback -help'
'opatch rollback -help'
'opatch prereq -help'
'opatch util -help'
OPatch succeeded.
Rolling back a patch
In case if a patch did not fix the issue or if you has applied wrong patch to oracle home, you can always rollback the patch using following comamnd.
opatch rollback -id
wget --http-user=oracle@***.com --http-password=****** --no-check-certificate --output-document=p6880880_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip"
wget --http-user=oracle@***.com --http-password=****** --no-check-certificate --output-document=p6880880_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip"
--2024-02-14 08:45:07-- https://updates.oracle.com/Orion/Services/download/p6880880_190000_Linux-x86-64.zip?aru=25541367&patch_file=p6880880_190000_Linux-x86-64.zip
Resolving updates.oracle.com (updates.oracle.com)... 2a02:26f0:fd00:d81::4425, 2a02:26f0:fd00:da5::4425, 23.64.16.120
Connecting to updates.oracle.com (updates.oracle.com)|2a02:26f0:fd00:d81::4425|:443... connected.
HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to [updates.oracle.com]:443.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: https://aru-akam.oracle.com/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip?FilePath=/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip&File=p6880880_190000_Linux-x86-64.zip¶ms=YzJJaDdtRGpHb3l5WkpLQk1wYm9lQTphcnU9MjU1NDEzNjcmZW1haWw9bWFzdGVyYnJhbmQub2Vicy5tYWlsQHJhY2tzcGFjZS5jb20mZmlsZV9pZD0xMTIwMTQwOTAmcGF0Y2hfZmlsZT1wNjg4MDg4MF8xOTAwMDBfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9Ty1PUkFDTEVUQVJAUkFDS1NQQUNFLkNPTSZzaXplPTEyNzYyOTAzNCZjb250ZXh0PUFAMTArSEBwaHhwYWFydWxwcmRtdDAyLm10cHJvZGFlcGh4LnByb2RhcHBwaHhhZXYxLm9yYWNsZXZjbi5jb20rUEAmZG93bmxvYWRfaWQ9NDcyMTQ2ODgw&AuthParam=1707900432_f1301fcf05d1d8df2909dce6e2664958 [following]
--2024-02-14 08:45:12-- https://aru-akam.oracle.com/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip?FilePath=/adcarurepos/vol/patch47/PLATFORM/Linux-x86-64/P31944/R600000000122912/p6880880_190000_Linux-x86-64.zip&File=p6880880_190000_Linux-x86-64.zip¶ms=YzJJaDdtRGpHb3l5WkpLQk1wYm9lQTphcnU9MjU1NDEzNjcmZW1haWw9bWFzdGVyYnJhbmQub2Vicy5tYWlsQHJhY2tzcGFjZS5jb20mZmlsZV9pZD0xMTIwMTQwOTAmcGF0Y2hfZmlsZT1wNjg4MDg4MF8xOTAwMDBfTGludXgteDg2LTY0LnppcCZ1c2VyaWQ9Ty1PUkFDTEVUQVJAUkFDS1NQQUNFLkNPTSZzaXplPTEyNzYyOTAzNCZjb250ZXh0PUFAMTArSEBwaHhwYWFydWxwcmRtdDAyLm10cHJvZGFlcGh4LnByb2RhcHBwaHhhZXYxLm9yYWNsZXZjbi5jb20rUEAmZG93bmxvYWRfaWQ9NDcyMTQ2ODgw&AuthParam=1707900432_f1301fcf05d1d8df2909dce6e2664958
Resolving aru-akam.oracle.com (aru-akam.oracle.com)... 23.39.224.75
Connecting to aru-akam.oracle.com (aru-akam.oracle.com)|23.39.224.75|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 127629034 (122M) [application/zip]
Saving to: ‘p6880880_190000_Linux-x86-64.zip’
100%[================================================================================================================================================================================================>] 127,629,034 85.7MB/s in 1.4s
2024-02-14 08:45:14 (85.7 MB/s) - ‘p6880880_190000_Linux-x86-64.zip’ saved [127629034/127629034]
[anuj@ ~]$ ls -ltr
total 1139892
-rw-------. 1 anuj2804 users 127629034 Jan 24 04:26 p6880880_190000_Linux-x86-64.zip
[anuj2804@cbast1 ~]$
========================
mv OPatch OPatch-14-06-2025
echo $ORACLE_HOME
unzip -qqd $ORACLE_HOME /home/oracle/p6880880_190000_Linux-x86-64.zip
[oracle@ora19 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.46
OPatch succeeded.
=======
as root <<<<<<<<<<<<<<
+ASM1:/u01/app/19.0.0/grid
[root@ora-rac1 grid]# . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/grid
[root@ora-rac1 grid]# ls -ltr /home/grid
total 3561552
-rwxrwxrwx 1 root root 394 Nov 28 2024 asmdisk.sh
-rwxr-xr-x 1 root root 33333 Nov 28 2024 sshUserSetup.sh
-rw-r--r-- 1 grid oinstall 36664 Nov 29 2024 grid.rsp
drwxr-x--- 15 grid oinstall 4096 Dec 23 2024 OPatch
drwxr-x--- 8 grid oinstall 159 Jan 20 2025 37257886
-rw-r--r-- 1 grid oinstall 131979857 Jan 21 2025 p6880880_190000_Linux-x86-64.zip
-rw-rw-r-- 1 grid oinstall 2654673 Jan 21 2025 PatchSearch.xml
-rw-r--r-- 1 grid oinstall 3512303969 Dec 29 09:00 p37257886_190000_Linux-x86-64.zip
[root@ora-rac1 grid]# echo $ORACLE_HOME
/u01/app/19.0.0/grid
mv OPatch OPatch-29-12-2025
[root@ora-rac1 grid]# unzip -qqd $ORACLE_HOME /home/grid/p6880880_190000_Linux-x86-64.zip
[root@ora-rac1 grid]# pwd
/u01/app/19.0.0/grid
[root@ora-rac1 grid]# ls -ld O*
drwxr-x--- 15 root root 4096 Dec 23 2024 OPatch
drwxrwxr-x. 14 grid oinstall 4096 Nov 29 2024 OPatch-29-12-2025
chown -R grid:oinstall $ORACLE_HOME/OPatch
[root@ora-rac1 grid]# chown -R grid:oinstall $ORACLE_HOME/OPatch
[root@ora-rac1 grid]# ls -ld O*
drwxr-x--- 15 grid oinstall 4096 Dec 23 2024 OPatch
drwxrwxr-x. 14 grid oinstall 4096 Nov 29 2024 OPatch-29-12-2025
Connect to SQL*Plus with no TNSnames
Oracle's easy connect naming method. EZCONNECT sqlplus [user]/[password]@//[database_host]:[port]/[service_name] service_name=SID In order to be prompted for a password while using the EZCONNECT naming adapter, use the following syntax: sqlplus username@\"[hostname]:[port]/[service name]\" example: sqlplus system@\"netfl-unix1:1521/v10.us.oracle.com\" If you performed a "typical" Oracle database server installation, the default service name for the instance will be ORCL. Use the following easy connect syntax to connect to that instance: SQL> select NAME from v$database; NAME --------- ORCL database DEV01 sqlplus scott/tiger@apt-lnxtst-01/orcl if port no is default i.e. 1521 then there is no need for port sqlplus scott/tiger@BIGSERVER:1616/DEV01 oracle@apt-lnxtst-01:~> sqlplus scott/tiger@192.168.2.232/orcl sqlplus scott/tiger@apt-lnxtst-01/orcl sqlplus scott/tiger@192.168.2.232:1521/orcl sqlplus scott/tiger@192.168.2.232:1521/orcl ================= ************** sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=***-scan.****)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=arac))))' SQL*Plus: Release 12.2.0.1.0 Production on Fri Dec 17 01:40:14 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter password: ERROR: ORA-28002: the password will expire within 7 days Last Successful login time: Sat Oct 23 2021 07:48:12 -05:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production primary:anuj@******** sqlplus> ************** sqlplus/ @"(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.211.106.64)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=10))))" ww HOST=4.106.245.35 = vip ip sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac))))' sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac)(SID=brac1))))' sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=4.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=brac)(SID=brac1))))' sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(UR=A)(SID=brac1))))' sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(SID=brac1))))' sqlplus anuj@'(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=off)(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=TCP)(HOST=64.106.245.35)(PORT=1521))(CONNECT_DATA=(SID=ibrac1))))'
Subscribe to:
Posts (Atom)
