CREATE [PUBLIC] DATABASE LINK CONNECT TO
IDENTIFIED BY USING '';

This link name is called "test" and uses an ID of jim (on the target database) identified by is the password (jim) using the test which is a connect string

CREATE DATABASE LINK test
CONNECT TO jim IDENTIFIED BY jim
USING 'test';

Service Naming

Naming of the service is a factor of the database name since we will have multiple databases running at the cluster level the service name should named as follows:

<DATABASENAME>_SVC_ZZ

<DATABASENAME> = identifies which database this service is for

_SVC_ = Standard abbreviation for “service”, this is different from previous identifier of SRV which is the abbreviation for “server”.

ZZ = Sequential identifier for multiple services per database optionally we could use a set of characters to identify an application or work stream. Further clarification for the optional used variant is currently being developed and further study is needed for this.

Ex: MRCXX50P01_SVC_01

MRCXXP01_SVC_ ARGRP

Oracle ASM 12c

CRSCTL Reference

sho_stat_lvl()
{
######################################################################
# This will show some interesting stuff from v$statistics_level;
######################################################################

sqlplus -s "/ as sysdba" <

set pages 200
PROMPT
PROMPT Show the statistics level in the database
PROMPT

set lines 120
set pages 66

SELECT statistics_name, activation_level, system_status
FROM v\$statistics_level;

-- spool off

EOF
}

sho_indx()
######################################
# List the indexes
######################################
{

sqlplus -s "/ as sysdba" <
set lines 120
set pages 66

select index_name from dba_indexes
order by index_name;

spool off

EOF
}

This is the library for the pre-install setup for Linux against Oracle
This can have functions for 11g as well as 12c, I decided combine them into one library

Here is a link to Steve Karem's website discussing 12c new features Oracle Alchemist.com

https://www.r-project.org/

AWR Stuff
http://www.askmaclean.com/archives/script-awr-trending.html