Why and How to export using a Data Pump utility?

  Why ?

In oracle database to move a data between systems or duplicate a schema in the same system there are several ways to achieve it. One of the common way to do this data migration and/or duplication you may use the Data Pump utility in the command line of the server and or the client with a full administration client installation. Below I will share a sample scripts that export and import using this utility, for advantage and features of this you may refer back to the oracle documentations, However on of the most important feature is that cross platform can be easily maintains by using this.

How ?

Below are sample script to do export and import using data pump ( dp), you have to create or use a user rather than sys, here I am using a system user and have created a Backup directory in OS/Oracle ,:

1- you may run export and import in one line with all necessary values as below, dmp will have the date and .log is the export/import logs, you may rename the import using REMAP as below example:

expdp system/<password>@<db_tns_name> directory=BACKUP schemas=<schema1>,<schema2> dumpfile=<name>.dmp logfile=<name>.log

impdp system/<password>@<db_tns_name> REMAP_SCHEMA=<old_name>:<new_name>,<old_name2>:<new_name2> directory=BACKUP dumpfile=<name>.dmp logfile=<name>.log

2- Export using parameter file with further export features as below example for certain tables of schame:

vi <parm_name>.par

 

DUMPFILE="<name>.dmp"

LOGFILE="<name>.log"

LOGTIME=NONE

DIRECTORY=BACKUP

FLASHBACK_TIME=SYSTIMESTAMP

COMPRESSION=METADATA_ONLY

CONTENT=ALLCOMPRESSION_ALGORITHM=BASIC

TABLES=('<schema."<table_name1>"', '<schema."<table_name2>"', '<schema>."<>table_name3"')

 

expdp system/<password>@<tns_name> PARFILE= <parm_name>.par

3- Import the export dump as needed.

Why and How to manage disk space quota in Solaris 11?

  Why ?

In Solaris you will have a disk and after that the sub disk will be assigned for a value of space to make sure that total space in disk divided on these sub directories and each take the assigned space from disk only , for example if you 100G and you need to make sure /u01 is only 20G and /u02 takes 80G , set a quota is the soft way , reservation and refquota will do this as well with different properties of each , here I will show only how to do quota.

How ?

Below are simple commands for getting and setting the quota

1- list the disks and it is detail:

zpool list

2- get a list of all list of create directory in the disk as mount point:

df –h

zfs list

3- To get/set specific path quota if any :

# zfs set quota=10G tank/home/jeff

# zfs get quota tank/home/jeff

 

My reference always is : https://docs.oracle.com/cd/E23824_01/html/821-1448/gazvb.html

Why and How to Monitor a Servers in WebLogic using a script?

  Why ?

In WebLogic admin console you can see the list of servers and it is health/state , if you don’t have a monitoring tools that is connected to WebLogic and check these servers ( like OEM with WebLogic pack) you have to write a script to get this status in the file for example. Most monitoring tool will be able to be configured with the file or shell script and report an alert in certain condition.

How ?

Below are steps and a sample code to monitor certain servers in WebLogic, WebLogic script use a jython which mostly like a python programing language, tab is considered in the jython code:

1- Create a shell script .sh file with executing permission to call the WebLogic file and store the result in a text file , this can be run in a crontab for example every 5 minutes to be like an archived logs or appended somewhere in a log file:

#!/bin/bash

now=$(date +%d-%m-%Y_%H-%M)

/oracle/Middleware/Oracle_Home/oracle_common/common/bin/wlst.sh /export/home/oracle/get_wls_serverstate_all.py &>/export/home/oracle/weblogic_status.txt

cp -p /export/home/oracle/weblogic_status.txt /export/home/oracle/archive_weblogic_status/weblogic_status_${now}.txt

2- Create a jython code file to monitor and exclude certain servers as below example:

redirect('/dev/null', 'false')

connect('weblogic','<password>','t3://<serverIP>:7001')

import datetime

servers = cmo.getServers()

domainRuntime()

 

for server in servers:

        if server.getName() not in ["",""]:

                try:

                        cd('/ServerRuntimes/' + server.getName());

                        currentState = get('OverallHealthState').getState()

                        now = datetime.datetime.now()

                        current_time = now.strftime("%d-%b-%y_%H:%M:%S")

                        dump_file = '/export/home/oracle/threadDump/'+current_time+server.getName()+'-ThreadDump.log'

                        if currentState == 0:

                                print server.getName() + ': ' + get('State') + ': HEALTH_OK'

                        elif currentState == 1:

                                try:

                                        threadDump('true',dump_file,server.getName())

                                        messg1 = 'ThreadDump has been generated on:'+dump_file

                                except WLSTException, e:

                                        messg1 = 'Exectpiont occur in threadDump'

                                print server.getName() + ': ' + get('State') + ': HEALTH_WARN :'+messg1

                        elif currentState == 2:

                                try:

                                        threadDump('true',dump_file,server.getName())

                                        messg1 = 'ThreadDump has been generated on:'+dump_file

                                except WLSTException, e:

                                        messg1 = 'Exectpiont occur in threadDump'

                                print server.getName() + ': ' + get('State') + ': HEALTH_CRITICAL :'+messg1

                        elif currentState == 3:

                                try:

                                        threadDump('true',dump_file,server.getName())

                                        messg1 = 'ThreadDump has been generated on:'+dump_file

                                except WLSTException, e:

                                        messg1 = 'Exectpiont occur in threadDump'

                                print server.getName() + ': ' + get('State') + ': HEALTH_FAILED :'+messg1

                        elif currentState == 4:

                                try:

                                        threadDump('true',dump_file,server.getName())

                                        messg1 = 'ThreadDump has been generated on:'+dump_file

                                except WLSTException, e:

                                        messg1 = 'Exectpiont occur in threadDump'

                                print server.getName() + ': ' + get('State') + ': HEALTH_OVERLOADED :'+messg1

                        else:

                                try:

                                        threadDump('true',dump_file,server.getName())

                                        messg1 = 'ThreadDump has been generated on:'+dump_file

                                except WLSTException, e:

                                        messg1 = 'Exectpiont occur in threadDump'

                                print server.getName() + ': ' + get('State') + ': UNKNOWN_HEALTH_STATE (' + str(currentState) + ') :'+messg1

                except WLSTException, e:

                        print server.getName()+': SHUTDOWN: Not_Running'

 

disconnect()

3- To use a crontab for example :

####

#Weblogic status

####

0,5,10,15,20,25,30,35,40,45,55 * * * * /export/home/oracle/check_weblogic_all.sh