Scribd
Upload
40 views5 pages

Booti

The document provides instructions for various tasks like configuring serial ports, running diagnostic tools on Exalogic and Exadata, taking iLOM snapshots, clearing fault logs, using dcli and other commands. It also includes steps for resizing file systems, checking the database, setting passwords to never expire, finding and configuring virtual machines on Exalogic, and importing and exporting data using Oracle Data Pump.

Uploaded by

Talal Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
40 views5 pages

Booti

The document provides instructions for various tasks like configuring serial ports, running diagnostic tools on Exalogic and Exadata, taking iLOM snapshots, clearing fault logs, using dcli and other commands. It also includes steps for resizing file systems, checking the database, setting passwords to never expire, finding and configuring virtual machines on Exalogic, and importing and exporting data using Oracle Data Pump.

Uploaded by

Talal Ahmed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 5

Serial Display On the node's SP:

-> set /SP/serial/external pendingspeed=115200


-> set /SP/serial/external commitpending=true

-> set /SP/serial/host pendingspeed=115200


-> set /SP/serial/host commitpending=true
------------------------------------------------------
exachk -Exalogic
-----------------
login 172.18.30.5
[root@pia-elctl ~]# ./exachk -a

exachk -Exadata
----------------
login 172.18.30.51
[root@pia-xddbadm01 ~]# cd /opt/oracle.ahf/exachk/
[root@pia-xddbadm01 exachk]# ./exachk -a
[root@pia-xddbadm01 exachk]# cd
/u01/app/oracle/oracle.ahf/data/pia-xddbadm01/exachk/user_root/output/

iLOM snapshot cli


-----------------
-> show /sp/logs/event/list

-> set /SP/diag/snapshot dataset=normal


-> set /SP/diag/snapshot encrypt_output=false
-> set /SP/diag/snapshot dump_uri=sftp://root@192.168.19.7/tmp
-> show /SP/diag/snapshot

iLOM access from OS prompt


--------------------------
[root@pia-xddbadm02 tmp]# ipmitool sunoem cli
^D

iLOM clear fault logs


---------------------
-> set /SYS clear_fault_action=true
-> start /SYS
-> start /SP/console
ESC (

dcli
=====
pia-el01cn01
------------
[root@pia-el01cn01 ~]# ./dcli -g cnodes date
[root@pia-el01cn01 ~]# ./dcli -g nodes date
[root@pia-el01cn01 ~]# /opt/exalogic.tools/tools/dcli -g nodes df -h

[root@pia-xddbadm01 ~]# dcli -g db_group date


[root@pia-xddbadm01 ~]# dcli -g cell_group date

Cellnode
---------
cellcli -e list griddisk attributes name, asmmodestatus
Resize Exadata file system (root)
---------------------------------
pvs
vgdisplay -s
lvs -o lv_name,lv_path,vg_name,lv_size
lvextend -L +10G /dev/VGExaDb/LVDbSys1
resize2fs /dev/VGExaDb/LVDbSys1

ckdb
-----
# cd /u01/app/19.0.0.0/grid/bin/
# ./crsctl start crs
# ./crsctl start cluster -all
# ./crsctl status server
# ./crsctl status resource -t
# ./crsctl check crs
# ps -ef|grep pmon
# ps -ef|grep lsnr

su - oracle
. oraenv
$ echo $ORACLE_SID
PIAXDPD1
$ srvctl status database -d piaxdpd
$ lsnrctl start $ORACLE_SID
$ lsnrctl status piaxdpd1
$ lsnrctl status piaxdpd2
$ tnsping piaxdpd1
$ tnsping piaxdpd2

SR TFA
--
cd /opt/oracle.ahf/tfa/bin/
./tfactl diagcollect -from "2023-10-27 09:38:00" -to "2023-10-27 15:00:00" -or-
tfactl diagcollect -srdc dbasm -from "2029-09-20 07:15:00" to "2029-09-20
10:15:00"
check tablespace size
*******************SR**
# crsctl config crs
# crsctl stop crs -f
# crsctl start crs -wait
***********************
----------------------
select df.tablespace_name "Tablespace",
nvl(totalusedspace,0) "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name (+)
order by 4 desc
/

set date & time (linux)


------------------------
date +%T -s "17:28:00"
date +%Y%m%d -s "20230417"
date -s '2023-10-25 13:33:00'

set password never expire


----------------------------
chage -I -1 -m 0 -M 99999 -E -1 mroerp
*****
[root@pia-xddbadm01 ~]# chage -l mroerp
Last password change : May 24, 2023
Password expires : Jul 23, 2023
Password inactive : never
Account expires : never
Minimum number of days between password change : 1
Maximum number of days between password change : 60
Number of days of warning before password expires : 7
[root@pia-xddbadm01 ~]# chage -I -1 -m 0 -M 99999 -E -1 mroerp
[root@pia-xddbadm01 ~]# chage -l mroerp
Last password change : May 24, 2023
Password expires : never
Password inactive : never
Account expires : never
Minimum number of days between password change : 0
Maximum number of days between password change : 99999
Number of days of warning before password expires : 7

*****
rm one day older files in unix
----------------------------------
find /usr/tmp/* -type f -mtime +0 -exec du -sh {} \;
cd /usr/tmp
find . -type f -mtime +0 -exec rm -f {} \;

find VM path and create vServer (exalogic)


------------------------------------------
/exalogic-lctools/bin/exapatch -a listVMs
find /OVS -wholename '*VirtualMachines/*/vm.cfg' -exec grep -H 'simple_' {} \;|grep
testnmk
xm create -c /OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb00000600005d98375d32dbee10/vm.cfg

iLOM from OS
--------------
#ipmitool sunoem cli
^D

ibswitch
--------
getmaster

**************************************vlan***********************
.20 r/Y%y9@J76^hk0P%t&o/IP$%f7J4Il714
.5153 r/IP$%f7J4Il714o/Y%y9@J76^hk0P%t&
vServers.r/34rr@91204
*****************************************************************
Error: cannot access using putty/ping
-----
{pia-el01cn01}
# /exalogic-lctools/bin/exapatch -a listVMs
# xm list
# xm con 1
{testnmk}
-- # /sbin/ifconfig
# ifconfig
~
bond1 Link encap:Ethernet HWaddr 00:00:00:00:00:00 --Error
inet addr:172.18.50.37 Bcast:172.18.50.255 Mask:255.255.255.0
~
{pia-el01cn01}
# find /OVS -wholename '*VirtualMachines/*/vm.cfg' -exec grep -H 'simple_' {} \;|
grep testnmk
# more /OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb00000600005d98375d32dbee10/vm.cfg
~
exalogic_vnic = "[{'connectors': ['1A-ETH-4'], 'vlan': ['908'], 'port': '1',
'macAddrs': ['00:14:4F:F9:FE:C6'], 'guid': '0x42b05924024ec484', 'pkey':
['0x8008']},
{'connectors': ['1A-ETH-4'], 'vlan': ['908'], 'port': '2',
'macAddrs': ['00:14:4F:F8:18:85'], 'guid': '0x42b05924024ec485', 'pkey':
['0x8008']}
]"
~
{pia-el01gw01}
createvnic 1A-ETH-4 -GUID 0x42b05924024ec484 -mac 00:14:4F:F9:FE:C6 -vlan 908
vNIC created
{pia-el01gw02}
createvnic 1A-ETH-4 -GUID 0x42b05924024ec485 -mac 00:14:4F:F8:18:85 -vlan 908
vNIC created
{pia-el01cn01}
# xm shutdown 1
# xm list
# xm create -c /OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb00000600005d98375d32dbee10/vm.cfg

----------------------23nov23---------------
----------------------23nov23---------------
vserptest
Or@cle@39
-------------
{pia-el01cn02}
# find /OVS -wholename '*VirtualMachines/*/vm.cfg' -exec grep -H 'simple_' {} \;|
grep vserptest
/OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb000006000032ba3af2167ff8d2/vm.cfg:OVM_simple_name = 'vserptest01'

# more /OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb000006000032ba3af2167ff8d2/vm.cfg

[root@pia-el01cn02 ~]# xm list


Name ID Mem VCPUs State Time(s)
0004fb000006000032ba3af2167ff8d2 10 51200 10 -b---- 378.7

exalogic_vnic = "[{'connectors': ['0A-ETH-2'], 'vlan': ['908'], 'port': '1',


'macAddrs': ['00:14:4F:F9:FC:9C'], 'guid': '0x79757c74034c9893', 'pkey':
['0x8008']},
{'connectors': ['0A-ETH-2'], 'vlan': ['908'], 'port': '2',
'macAddrs': ['00:14:4F:FB:5B:7E'], 'guid': '0x79757c74034c9894', 'pkey':
['0x8008']}]"

***************************
{pia-el01gw01}
createvnic 0A-ETH-2 -GUID 0x79757c74034c9893 -mac 00:14:4F:F9:FC:9C -vlan 908
{pia-el01gw02}
createvnic 0A-ETH-2 -GUID 0x79757c74034c9894 -mac 00:14:4F:FB:5B:7E -vlan 908

xm create -c /OVS/Repositories/0004fb0000030000639f382b1500dc77/VirtualMachines/
0004fb000006000032ba3af2167ff8d2/vm.cfg
--------------------------------------------------
--------------------------------------------------
[oracle@vserptest ~]$ ifconfig
bond0 Link encap:Ethernet HWaddr 00:00:00:00:00:00
inet addr:172.18.50.39 Bcast:172.18.50.255 Mask:255.255.255.0
UP BROADCAST MASTER MULTICAST MTU:1500 Metric:1
RX packets:0 errors:0 dropped:0 overruns:0 frame:0
TX packets:0 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

*******************************************************************
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/expdp bkmgr/bkmgr directory=ibmbk_dir
dumpfile=revenue_argdata_p_2024_dp parallel=2 TABLES=revenue.ARGLDATA:Y2024
. . exported "REVENUE"."ARGLDATA":"Y2023" 18.13 GB 96679066 rows

/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/expdp bkmgr/bkmg schemas=revenue


directory=ibmbk_dir dumpfile=revenue_argdata_dp parallel=2
include=table:\"=\'ARGLDATA\'\"
---------------------------------------
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/expdp bkmgr/bkmgr
directory=ibmbk_dir dumpfile=popis_lvtrans.dmp TABLES=popismf.lvtrans

/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/impdp apps/apS8bRR3nmp6
directory=DATA_PUMP_DIR dumpfile=popis_lvtrans.dmp TABLES=popismf.lvtrans
REMAP_SCHEMA=popismf:apps REMAP_TABLESPACE=users:APPS_TS_TX_DATA

You might also like