Using username "oracle".

Last unsuccessful login: Tue Oct 22 15:28:23 IST 2024 on ssh from 10.94.141.87
Last login: Tue Oct 22 23:17:45 IST 2024 on ssh from 172.18.172.192
###############################################################################
# #
# "This is an Vodafone Idea Ltd system and is meant for official use by #
# authorized users. #
# #
# Accessing and using this system constitutes consent to monitoring, interce #
# ption, retrieval,recording, reading, copying, searching or capturing and #
# disclosure of any information as to any information processed,stored or ma #
# nipulated within the system, including but not limited to information stor #
# ed locally on the hard drive or other media in use with this unit internal #
# ly or externally (e.g., floppy disks, tapes, CD-ROMs, PDA.s etc.) by the #
# company management or law enforcement agencies. #
# #
# Unauthorized or improper use of this system may lead to prosecution result #
# ing in disciplinary, criminal or civil penalties.Suspected access violatio #
# ns or breach of security policy should be reported to Account security #
# SPOC." #
# #
###############################################################################
You are logged :- oracle pts/1 Dec 02 18:20 (172.18.172.191)at Mon Dec 2 18:20:08
IST 2024

oratab file /etc/oratab found.

Alias for SUMCPSQA1 environment variables is set to SUMCPSQA1

Alias for +ASM environment variables is set to ASM

oracle 10027460 1 0 Feb 05 - 8:47 ora_pmon_SUMCPSQA1

oracle 10813788 1 0 Feb 05 - 9:10
/grid_19c/oracle/Grid19CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 12059096 1 0 Feb 05 - 5:01
/grid_19c/oracle/Grid19CHome/bin/tnslsnr MARS_P -no_crs_notify -inherit
oracle 12845456 1 0 Feb 05 - 5:04 asm_pmon_+ASM

[]@ndc3vqaicpsdb07:/home/oracle > SUMCPSQA1

ORACLE_SID is set to :- SUMCPSQA1
ORACLE_HOME is set to :- /oracle_19c/oracle/ora_base/Ora19CHome
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle > cd scripts
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > sqlplus -v

SQL*Plus: Release 19.0.0.0.0 - Production

Version 19.20.0.0.0

[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > uname -a

AIX ndc3vqaicpsdb07 2 7 00C07FE84C00
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > hostname
ndc3vqaicpsdb07
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > cat /etc/hosts
# @(#)47 1.2.1.1 src/bos/usr/sbin/netstart/hosts, cmdnet, bos720 7/14/11
20:16:59
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos720 src/bos/usr/sbin/netstart/hosts 1.2.1.1
#
# Licensed Materials - Property of IBM
#
# COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 26 27
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# /etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network. This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file. It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
# The format of this file is:
# Internet Address Hostname # Comments
# Internet Address can be either IPv4 or IPv6 address.
# Items are separated by any number of blanks and/or tabs. A '#'
# indicates the beginning of a comment; characters up to the end of the
# line are not interpreted by routines which search this file. Blank
# lines are allowed.

# Internet Address Hostname # Comments

# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
::1 loopback localhost # IPv6 loopback (lo0) name/address
10.94.134.74 ndc3vqaicpsdb07

10.94.32.11 NDC3LAITNIM01

10.94.1.162 itambcn.vodafone.co.in
10.94.1.162 itambcn.vodafone.co.in

10.77.8.102 tsmpunesvr
10.94.108.24 NDC3CWNPTEMP01.internal.vodafone.com
10.94.108.25 NDC3CWNPTEMS01.internal.vodafone.com
10.94.1.162 ITAMbcn.vodafone.co.in
10.94.1.162 ITAMbcn.vodafone.co.in
10.94.136.11 ndc3vpaiappnim
10.94.140.11 ndc3vpaidbnim
10.94.134.11 ndc3vqtestnim
10.94.32.11 NDC3LAITNIM01
10.94.136.11 NDC3VPAIAPPNIM
10.94.1.162 itambcn.vodafone.co.in
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > no -a
arpqsize = 1024
arpt_killc = 20
arptab_bsiz = 7
arptab_nb = 149
bcastping = 0
bsd_loglevel = 3
cached_routes = 0
clean_partial_conns = 1
delayack = 0
delayackports = {}
dgd_flush_cached_route = 0
dgd_packets_lost = 3
dgd_ping_time = 5
dgd_retry_time = 5
directed_broadcast = 0
dmxperf = 0
fasttimo = 200
hstcp = 0
icmp6_errmsg_rate = 10
icmpaddressmask = 0
icmptimestamp = 1
ie5_old_multicast_mapping = 0
ifsize = 256
ifstats32 = 0
igmpv2_deliver = 0
init_high_wat = 0
ip6_defttl = 64
ip6_prune = 1
ip6forwarding = 0
ip6srcrouteforward = 0
ip_ifdelete_no_retrans = 0
ip_ifdelete_notify = 0
ip_nfrag = 200
ipforwarding = 0
ipfragttl = 2
ipignoreredirects = 1
ipoutqueues = 0
ipqmaxlen = 512
ipsendredirects = 0
ipsrcrouteforward = 0
ipsrcrouterecv = 0
ipsrcroutesend = 0
limited_ss = 0
llsleep_timeout = 3
lo_perf = 1
lowthresh = 90
main_if6 = 0
main_site6 = 0
 maxnip6q = 20
maxttl = 255
medthresh = 95
mpr_policy = 1
multi_homed = 1
nbc_limit = 5242880
nbc_max_cache = 131072
nbc_min_cache = 1
nbc_ofile_hashsz = 12841
nbc_pseg = 0
nbc_pseg_limit = 10485760
ndd_event_name = {all}
ndd_event_tracing = 0
ndogthreads = 0
ndp_mmaxtries = 3
ndp_umaxtries = 3
ndpqsize = 50
ndpt_down = 3
ndpt_keep = 120
ndpt_probe = 5
ndpt_reachable = 30
ndpt_retrans = 1
net_buf_size = {all}
net_buf_type = {all}
net_malloc_frag_mask = {0}
netm_page_promote = 1
nonlocsrcroute = 0
nstrpush = 8
passive_dgd = 0
pmtu_default_age = 10
pmtu_expire = 10
pmtu_rediscover_interval = 30
psebufcalls = 20
psecache = 1
psetimers = 20
rfc1122addrchk = 0
rfc1323 = 1
rfc2414 = 1
route_expire = 1
routerevalidate = 0
rtentry_lock_complex = 1
rto_high = 64
rto_length = 13
rto_limit = 7
rto_low = 1
rtpool_size = 25
sack = 0
sb_max = 1048576
send_file_duration = 300
site6_index = 0
sockthresh = 60
sodebug = 0
sodebug_env = 0
somaxconn = 1024
soreuseport_lb = 0
strctlsz = 1024
strmsgsz = 0
strthresh = 85
strturncnt = 15
 subnetsarelocal = 1
tcp_bad_port_limit = 0
tcp_cwnd_modified = 0
tcp_ecn = 0
tcp_ephemeral_high = 65500
tcp_ephemeral_low = 9000
tcp_fastlo = 0
tcp_fastlo_crosswpar = 0
tcp_finwait2 = 120
tcp_icmpsecure = 0
tcp_init_window = 0
tcp_inpcb_hashtab_siz = 24499
tcp_keepcnt = 8
tcp_keepidle = 600
tcp_keepinit = 40
tcp_keepintvl = 10
tcp_limited_transmit = 1
tcp_low_rto = 0
tcp_maxburst = 0
tcp_maxqueuelen = 0
tcp_mssdflt = 1448
tcp_nagle_limit = 65535
tcp_nagleoverride = 0
tcp_ndebug = 100
tcp_newreno = 1
tcp_nodelayack = 1
tcp_pmtu_discover = 1
tcp_recvspace = 262144
tcp_sendspace = 262144
tcp_syn_rto = 0
tcp_tcpsecure = 7
tcp_timewait = 1
tcp_ttl = 60
tcprexmtthresh = 3
tcptr_enable = 0
thewall = 20971520
timer_wheel_tick = 0
tn_filter = 1
udp_bad_port_limit = 0
udp_ephemeral_high = 65500
udp_ephemeral_low = 9000
udp_inpcb_hashtab_siz = 24499
udp_pmtu_discover = 0
udp_recv_perf = 0
udp_recvspace = 655360
udp_send_perf = 0
udp_sendspace = 65536
udp_ttl = 30
udpcksum = 1
use_sndbufpool = 1
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > netstat -in
Name Mtu Network Address Ipkts Ierrs Opkts
Oerrs Coll
en0 9000 link#2 fa.e5.d8.7d.6.20 198227284 0 119810682
0 0
en0 9000 10.94.134 10.94.134.74 198227284 0 119810682
0 0
en1 1500 link#3 e2.88.ce.93.67.a6 2 0 7
0 0
en1 1500 fe80::e088:ceff:fe93:67a6 2 0 7
0 0
lo0 16896 link#1 1479330970 0 1479330970
0 0
lo0 16896 127 127.0.0.1 1479330970 0 1479330970
0 0
lo0 16896 ::1%1 1479330970 0 1479330970
0 0
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef|grep -i pmon
oracle 10027460 1 0 Feb 05 - 8:47 ora_pmon_SUMCPSQA1
oracle 12845456 1 0 Feb 05 - 5:04 asm_pmon_+ASM
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef|grep -i tns
oracle 10813788 1 0 Feb 05 - 9:10
/grid_19c/oracle/Grid19CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 12059096 1 0 Feb 05 - 5:01
/grid_19c/oracle/Grid19CHome/bin/tnslsnr MARS_P -no_crs_notify -inherit
oracle 28836286 9306612 0 18:23:32 pts/1 0:00 grep -i tns
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef|grep -i agent
root 6095232 5964070 0 Feb 05 - 0:00 /opt/ds_agent/ds_agent -b -i -
w /var/opt/ds_agent -e /opt/ds_agent/ext
root 6881768 6095232 69 Feb 05 - 32156:15 /opt/ds_agent/ds_agent -b -
i -w /var/opt/ds_agent -e /opt/ds_agent/ext
root 8192368 9175466 0 Feb 05 - 366:36 /opt/ds_agent/ds_am -g
../diag -v 5 -d /var/opt/ds_agent/am -P 4
root 9175466 1 0 Feb 05 - 0:00 /opt/ds_agent/ds_am -g ../diag
-v 5 -d /var/opt/ds_agent/am -P 4
oracle 9765120 1 1 Feb 05 - 212:55
/grid_19c/oracle/Grid19CHome/bin/cssdagent
oracle 9830750 1 0 Feb 05 - 1718:44
/grid_19c/oracle/Grid19CHome/bin/oraagent.bin
root 10682718 1 0 Feb 05 - 483:45
/opt/IBM/ITM/aix526/lo/bin/kloagent ndc3vqaicpsdb07_lfa-logstash
root 27263388 1 0 Apr 12 - 450:41
/opt/IBM/ITM/aix526/lo/bin/kloagent ndc3vqaicpsdb07_aix-errpt
oracle 28836288 9306612 0 18:23:32 pts/1 0:00 grep -i agent
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef|grep -i oem
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef|grep -i d.bin
oracle 8257926 1 0 Feb 05 - 298:39
/grid_19c/oracle/Grid19CHome/bin/ohasd.bin reboot
oracle 10944852 1 0 Feb 05 - 156:56
/grid_19c/oracle/Grid19CHome/bin/evmd.bin
oracle 12517668 1 0 Feb 05 - 177:01
/grid_19c/oracle/Grid19CHome/bin/ocssd.bin
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef |grep -i mgr
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > gg
ksh: gg: not found.
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ggsci
ksh: ggsci: not found.
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef |grep -i tns
oracle 10813788 1 0 Feb 05 - 9:10
/grid_19c/oracle/Grid19CHome/bin/tnslsnr LISTENER -no_crs_notify -inherit
oracle 12059096 1 0 Feb 05 - 5:01
/grid_19c/oracle/Grid19CHome/bin/tnslsnr MARS_P -no_crs_notify -inherit
oracle 28574080 9306612 0 18:23:45 pts/1 0:00 grep -i tns
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > lsnrctl status LISTENER

LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 02-DEC-

2024 18:24:06

Copyright (c) 1991, 2023, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12564: TNS:connection refused
TNS-01194: The listener command did not arrive in a secure transport
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > ASM
ORACLE_SID is set to :- +ASM
ORACLE_HOME is set to :- /grid_19c/oracle/Grid19CHome
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > lsnrctl status LISTENER

LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 02-DEC-

2024 18:24:17

Copyright (c) 1991, 2022, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ndc3vqaicpsdb07)
(PORT=1521)))
TNS-12564: TNS:connection refused
TNS-01194: The listener command did not arrive in a secure transport
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 19.0.0.0.0
- Production
Start Date 05-FEB-2024 01:53:27
Uptime 301 days 16 hr. 30 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid_19c/oracle/Grid19CHome/network/admin/listener.ora
Listener Log File
/grid_19c/oracle/ora_base/diag/tnslsnr/ndc3vqaicpsdb07/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ndc3vqaicpsdb07)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DG_SUMCPSQA_DATA" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_REDO01" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_REDO02" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_REDO03" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > lsnrctl status MARS_P

LSNRCTL for IBM/AIX RISC System/6000: Version 19.0.0.0.0 - Production on 02-DEC-

2024 18:24:23

Copyright (c) 1991, 2022, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ndc3vqaicpsdb07)
(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias MARS_P
Version TNSLSNR for IBM/AIX RISC System/6000: Version 19.0.0.0.0
- Production
Start Date 05-FEB-2024 01:53:27
Uptime 301 days 16 hr. 30 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /grid_19c/oracle/Grid19CHome/network/admin/listener.ora
Listener Log File
/grid_19c/oracle/ora_base/diag/tnslsnr/ndc3vqaicpsdb07/mars_p/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ndc3vqaicpsdb07)(PORT=1526)))
Services Summary...
Service "SUMCPSQA1" has 1 instance(s).
Instance "SUMCPSQA1", status READY, has 1 handler(s) for this service...
Service "SUMCPSQA1XDB" has 1 instance(s).
Instance "SUMCPSQA1", status READY, has 1 handler(s) for this service...
The command completed successfully
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > ifconfig -a
en0:
flags=1e084863,814c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BI
T,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 10.94.134.74 netmask 0xfffffe00 broadcast 10.94.135.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
en1:
flags=1e084863,814c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BI
T,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet6 fe80::e088:ceff:fe93:67a6/64
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
lo0:
flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARG
ESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/64
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_SUMCPSQA_DATA.dg
ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.LISTENER.lsnr
 ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.MARS_P.lsnr
ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.REDO01.dg
ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.REDO02.dg
ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.REDO03.dg
ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.asm
ONLINE ONLINE ndc3vqaicpsdb07 Started,STABLE
ora.ons
OFFLINE OFFLINE ndc3vqaicpsdb07 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE ndc3vqaicpsdb07 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE ndc3vqaicpsdb07 STABLE
--------------------------------------------------------------------------------
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 2 18:24:36 2024

Version 19.17.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> @asm_dg

GROUP_NUMBER NAME STATE TYPE TOTAL_MB

USED_MB FREE_MB USED_PERCENT OFFLINE_DISKS
------------ ------------------------------ ----------- ------ -------------
------------- ------------- ------------ -------------
1 DG_SUMCPSQA_DATA MOUNTED EXTERN 1,339,620.0
829,564.0 510,056.0 62.0 0
2 REDO01 MOUNTED EXTERN 49,152.0
142.0 49,010.0 .0 0
3 REDO02 MOUNTED EXTERN 49,152.0
142.0 49,010.0 .0 0
4 REDO03 MOUNTED EXTERN 49,152.0
142.0 49,010.0 .0 0
-------------
------------- -------------
sum 1,487,076.0
829,990.0 657,086.0

SQL> @asm_disk
SP2-0310: unable to open file "asm_disk.sql"
SQL>
SQL> @asm_disk
SP2-0310: unable to open file "asm_disk.sql"
SQL> set lines 1234
col name format a20
col path format a25

select
GROUP_NUMBER,DISK_NUMBER,NAME,MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB
,FREE_MB,PATH,OS_MB from V$ASM_DISK order by GROUP_NUMBER,PATH
/SQL> SQL> SQL> SQL> 2

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST STATE

TOTAL_MB FREE_MB PATH OS_MB
------------ ----------- -------------------- ------- ------------ ------- --------
------------- ------------- ------------------------- ----------
1 0 DG_SUMCPSQA_DATA_000 CACHED MEMBER ONLINE NORMAL
267,924.0 102,012.0 /dev/ndc3vqaicpsdb07_SUMC 267926
0
PSQA1_ASM_data01

1 3 DG_SUMCPSQA_DATA_000 CACHED MEMBER ONLINE NORMAL

267,924.0 101,984.0 /dev/ndc3vqaicpsdb07_SUMC 267926
3
PSQA1_ASM_data02

1 1 DG_SUMCPSQA_DATA_000 CACHED MEMBER ONLINE NORMAL

267,924.0 102,020.0 /dev/ndc3vqaicpsdb07_SUMC 267926
1
PSQA1_ASM_data03

1 2 DG_SUMCPSQA_DATA_000 CACHED MEMBER ONLINE NORMAL

267,924.0 102,040.0 /dev/ndc3vqaicpsdb07_SUMC 267926
2
PSQA1_ASM_data04

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST STATE

TOTAL_MB FREE_MB PATH OS_MB
------------ ----------- -------------------- ------- ------------ ------- --------
------------- ------------- ------------------------- ----------

1 4 DG_SUMCPSQA_DATA_000 CACHED MEMBER ONLINE NORMAL

267,924.0 102,000.0 /dev/ndc3vqaicpsdb07_SUMC 267926
4
PSQA1_ASM_data05

2 0 REDO01_0000 CACHED MEMBER ONLINE NORMAL

49,152.0 49,010.0 /dev/ndc3vqaicpsdb07_SUMC 49152

PSQA1_ASM_redoctl01

3 0 REDO02_0000 CACHED MEMBER ONLINE NORMAL

49,152.0 49,010.0 /dev/ndc3vqaicpsdb07_SUMC 49152

PSQA1_ASM_redoctl02

4 0 REDO03_0000 CACHED MEMBER ONLINE NORMAL

49,152.0 49,010.0 /dev/ndc3vqaicpsdb07_SUMC 49152

GROUP_NUMBER DISK_NUMBER NAME MOUNT_S HEADER_STATU MODE_ST STATE

TOTAL_MB FREE_MB PATH OS_MB
------------ ----------- -------------------- ------- ------------ ------- --------
------------- ------------- ------------------------- ----------

PSQA1_ASM_redoctl03

------------- -------------
sum
1,487,076.0 657,086.0

8 rows selected.

SQL>
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.17.0.0.0
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts >
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts >
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts >
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts >
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > ps -ef |grep pmon
oracle 10027460 1 0 Feb 05 - 8:47 ora_pmon_SUMCPSQA1
oracle 12845456 1 0 Feb 05 - 5:04 asm_pmon_+ASM
[+ASM]@ndc3vqaicpsdb07:/home/oracle/scripts > SUMCPSQA1
ORACLE_SID is set to :- SUMCPSQA1
ORACLE_HOME is set to :- /oracle_19c/oracle/ora_base/Ora19CHome
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts >
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 2 18:26:51 2024

Version 19.20.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> @name
SP2-0310: unable to open file "name.sql"
SQL>
SQL>
SQL>
SQL> set lines 1111 pages 111
col name for a30
col host_name for a24
select
a.name,a.open_mode,a.database_role,a.controlfile_type,a.LOG_MODE,a.SWITCHOVER_STATU
S from v$database a
/
select b.INSTANCE_NUMBER,b.INSTANCE_NAME,b.HOST_NAME,b.STATUS,b.STARTUP_TIME from
gv$instance b
/
select CON_ID,NAME,OPEN_MODE,OPEN_TIME from v$pdbs;SQL> SQL> SQL> 2
NAME OPEN_MODE DATABASE_ROLE CONTROL
LOG_MODE SWITCHOVER_STATUS
------------------------------ -------------------- ---------------- -------
------------ --------------------
SUMCPSQA READ WRITE PRIMARY CURRENT
ARCHIVELOG NOT ALLOWED

SQL> 2
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME STATUS STARTUP_T
--------------- ---------------- ------------------------ ------------ ---------
1 SUMCPSQA1 ndc3vqaicpsdb07 OPEN 05-FEB-24

SQL>

no rows selected

SQL>
SQL>
SQL> show pdbs
SQL>
SQL> @au
Enter value for username:

INST_ID DB User Logon Time Status SESS Program OS

User Terminal Machine Name EVENT MINS
SQL_ID
---------- -------------- -------------- ---------- ------------ ---------------
---------- ------------ --------------- ------------------------------ ----------
-------------
1 SYS 18:26 Dec/02 Active 204,63138 SQLPLUS@NDC3VQA
oracle pts/1 Ndc3vqaicpsdb07 SQL*Net message to 0
fz9y0ru0nsszw

1 row selected.

SQL>
SQL> show pdbs
SQL>
SQL> set pagesize 0
set lines 300
col name for a40
col value for a90
select name,value from v$parameter where name not like '\_%' escape '\' union
(select name,value from v$parameter where substr(name, 0,1) ='_');
create table PARAMETER_SUMCPSQA1_02DEC2024 as (select name,value from v$parameter
where name not like '\_%' escape '\' ) union (select name,value from v$parameter
where substr(name, 0,1) ='_');SQL> SQL> SQL> SQL> DBFIPS_140
FALSE
active_instance_count
adg_account_info_tracking LOCAL
adg_redirect_dml FALSE
allow_global_dblinks FALSE
allow_group_access_to_sga FALSE
allow_rowid_column_type FALSE
approx_for_aggregation FALSE
approx_for_count_distinct FALSE
approx_for_percentile none
aq_tm_processes 1
archive_lag_target 0
asm_diskstring
asm_preferred_read_failure_groups
audit_file_dest /oracle/app/admin/SUMCPSQA1/adump
audit_sys_operations TRUE
audit_syslog_level
audit_trail DB
autotask_max_active_pdbs 2
awr_pdb_autoflush_enabled FALSE
awr_pdb_max_parallel_slaves 10
awr_snapshot_time_offset 0
background_core_dump partial
background_dump_dest
/oracle_19c/oracle/ora_base/Ora19CHome/rdbms/log
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
blockchain_table_max_no_drop
buffer_pool_keep
buffer_pool_recycle
cdb_cluster FALSE
cdb_cluster_name
cell_offload_compaction ADAPTIVE
cell_offload_decryption TRUE
cell_offload_parameters
cell_offload_plan_display AUTO
cell_offload_processing TRUE
cell_offloadgroup_name
circuits
client_result_cache_lag 3000
client_result_cache_size 0
client_statistics_level TYPICAL
clonedb FALSE
clonedb_dir
cluster_database FALSE
cluster_database_instances 1
cluster_interconnects
commit_logging
commit_point_strength 1
commit_wait
commit_write
common_user_prefix C##
compatible 11.2.0.4.0
connection_brokers ((TYPE=DEDICATED)(BROKERS=1)),
((TYPE=EMON)(BROKERS=1))
container_data ALL
containers_parallel_degree 65535
control_file_record_keep_time 7
control_files
+REDO01/sumcpsqa1/controlfile/current.257.970002779,
+REDO02/sumcpsqa1/controlfile/current
.257.970002779,
+REDO03/sumcpsqa1/controlfile/current.257.970002781

control_management_pack_access DIAGNOSTIC+TUNING
core_dump_dest
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/cdump
cpu_count 32
cpu_min_count 32
create_bitmap_area_size 8388608
create_stored_outlines
cursor_bind_capture_destination memory+disk
cursor_invalidation IMMEDIATE
cursor_sharing EXACT
cursor_space_for_time FALSE
data_guard_max_io_time 240
data_guard_max_longio_time 240
data_guard_sync_latency 0
data_transfer_cache_size 0
db_16k_cache_size 0
db_2k_cache_size 0
db_32k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_big_table_cache_percent_target 0
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TYPICAL
db_block_size 8192
db_cache_advice ON
db_cache_size 0
db_create_file_dest
db_create_online_log_dest_1
db_create_online_log_dest_2
db_create_online_log_dest_3
db_create_online_log_dest_4
db_create_online_log_dest_5
db_domain
db_file_multiblock_read_count 128
db_file_name_convert
db_files 200
db_flash_cache_file
db_flash_cache_size 0
db_flashback_retention_target 1440
db_index_compression_inheritance NONE
db_keep_cache_size 0
db_lost_write_protect NONE
db_name SUMCPSQA
db_performance_profile
db_recovery_file_dest +DG_SUMCPSQA_DATA
db_recovery_file_dest_size 107374182400
db_recycle_cache_size 0
db_securefile PERMITTED
db_ultra_safe OFF
db_unique_name SUMCPSQA1
db_unrecoverable_scn_tracking TRUE
db_writer_processes 4
dbwr_io_slaves 0
ddl_lock_timeout 0
default_sharing metadata
deferred_segment_creation TRUE
dg_broker_config_file1
/oracle_19c/oracle/ora_base/Ora19CHome/dbs/dr1SUMCPSQA1.dat
dg_broker_config_file2
/oracle_19c/oracle/ora_base/Ora19CHome/dbs/dr2SUMCPSQA1.dat
dg_broker_start FALSE
diagnostic_dest /oracle/app
disable_pdb_feature 0
disk_asynch_io TRUE
dispatchers (PROTOCOL=TCP) (SERVICE=SUMCPSQA1XDB)
distributed_lock_timeout 60
dml_locks 3520
dnfs_batch_size 4096
drcp_dedicated_opt YES
dst_upgrade_insert_conv TRUE
enable_automatic_maintenance_pdb TRUE
enable_ddl_logging FALSE
enable_dnfs_dispatcher FALSE
enable_goldengate_replication FALSE
enable_imc_with_mira FALSE
enable_pluggable_database FALSE
enabled_PDBs_on_standby *
encrypt_new_tablespaces CLOUD_ONLY
event
external_keystore_credential_location
fal_client
fal_server
fast_start_io_target 0
fast_start_mttr_target 0
fast_start_parallel_rollback LOW
file_mapping FALSE
fileio_network_adapters
filesystemio_options asynch
fixed_date
forward_listener
gcs_server_processes 0
global_names FALSE
global_txn_processes 1
hash_area_size 131072
heat_map OFF
hi_shared_memory_address 0
hs_autoregister TRUE
http_proxy
identity_provider_config
identity_provider_type NONE
ifile
ignore_session_set_param_errors
inmemory_adg_enabled TRUE
inmemory_automatic_level OFF
inmemory_clause_default
inmemory_expressions_usage ENABLE
inmemory_force DEFAULT
inmemory_max_populate_servers 0
inmemory_optimized_arithmetic DISABLE
inmemory_prefer_xmem_memcompress
inmemory_prefer_xmem_priority
inmemory_query ENABLE
inmemory_size 0
inmemory_trickle_repopulate_servers_perc 1
ent

inmemory_virtual_columns MANUAL
inmemory_xmem_size 0
instance_abort_delay_time 0
instance_groups
instance_mode READ-WRITE
instance_name SUMCPSQA1
instance_number 0
instance_type RDBMS
instant_restore FALSE
java_jit_enabled TRUE
java_max_sessionspace_size 0
java_pool_size 0
java_restrict none
java_soft_sessionspace_limit 0
job_queue_processes 200
large_pool_size 0
ldap_directory_access NONE
ldap_directory_sysauth no
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
listener_networks
lob_signature_enable FALSE
local_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=10.94.134.74)(PORT=1526)))
lock_name_space
lock_sga FALSE
log_archive_config
log_archive_dest
log_archive_dest_1 LOCATION=/archive
log_archive_dest_10
log_archive_dest_11
log_archive_dest_12
log_archive_dest_13
log_archive_dest_14
log_archive_dest_15
log_archive_dest_16
log_archive_dest_17
log_archive_dest_18
log_archive_dest_19
log_archive_dest_2
log_archive_dest_20
log_archive_dest_21
log_archive_dest_22
log_archive_dest_23
log_archive_dest_24
log_archive_dest_25
log_archive_dest_26
log_archive_dest_27
log_archive_dest_28
log_archive_dest_29
log_archive_dest_3
log_archive_dest_30
log_archive_dest_31
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_state_1 enable
log_archive_dest_state_10 enable
log_archive_dest_state_11 enable
log_archive_dest_state_12 enable
log_archive_dest_state_13 enable
log_archive_dest_state_14 enable
log_archive_dest_state_15 enable
log_archive_dest_state_16 enable
log_archive_dest_state_17 enable
log_archive_dest_state_18 enable
log_archive_dest_state_19 enable
log_archive_dest_state_2 enable
log_archive_dest_state_20 enable
log_archive_dest_state_21 enable
log_archive_dest_state_22 enable
log_archive_dest_state_23 enable
log_archive_dest_state_24 enable
log_archive_dest_state_25 enable
log_archive_dest_state_26 enable
log_archive_dest_state_27 enable
log_archive_dest_state_28 enable
log_archive_dest_state_29 enable
log_archive_dest_state_3 enable
log_archive_dest_state_30 enable
log_archive_dest_state_31 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_dest_state_6 enable
log_archive_dest_state_7 enable
log_archive_dest_state_8 enable
log_archive_dest_state_9 enable
log_archive_duplex_dest
log_archive_format %t_%s_%r.dbf
log_archive_max_processes 4
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_archive_trace 0
log_buffer 23601152
log_checkpoint_interval 0
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
long_module_action FALSE
max_auth_servers 25
max_datapump_jobs_per_pdb 100
max_datapump_parallel_per_job 50
max_dispatchers
max_dump_file_size unlimited
max_idle_blocker_time 0
max_idle_time 0
max_iops 0
max_mbps 0
max_pdbs 254
max_shared_servers
max_string_size STANDARD
memoptimize_pool_size 0
memory_max_target 0
memory_target 0
min_auth_servers 1
multishard_query_data_consistency strong
multishard_query_partial_results not allowed
nls_calendar
nls_comp BINARY
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantics BYTE
nls_nchar_conv_excp FALSE
nls_numeric_characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
noncdb_compatible FALSE
object_cache_max_size_percent 10
object_cache_optimal_size 10240000
ofs_threads 4
olap_page_pool_size 0
one_step_plugin_for_pdb_with_tde FALSE
open_cursors 300
open_links 4
open_links_per_instance 4
optimizer_adaptive_plans TRUE
optimizer_adaptive_reporting_only FALSE
optimizer_adaptive_statistics FALSE
optimizer_capture_sql_plan_baselines FALSE
optimizer_dynamic_sampling 2
optimizer_features_enable 19.1.0
optimizer_ignore_hints FALSE
optimizer_ignore_parallel_hints FALSE
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_inmemory_aware TRUE
optimizer_mode ALL_ROWS
optimizer_real_time_statistics FALSE
optimizer_secure_view_merging TRUE
optimizer_session_type NORMAL
optimizer_use_invisible_indexes FALSE
optimizer_use_pending_statistics FALSE
optimizer_use_sql_plan_baselines TRUE
os_authent_prefix ops$
os_roles FALSE
outbound_dblink_protocols ALL
parallel_adaptive_multi_user FALSE
parallel_degree_limit CPU
parallel_degree_policy MANUAL
parallel_execution_message_size 16384
parallel_force_local FALSE
parallel_instance_group
parallel_max_servers 200
parallel_min_degree 1
parallel_min_percent 0
parallel_min_servers 64
parallel_min_time_threshold AUTO
parallel_servers_target 200
parallel_threads_per_cpu 1
pdb_file_name_convert
pdb_lockdown
pdb_os_credential
pdb_template
permit_92_wrap_format TRUE
pga_aggregate_limit 5242880000
pga_aggregate_target 2621440000
plscope_settings IDENTIFIERS:NONE
plsql_ccflags
plsql_code_type INTERPRETED
plsql_debug FALSE
plsql_optimize_level 2
plsql_v2_compatibility FALSE
plsql_warnings DISABLE:ALL
pre_page_sga TRUE
private_temp_table_prefix ORA$PTT_
processes 500
processor_group_name
query_rewrite_enabled TRUE
query_rewrite_integrity enforced
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
recyclebin on
redo_transport_user
remote_dependencies_mode TIMESTAMP
remote_listener
remote_login_passwordfile EXCLUSIVE
remote_os_authent FALSE
remote_os_roles FALSE
remote_recovery_file_dest
replication_dependency_tracking TRUE
resource_limit TRUE
resource_manage_goldengate FALSE
resource_manager_cpu_allocation 0
resource_manager_plan
result_cache_max_result 5
result_cache_max_size 39354368
result_cache_mode MANUAL
result_cache_remote_expiration 0
resumable_timeout 0
rollback_segments
scheduler_follow_pdbtz FALSE
sec_case_sensitive_logon TRUE
sec_max_failed_login_attempts 5
sec_protocol_error_further_action (DROP,3)
sec_protocol_error_trace_action LOG
sec_return_server_release_banner FALSE
serial_reuse disable
service_names SUMCPSQA1
session_cached_cursors 50
session_max_open_files 10
sessions 800
sga_max_size 7868514304
sga_min_size 0
sga_target 7868514304
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 64592281
shared_pool_size 0
shared_server_sessions
shared_servers 1
shrd_dupl_table_refresh_rate 60
skip_unusable_indexes TRUE
smtp_out_server
sort_area_retained_size 0
sort_area_size 65536
spatial_vector_acceleration FALSE
spfile
+DG_SUMCPSQA_DATA/SUMCPSQA1/PARAMETERFILE/spfile.294.1150370657
sql92_security TRUE
sql_trace FALSE
sqltune_category DEFAULT
ssl_wallet
standby_db_preserve_states NONE
standby_file_management MANUAL
standby_pdb_source_file_dblink
standby_pdb_source_file_directory
star_transformation_enabled FALSE
statistics_level TYPICAL
streams_pool_size 0
tablespace_encryption MANUAL_ENABLE
tape_asynch_io TRUE
target_pdbs 0
tde_configuration
temp_undo_enabled FALSE
thread 0
threaded_execution FALSE
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifier
transactions 880
transactions_per_rollback_segment 5
undo_management AUTO
undo_retention 900
undo_tablespace UNDOTBS1
unified_audit_common_systemlog
unified_audit_sga_queue_size 1048576
unified_audit_systemlog
uniform_log_timestamp_format TRUE
use_dedicated_broker FALSE
use_large_pages TRUE
use_sigio TRUE
user_dump_dest
/oracle_19c/oracle/ora_base/Ora19CHome/rdbms/log
wallet_root
workarea_size_policy AUTO
xml_db_events enable
xml_handling_of_invalid_chars raise_error

458 rows selected.

SQL>

Table created.

SQL>
SQL>
SQL> show parameter spfile
spfile string +DG_SUMCPSQA_DATA/SUMCPSQA1/PA
RAMETERFILE/spfile.294.1150370
 657
SQL>
SQL>
eSQL> xit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.20.0.0.0
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > df -gt
Filesystem GB blocks Used Free %Used Mounted on
/dev/hd4 5.00 0.75 4.25 15% /
/dev/hd2 10.00 4.95 5.05 50% /usr
/dev/hd9var 10.00 1.87 8.13 19% /var
/dev/hd3 15.00 1.36 13.64 10% /tmp
/dev/hd1 5.00 0.11 4.89 3% /home
/dev/hd11admin 0.50 0.00 0.50 1% /admin
/proc - - - - /proc
/dev/hd10opt 5.00 1.64 3.36 33% /opt
/dev/livedump 0.50 0.00 0.50 1% /var/adm/ras/livedump
/dev/openv_lv 15.00 0.00 15.00 1% /usr/openv
/dev/Grid12c_lv 100.00 34.54 65.46 35% /Grid_12c
/dev/oracle_lv 100.00 35.82 64.18 36% /oracle
/dev/oracleadmdmp 100.00 50.14 49.86 51% /oracleadmindump
/dev/archive_lv 200.00 191.56 8.44 96% /archive
/dev/agent13c_lv 10.00 0.04 9.96 1% /agent13c
/dev/grid_19c_lv 149.00 34.94 114.06 24% /grid_19c
/dev/oracle_19c_lv 149.00 46.35 102.65 32% /oracle_19c
[SUMCPSQA1]@ndc3vqaicpsdb07:/home/oracle/scripts > cd /oracle
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle > mkdir db_down_art
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle > cd db_down_art
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art > pwd
/oracle/db_down_art
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art > sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 2 18:28:27 2024

Version 19.20.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.20.0.0.0

SQL> show parameter spfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string +DG_SUMCPSQA_DATA/SUMCPSQA1/PA
RAMETERFILE/spfile.294.1150370
657
SQL> create pfile='/oracle/db_down_art/init_TDCRS2bkp.ora' from spfile;

File created.

SQL>
SQL> show parameter control

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +REDO01/sumcpsqa1/controlfile/
current.257.970002779, +REDO02
/sumcpsqa1/controlfile/current
.257.970002779, +REDO03/sumcps
qa1/controlfile/current.257.97
0002781
control_management_pack_access string DIAGNOSTIC+TUNING
SQL> alter database backup controlfile to trace as
'/oracle/db_down_art/SUMCPSQA1_trace_bkp1.ctl';

Database altered.

SQL>
SQL> show parameter disp

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
cell_offload_plan_display string AUTO
dispatchers string (PROTOCOL=TCP) (SERVICE=SUMCPS
QA1XDB)
enable_dnfs_dispatcher boolean FALSE
max_dispatchers integer
SQL>

SQL> SQL> show parameter shared_server

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
max_shared_servers integer
shared_server_sessions integer
shared_servers integer 1
SQL>
SQL>

SQL> SQL>

SQL> SQL> show parameetr back

SP2-0158: unknown SHOW option "parameetr"
SP2-0158: unknown SHOW option "back"
SQL> show parameter back

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle_19c/oracle/ora_base/Or
a19CHome/rdbms/log
backup_tape_io_slaves boolean FALSE
db_flashback_retention_target integer 1440
fast_start_parallel_rollback string LOW
rollback_segments string
transactions_per_rollback_segment integer 5
SQL> select * from v$diag_info;

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------
1 Diag Enabled
TRUE
0

1 ADR Base
/oracle/app
0

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------

1 ADR Home
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1
0

1 Diag Trace
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/trace

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------
0

1 Diag Alert
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/alert
0

1 Diag Incident

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/incident
0

1 Diag Cdump
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/cdump
0

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------
1 Health Monitor
/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/hm
 0

1 Default Trace File

/oracle/app/diag/rdbms/sumcpsqa1/SUMCPSQA1/trace/SUMCPSQA1_ora_10551634.trc
0

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------

1 Active Problem Count

1
0

1 Active Incident Count

1

INST_ID NAME
---------- ----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
CON_ID
----------
0

1 ORACLE_HOME
/oracle_19c/oracle/ora_base/Ora19CHome
0

12 rows selected.

SQL>
SQL>
SQL> pool SUMCPSQA11.txt

select name,open_mode from v$database;

select count(*) from dba_objects where status<>'VALID';

select owner,OBJECT_TYPE,count(*) from dba_objects where status<>'VALID' group by

owner,OBJECT_TYPE order by 1;

select status,count(*) from dba_indexes group by status;

select status,count(*) from dba_ind_partitions group by status;

select count(*) from dba_objects where status='INVALID';

create table sys.SUMCPSQA11011_2 as select * from dba_objects where

status='INVALID';

select OWNER,INDEX_NAME,TABLE_OWNER,TABLE_NAME from dba_indexes where

status='UNUSABLE';

select INDEX_OWNER,INDEX_NAME,PARTITION_NAME from dba_ind_partitions where

STATUS='UNUSABLE';
SP2-0734: unknown command beginning "pool SUMCP..." - rest of line ignored.
SQL> SQL>
NAME OPEN_MODE
--------- --------------------
SUMCPSQA READ WRITE

SQL> SQL>
COUNT(*)
----------
1281

SQL> SQL>
OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
ARYANISINGH
PACKAGE BODY 1

SUMERU_CRS
FUNCTION 17

SUMERU_CRS
MATERIALIZED VIEW 4

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_CRS
PACKAGE 1

SUMERU_CRS
PACKAGE BODY 19

SUMERU_CRS
PROCEDURE 335

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_CRS
TRIGGER 3

SUMERU_CRS
TYPE 1

SUMERU_CRS
VIEW 7

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_PRIM
FUNCTION 14

SUMERU_PRIM
MATERIALIZED VIEW 5

SUMERU_PRIM
PACKAGE 3

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_PRIM
PACKAGE BODY 41

SUMERU_PRIM
PROCEDURE 370

SUMERU_PRIM
VIEW 3

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_REPORTS
FUNCTION 8

SUMERU_REPORTS
PACKAGE 14

SUMERU_REPORTS
PACKAGE BODY 22

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_REPORTS
PROCEDURE 205

SUMERU_REPORTS
VIEW 9

SUMERU_SEC
FUNCTION 5

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_SEC
MATERIALIZED VIEW 13
SUMERU_SEC
PACKAGE 2

SUMERU_SEC
PACKAGE BODY 16

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_SEC
PROCEDURE 148

SUMERU_SEC
SYNONYM 2

SUMERU_SEC
TYPE 1

OWNER
--------------------------------------------------------------------------------
OBJECT_TYPE COUNT(*)
----------------------- ----------
SUMERU_SEC
VIEW 12

28 rows selected.

SQL> SQL>

STATUS COUNT(*)
-------- ----------
N/A 555
VALID 10689

SQL> SQL>
STATUS COUNT(*)
-------- ----------
USABLE 10220
N/A 335

SQL> SQL>
COUNT(*)
----------
1281

SQL> SQL>
Table created.

SQL> SQL>

no rows selected

SQL> SQL>
no rows selected
SQL> SQL> SQL>
SQL>
SQL>
SQL>

eSQL> SQL> xit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.20.0.0.0
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art >
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art > ps -ef |grep pmon
oracle 10027460 1 0 Feb 05 - 8:47 ora_pmon_SUMCPSQA1
oracle 12845456 1 0 Feb 05 - 5:04 asm_pmon_+ASM
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art > asm
ksh: asm: not found.
[SUMCPSQA1]@ndc3vqaicpsdb07:/oracle/db_down_art > ASM
ORACLE_SID is set to :- +ASM
ORACLE_HOME is set to :- /grid_19c/oracle/Grid19CHome
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art >
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art >
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art > sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 2 18:29:58 2024

Version 19.17.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> show parameter spfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------
spfile string +DG_SUMCPSQA_DATA/ASM/ASMPARAM
ETERFILE/registry.253.96849729
5
SQL> create pfile='/oracle/db_down_art/init_SUMCPSQA1_ASM1.ora' from spfile;

File created.

SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
Production
Version 19.17.0.0.0
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art > ps -ef |grep pmon
oracle 10027460 1 0 Feb 05 - 8:47 ora_pmon_SUMCPSQA1
oracle 12845456 1 0 Feb 05 - 5:04 asm_pmon_+ASM
oracle 23658862 9306612 0 18:30:15 pts/1 0:00 grep pmon
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art > ps -ef |grep d.bin
oracle 8257926 1 0 Feb 05 - 298:39
/grid_19c/oracle/Grid19CHome/bin/ohasd.bin reboot
oracle 10944852 1 0 Feb 05 - 156:56
/grid_19c/oracle/Grid19CHome/bin/evmd.bin
oracle 12517668 1 0 Feb 05 - 177:01
/grid_19c/oracle/Grid19CHome/bin/ocssd.bin
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art >
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art >
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art >
[+ASM]@ndc3vqaicpsdb07:/oracle/db_down_art > exit