Pages

Saturday, June 26, 2021

Thursday, June 24, 2021

Saturday, June 19, 2021

Cloning A Schema

Cloning A Schema

Example:

SQL> @cln_user.sql

Enter user to model new user to: SCOTT -----> Existing User

Enter new user name: MQMTEST -----> New User

Enter new user's password: TEST123! -----> New User Password


create user MQMTEST identified by TEST123! default tablespace USERS temporary tablespace TEMP profile DEFAULT;

grant RESOURCE to MQMTEST;

grant CONNECT to MQMTEST;

grant UNLIMITED TABLESPACE to MQMTEST;

alter user MQMTEST default role RESOURCE;

alter user MQMTEST default role CONNECT;


Cloning_User 




Startup & Shutdown Script

Startup & Shutdown Script

vi start_db.sh
vi stop_db.sh
and save it!


Health Check Script

Health Check Script

Using below script we can database status, lsnrctl status and mountpoint.

vi status.sh

and save!

STATUS

Below Script To Check Alertlog Errors

Below Script To Check Alertlog Errors

vi alert.sh

and save!

ALERT

Friday, June 18, 2021