One of things that is convenient is to setup aliases for commands and navigation for your Oracle systems
when the .profile executes it executes two additional files
.profile_env
.std_profile
here are some of the components in the .std_profile
Keep in mind the ORACLE_HOME needs to be set in the /etc/oratab prior to executing the profiles
Setting up Aliases
ob= Oracle base
oh= Oracle home
dba= Oracle base dba scripts
loc='cd $ORACLE_BASE/dba/local'
std='cd $ORACLE_BASE/dba/standard'
stage='cd $ORACLE_BASE/dba/stage'
gen='cd $DBA_OUTPUT/generic'
adm='cd $ADMIN'
admscr='cd /opt/oracle/admin/scripts'
tmplt='cd /u01/app/oracle/product/12.2.0/db_1/assistants/dbca/templates'
rspdir='cd /opt/oracle/scripts/rspfiles'
net='cd $ORACLE_HOME/network/admin'
onet='cd $ORACLE_HOME/network/admin'
dfiles='cd /u01/app/oracle/oradata/TEST'
# alias fog='cd $FOG'
# alias foglight='cd $FOG'
Test post
Oracle SQL Plan Management
One of the ways to migrate a database to ASM is to use the Rman “Backup as Copy” command to create a database copy into ASM storage and then switch the database to the copy.
This technique can be used, combined with incremental backups, to move even very large databases into ASM.
The first backup may take a long time, one or more incremental backups can be used to update the first backup and close the gap, until a downtime window is obtained to switch the database on filesystem to the backup on ASM.
Migrating a Database Into ASM
Backup Database Into ASM
Spfile Backup into ASM
Consistent database shutdown
Prepare Pfile for the ASM Database
Start the database in NOMOUNT mode
Change Parameters on Spfile to point to ASM
Move the controlfiles into ASM
Switch the Database from File System to ASM
Recover The Database
Migrate the Temporary Datafiles to ASM
Move Flashback logs into flash recovery Area
Move RMAN Change Tracking File Into ASM
Remove the File System Old Files
Remove the Old Spfile from Filesystem
Scripts
#!/bin/ksh # # Michael Culp # Schema for the database relationship # DBA01 Schema is for the DBAdmin App to be built # ################################################################################ sqlplus -s "/ as sysdba" <<EOF set serveroutput on size 1000000 set timing on; drop user dba01 cascade; create user dba01 identified by password default tablespace users; grant dba to dba01; grant resource to dba01; -- drop table dba01.server; -- create table dba01.server ( -- domain varchar2(50), -- hostname varchar2(100), -- database varchar2(200), -- env varchar2(15), -- aitno varchar2(20), -- app varchar2(35), -- rdbmsver varchar2(50), -- prim_dba varchar2(50) -- ) -- tablespace brain_tbs; DROP USER HC_CORE CASCADE; CREATE USER HC_CORE IDENTIFIED BY password DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 1 System Privilege for HC_CORE GRANT CREATE SESSION TO HC_CORE; -- 20 Object Privileges for HC_CORE -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_BACKUP TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DATABASE TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_COMP TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_FRA TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_INIT_PARAM TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_INVLD_OBJECTS TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_OH_PATCHES TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_PATCHES TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_SPACE_USAGE TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_STANDBY_DEST TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_STANDBY_STATUS TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_DB_TAB TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_INSTANCE TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_JOB_RUN TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_MACHINE TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_RMAN_BACKUP TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_STORAGE TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_SYSCTL_CONF TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_TBSPC TO HC_CORE; -- GRANT DELETE, INSERT, SELECT, UPDATE ON DBA01.HC_TBSPC_DATAFILE TO HC_CORE; EOF
# the following completed using the instructions in this article # https://oracle-base.com/articles/12c/weblogic-development-only-installation-on-oracle-linux-5-and-6-1211 # author : susheel tamrakar ; April 2016 # MW_HOME=/oracle/product/11.2.0/db_1; export MW_HOME WLS_HOME=$MW_HOME/wlserver; export WLS_HOME JAVA_HOME=/oracle/product/11.2.0/db_1/jdk18; export JAVA_HOME PATH=$JAVA_HOME/bin:$PATH; export PATH # JDK 7 Requirement USER_MEM_ARGS="-Xms32m -Xmx200m -XX:MaxPermSize=350m" # # Stop WebLogic /ora01/app/oracle/mydomain/bin/stopWebLogic.sh # or # ps -ef|grep weblogic and kill the pid for weblog