Oracle basics

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

#######################
###  STUFF
#######################

# Get a list of SIDs
 cat /etc/oratab
 ps -ef | grep pmon

# tnsnames.ora here->
cd /usr/local/oracle/product/12.1.0/dbhome_1/network/admin/

# Common queries
SELECT owner, table_name FROM dba_tables;
SELECT owner, table_name FROM all_tables;
SELECT table_name FROM user_tables;

# Testing
sqlplus x7_proxy[x7]/Fsoc1etyDevpr0xy@dbn-02sc8:1522/PTR2

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

# Fsociety sqlplus
cd ./sql/xddw/xdis/patches/
echo exit | sqlplus xddw_deployment[xddw]/Fsoc1etyAuDevdepl0y@stg1aus @xdis-patch-20181002-grants.sql
echo exit | sqlplus xddw_deployment[xddw]/Fsoc1etyEurDevdepl0y@stg3eur @xdis-patch-20181002-grants.sql


cd ./sql/xmm/patches/
echo exit | sqlplus xmm_deployment[xmm]/Fsoc1etyAuDevdepl0y@stg1aus @xmm-patch-20181002-add-constraints.sql
echo exit | sqlplus xmm_deployment[xmm]/Fsoc1etyEurDevdepl0y@stg3eur @xmm-patch-20181002-add-constraints.sql


cd ./sql/app/xws/plsql/
echo exit | sqlplus x11_deployment[x11]/Fsoc1etyEurDevdepl0y@stg3eur @SCH_APPOINTMENT.PKB
echo exit | sqlplus x11_deployment[x11]/Fsoc1etyEurDevdepl0y@stg3eur @XDI_VISIT.PKB

echo exit | sqlplus x9_deployment[x9]/Fsoc1etyAuDevdepl0y@stg1aus @SCH_APPOINTMENT.PKB
echo exit | sqlplus x9_deployment[x9]/Fsoc1etyAuDevdepl0y@stg1aus @XDI_VISIT.PKB