Tuesday 31 October 2017

20 Things the Rich Do Every Day


1. 70% of wealthy eat less than 300 junk food calories per day. 97% of poor people eat more than 300 junk food calories per day. 23% of wealthy gamble. 52% of poor people gamble.

2. 80% of wealthy are focused on accomplishing some single goal. Only 12% of the poor do this.

3. 76% of wealthy exercise aerobically four days a week. 23% of poor do this.

4. 63% of wealthy listen to audio books during commute to work vs. 5% of poor people.

5. 81% of wealthy maintain a to-do list vs. 19% of poor.

6. 63% of wealthy parents make their children read two or more non-fiction books a month vs. 3% of poor.

7. 70% of wealthy parents make their children volunteer 10 hours or more a month vs. 3% of poor.

8. 80% of wealthy make Happy Birthday calls vs. 11% of poor.

9. 67% of wealthy write down their goals vs. 17% of poor.

10. 88% of wealthy read 30 minutes or more each day for education or career reasons vs. 2% of poor.

11. 6% of wealthy say what’s on their mind vs. 69% of poor.

12. 79% of wealthy network five hours or more each month vs. 16% of poor.

13. 67% of wealthy watch one hour or less of TV every day vs. 23% of poor.

14. 6% of wealthy watch reality TV vs. 78% of poor.

15. 44% of wealthy wake up three hours before work starts vs. 3% of poor.

16. 74% of wealthy teach good daily success habits to their children vs. 1% of poor.

17. 84% of wealthy believe good habits create opportunity luck vs. 4% of poor.

18. 76% of wealthy believe bad habits create detrimental luck vs. 9% of poor.

19. 86% of wealthy believe in lifelong educational self-improvement vs. 5% of poor.

20. 86% of wealthy love to read vs. 26% of poor.

Friday 13 October 2017

Oracle weblogic server interview questions and answers 12c

WebLogic Server Domain ?

WebLogic is a J2EE application server and also an HTTP web server by Oracle, for Unix, Linux, Microsoft Windows, and other platforms. WebLogic supports Oracle, DB2, Microsoft SQL Server, and other JDBC Compliant databases.

How many types of installation available in weblogic 12c?

Methods of installation?

Weblogic 12c have two types of installation.
1. Interactive using Oracle Universal Installer
2. Silent using Response files


What is a Silent Installation Command?

java -jar fmw_12.1.3.0.0_wls.jar -silent -responseFile /u01/app/wl_install_response.rsp -invPtrLoc /u01/app/silent/createPrivateInventory.txt

$vi createPrivateInventory.txt
inventory_loc=/u01/app/silent/privOraInv.loc
inst_group=oinstall

Wednesday 27 September 2017

Install weblogic server 11g (10.3.6.0) in console mode step by step

Software Certification for WebLogic Server 11g (10.3.6):
=======================================
Oracle JDK 1.7.0.99
Oracle linux 7,6,5,4
Oracle database 12.1.0.2.0, 12.1.0.1.0, 11.2.0.4.0, 11.2.0.3.0
Oracle JRockit  6u37 R28.3+

Install JDK 1.7:
===========
http://netgik.blogspot.in/2017/09/removing-openjdk-and-installing-oracle.html

After installation java command should work on server.


How to install WebLogic server in console mode:
=================================

1. Create a dedicated user to install and run WebLogic Server 11g in Linux. Log in as the root user and create the user and the group named psoft, and define a new password for it:
groupadd psoft
useradd -g psoft weblogic
useradd -g psoft -G oinstall tuxedo
passwd weblogic
Changing password for user weblogic.
New UNIX password: <new password>
Retype new UNIX password: <new password>


Oracle Users and Directory Structure:- (Not required here.. can use if you are installing oracle as well)
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/groupadd oper
/usr/sbin/groupadd grid
/usr/sbin/useradd -g oinstall -G dba,oper oracle
/usr/bin/passwd oracle
mkdir -p /u01/app/oracle/product/11.2.0/client_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app/
su - oracle
mkdir -p /u01/oradata/demodb

Middleware Directory:-
mkdir -p /u02/middleware/tuxedo
mkdir -p /u02/middleware/jrockit
mkdir -p /u02/middleware/weblogic
chgrp -R psoft /u02
chmod -R 775 /u02


Brief Steps:
# su - weblogic
export JAVA_HOME=/usr/java/jdk1.7.0_51/   (Optional - Set java path if not using default installed java)
$JAVA_HOME/bin/java -jar ./wls1036_generic.jar -mode=console -logs=./wls1036_install.log
Create a new Middleware Home ->
Choose Middleware Home Directory = /u02/mw/weblogic
Receive Security Update = No
Select the type of installation you wish to perform. = Typical
JDK Selection (Any * indicates Oracle Supplied VM) = 2|/u02/jrockit [x]
Congratulations! Installation is complete.


Complete Steps:
# su - weblogic
cd /dumps/
# ll
total 2146584
-rwxr-xr-x. 1 root root  122639592 Mar 11  2014 jdk-7u51-linux-x64.rpm
-rwxr-xr-x. 1 root root 1068506707 Sep 22 00:13 wls1036_generic.jar
[weblogic@oel641 dumps]$ $JAVA_HOME/bin/java -jar ./wls1036_generic.jar -mode=console -logs=./wls1036_install.log
Extracting 0%....................................................................................................100%
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->
Welcome:
--------

This installer will guide you through the installation of WebLogic 10.3.6.0.
Type "Next" or enter to proceed to the next prompt.  If you want to change data entered previously, type "Previous".  You may quit the installer at any time by typing "Exit".

Enter [Exit][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Middleware Home Directory:
---------------------------------
  "Middleware Home" = [Enter new value or use default
"/home/weblogic/Oracle/Middleware"]

Enter new Middleware Home OR [Exit][Previous][Next]> /u02/middleware/weblogic
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Middleware Home Directory:
---------------------------------
    "Middleware Home" = [/u02/middleware/weblogic]

Use above value or select another option:
    1 - Enter new Middleware Home
    2 - Change to default [/home/weblogic/Oracle/Middleware]

Enter option number to select OR [Exit][Previous][Next]> 1

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Middleware Home Directory:
---------------------------------

    "Middleware Home" = [/u02/middleware/weblogic]

Enter new Middleware Home OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->
Choose Middleware Home Directory:
---------------------------------
    "Middleware Home" = [/u02/middleware/weblogic]
    ** The directory could not be created: [/u02/middleware/weblogic]
Enter new Middleware Home OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Middleware Home Directory:
---------------------------------
    "Middleware Home" = [/u02/middleware/weblogic]
    ** Access to the directory is denied: [/u02/middleware/weblogic]

Enter new Middleware Home OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address for security updates and  to initiate configuration manager.

   1|Email:[]
   2|Support Password:[]
   3|Receive Security Update:[Yes]

Enter index number to select OR [Exit][Previous][Next]> 3

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address for security updates and  to initiate configuration manager.

    "Receive Security Update:" = [Enter new value or use default "Yes"]
Enter [Yes][No]? no

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address for security updates and  to initiate configuration manager.

    "Receive Security Update:" = [Enter new value or use default "Yes"]
    ** Do you wish to bypass initiation of the configuration manager and
    **  remain uninformed of critical security issues in your configuration?
Enter [Yes][No]? Yes

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address for security updates and  to initiate configuration manager.

   1|Email:[]
   2|Support Password:[]
   3|Receive Security Update:[No]

Enter index number to select OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Register for Security Updates:
------------------------------

Provide your email address for security updates and  to initiate configuration manager.

   1|Email:[]
   2|Support Password:[]
   3|Receive Security Update:[No]

Enter index number to select OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Install Type:
--------------------

Select the type of installation you wish to perform.

 ->1|Typical
    |  Install the following product(s) and component(s):
    | - WebLogic Server
    | - Oracle Coherence

   2|Custom
    |  Choose software products and components to install and perform optional
    |configuration.

Enter index number to select OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

JDK Selection (Any * indicates Oracle Supplied VM):
---------------------------------------------------

JDK(s) chosen will be installed.  Defaults will be used in script string-substitution if installed.

   1|Add Local Jdk
   2|/usr/java/jdk1.7.0_51[x]
   *Estimated size of installation:  690.2 MB
Enter 1 to add or >= 2 to toggle selection  OR [Exit][Previous][Next]>
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Choose Product Installation Directories:
----------------------------------------
Middleware Home Directory: [/u02/middleware/weblogic]
Product Installation Directories:
   1|WebLogic Server: [/u02/middleware/weblogic/wlserver_10.3]
   2|Oracle Coherence: [/u02/middleware/weblogic/coherence_3.7]

Enter index number to select OR [Exit][Previous][Next]>

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

The following Products and JDKs will be installed:
--------------------------------------------------

    WebLogic Platform 10.3.6.0
    |_____WebLogic Server
    |    |_____Core Application Server
    |    |_____Administration Console
    |    |_____Configuration Wizard and Upgrade Framework
    |    |_____Web 2.0 HTTP Pub-Sub Server
    |    |_____WebLogic SCA
    |    |_____WebLogic JDBC Drivers
    |    |_____Third Party JDBC Drivers
    |    |_____WebLogic Server Clients
    |    |_____WebLogic Web Server Plugins
    |    |_____UDDI and Xquery Support
    |    |_____Evaluation Database
    |_____Oracle Coherence
         |_____Coherence Product Files

    *Estimated size of installation: 690.3 MB

Enter [Exit][Previous][Next]>
Sep 23, 2017 8:21:12 AM java.util.prefs.FileSystemPreferences$1 run
INFO: Created user preferences directory.
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->
Installing files..

0%          25%          50%          75%          100%
[------------|------------|------------|------------]
[***************************************************]
Performing String Substitutions...

<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->

Configuring OCM...

0%          25%          50%          75%          100%
[------------|------------|------------|------------]
[***************************************************]

Creating Domains...
<-------------------- Oracle Installer - WebLogic 10.3.6.0 ------------------->
Installation Complete

Congratulations! Installation is complete.
Press [Enter] to continue or type [Exit]>


Create  WebLogic Domains Step by Step with Detail Description

https://docs.oracle.com/cd/E29542_01/web.1111/e14140/configuration_screens.htm#WLDCW205

Removing OpenJDK and Installing Oracle JDK in Linux step by step

[root@oel641 ~]# java -version
java version "1.7.0_09-icedtea"
OpenJDK Runtime Environment (rhel-2.3.4.1.0.1.el6_3-x86_64)
OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)

[root@oel641 ~]# yum remove java*
Loaded plugins: refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6 will be erased
--> Processing Dependency: java-gcj-compat for package: 1:ecj-3.4.2-6.el6.x86_64
--> Processing Dependency: java-gcj-compat for package: 1:ecj-3.4.2-6.el6.x86_64
--> Processing Dependency: java-gcj-compat >= 1.0.70 for package: sinjdoc-0.5-9.1.el6.x86_64
--> Processing Dependency: java-gcj-compat >= 1.0.70 for package: sinjdoc-0.5-9.1.el6.x86_64
---> Package java-1.5.0-gcj-devel.x86_64 0:1.5.0.0-29.1.el6 will be erased
---> Package java-1.5.0-gcj-javadoc.x86_64 0:1.5.0.0-29.1.el6 will be erased
---> Package java-1.6.0-openjdk.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3 will be erased
---> Package java-1.6.0-openjdk-devel.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3 will be erased
---> Package java-1.6.0-openjdk-javadoc.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3 will be erased
---> Package java-1.7.0-openjdk.x86_64 1:1.7.0.9-2.3.4.1.0.1.el6_3 will be erased
---> Package java-1.7.0-openjdk-devel.x86_64 1:1.7.0.9-2.3.4.1.0.1.el6_3 will be erased
---> Package java_cup.x86_64 1:0.10k-5.el6 will be erased
---> Package javassist.noarch 0:3.9.0-6.el6 will be erased
--> Running transaction check
---> Package ecj.x86_64 1:3.4.2-6.el6 will be erased
---> Package sinjdoc.x86_64 0:0.5-9.1.el6 will be erased
--> Processing Dependency: /usr/share/java/eclipse-ecj.jar for package: gcc-java-4.4.7-3.el6.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package gcc-java.x86_64 0:4.4.7-3.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                              Arch             Version                                      Repository                                                     Size
========================================================================================================================================================================
Removing:
 java-1.5.0-gcj                       x86_64           1.5.0.0-29.1.el6                             @hclrepo                                                      159 k
 java-1.5.0-gcj-devel                 x86_64           1.5.0.0-29.1.el6                             @hclrepo                                                       57 k
 java-1.5.0-gcj-javadoc               x86_64           1.5.0.0-29.1.el6                             @hclrepo                                                      236 M
 java-1.6.0-openjdk                   x86_64           1:1.6.0.0-1.50.1.11.5.0.1.el6_3              @hclrepo                                                       81 M
 java-1.6.0-openjdk-devel             x86_64           1:1.6.0.0-1.50.1.11.5.0.1.el6_3              @hclrepo                                                       33 M
 java-1.6.0-openjdk-javadoc           x86_64           1:1.6.0.0-1.50.1.11.5.0.1.el6_3              @hclrepo                                                      232 M
 java-1.7.0-openjdk                   x86_64           1:1.7.0.9-2.3.4.1.0.1.el6_3                  @anaconda-OracleLinuxServer-201302251503.x86_64/6.4            89 M
 java-1.7.0-openjdk-devel             x86_64           1:1.7.0.9-2.3.4.1.0.1.el6_3                  @hclrepo                                                       36 M
 java_cup                             x86_64           1:0.10k-5.el6                                @hclrepo                                                      544 k
 javassist                            noarch           3.9.0-6.el6                                  @hclrepo                                                      631 k
Removing for dependencies:
 ecj                                  x86_64           1:3.4.2-6.el6                                @hclrepo                                                      7.3 M
 gcc-java                             x86_64           4.4.7-3.el6                                  @hclrepo                                                      9.3 M
 sinjdoc                              x86_64           0.5-9.1.el6                                  @hclrepo                                                      2.3 M

Transaction Summary
========================================================================================================================================================================
Remove       13 Package(s)

Installed size: 726 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : java-1.5.0-gcj-devel-1.5.0.0-29.1.el6.x86_64                                                                                                        1/13
  Erasing    : java-1.5.0-gcj-javadoc-1.5.0.0-29.1.el6.x86_64                                                                                                      2/13
  Erasing    : javassist-3.9.0-6.el6.noarch                                                                                                                        3/13
  Erasing    : 1:java-1.6.0-openjdk-javadoc-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                   4/13
  Erasing    : 1:java-1.7.0-openjdk-devel-1.7.0.9-2.3.4.1.0.1.el6_3.x86_64                                                                                         5/13
  Erasing    : 1:java-1.7.0-openjdk-1.7.0.9-2.3.4.1.0.1.el6_3.x86_64                                                                                               6/13
  Erasing    : gcc-java-4.4.7-3.el6.x86_64                                                                                                                         7/13
  Erasing    : 1:ecj-3.4.2-6.el6.x86_64                                                                                                                            8/13
  Erasing    : 1:java_cup-0.10k-5.el6.x86_64                                                                                                                       9/13
  Erasing    : sinjdoc-0.5-9.1.el6.x86_64                                                                                                                         10/13
  Erasing    : java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64                                                                                                             11/13
  Erasing    : 1:java-1.6.0-openjdk-devel-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                    12/13
  Erasing    : 1:java-1.6.0-openjdk-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                          13/13
  Verifying  : 1:java-1.6.0-openjdk-javadoc-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                   1/13
  Verifying  : javassist-3.9.0-6.el6.noarch                                                                                                                        2/13
  Verifying  : sinjdoc-0.5-9.1.el6.x86_64                                                                                                                          3/13
  Verifying  : 1:java-1.7.0-openjdk-devel-1.7.0.9-2.3.4.1.0.1.el6_3.x86_64                                                                                         4/13
  Verifying  : java-1.5.0-gcj-devel-1.5.0.0-29.1.el6.x86_64                                                                                                        5/13
  Verifying  : gcc-java-4.4.7-3.el6.x86_64                                                                                                                         6/13
  Verifying  : 1:java_cup-0.10k-5.el6.x86_64                                                                                                                       7/13
  Verifying  : java-1.5.0-gcj-javadoc-1.5.0.0-29.1.el6.x86_64                                                                                                      8/13
  Verifying  : 1:java-1.6.0-openjdk-devel-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                     9/13
  Verifying  : 1:java-1.6.0-openjdk-1.6.0.0-1.50.1.11.5.0.1.el6_3.x86_64                                                                                          10/13
  Verifying  : 1:ecj-3.4.2-6.el6.x86_64                                                                                                                           11/13
  Verifying  : 1:java-1.7.0-openjdk-1.7.0.9-2.3.4.1.0.1.el6_3.x86_64                                                                                              12/13
  Verifying  : java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64                                                                                                             13/13

Removed:
  java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6                                          java-1.5.0-gcj-devel.x86_64 0:1.5.0.0-29.1.el6
  java-1.5.0-gcj-javadoc.x86_64 0:1.5.0.0-29.1.el6                                  java-1.6.0-openjdk.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3
  java-1.6.0-openjdk-devel.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3                   java-1.6.0-openjdk-javadoc.x86_64 1:1.6.0.0-1.50.1.11.5.0.1.el6_3
  java-1.7.0-openjdk.x86_64 1:1.7.0.9-2.3.4.1.0.1.el6_3                             java-1.7.0-openjdk-devel.x86_64 1:1.7.0.9-2.3.4.1.0.1.el6_3
  java_cup.x86_64 1:0.10k-5.el6                                                     javassist.noarch 0:3.9.0-6.el6

Dependency Removed:
  ecj.x86_64 1:3.4.2-6.el6                            gcc-java.x86_64 0:4.4.7-3.el6                            sinjdoc.x86_64 0:0.5-9.1.el6

Complete!
[root@oel641 ~]# java -version
-bash: /usr/bin/java: No such file or directory
[root@oel641 ~]#


Install the Oracle JDK:

[root@oel641 repo]# cd /dumps/
[root@oel641 dumps]# ll
total 2146584
-rwxr-xr-x. 1 root root  122639592 Mar 11  2014 jdk-7u51-linux-x64.rpm
-rwxr-xr-x. 1 root root 1068506707 Sep 22 00:13 wls1036_generic.jar

[root@oel641 dumps]# rpm -ivh jdk-7u51-linux-x64.rpm
Preparing...                ########################################### [100%]
   1:jdk                    ########################################### [100%]
Unpacking JAR files...
        rt.jar...
        jsse.jar...
        charsets.jar...
        tools.jar...
        localedata.jar...
        jfxrt.jar...
[root@oel641 dumps]#
[root@oel641 dumps]#

[root@oel641 dumps]# javac -version
javac 1.7.0_51

[root@oel641 dumps]# java -version
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

Tuesday 26 September 2017

Create yum repository in Linux step by step

Create yum repository

  • mkdir /repo (repository folder where we will copy packages from dvd)
  • cp /media/Server/Packages/*.rpm    /repo/
  • cd /etc/yum.repos.d
  • vi hcl.repo
          [hclrepo]
          name=repo from RHEL iso
          baseurl=file:///repo
          ##path of location folder. in my case it is /repo
          ##http://
          ##ftp://192.168.1.1
          enable=1
          gpgcheck=0
          #0- will not check digitally signed or not
          #1- every time it will check digitally signed

cd /repo
Install create repo package:-
rpm -ivh ./deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh ./python-deltarpm-3.5-0.5.20090913git.el6.x86_64.rpm
rpm -ivh ./createrepo-0.9.9-17.el6.noarch.rpm

  • createrepo /repo - this will create repository.
  • yum clean all - clear cache.
  • yum update 
  • yum repolist - this will load all the repositories available on the server.
  • yum -y install kdebase - if you want to set default answer "Y" for package installation.
  • yum install
  • yum install vsftpd

Wednesday 20 September 2017

view tablespace list with used, free, total space and free space percentage

col "Tablespace" for a22
col "Used MB" for 99,999,999
col "Free MB" for 99,999,999
col "Total MB" for 99,999,999

SQL>
select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name ;

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
AAAPP                       57,847         515      58,362          1
ADAPP                            1          59          60         98
AVAPP                            0          19          19        100
BNAPP                           21          31          52         60
BNLARGE                          1          26          27         96
CCAPP                            3         247         250         99
COAPP                           12           5          17         29
CULARGE                          0           6           6        100
EOAPP                           69           6          75          8
EOCFAPP                          3          17          20         85
EOECAPP                          5          20          25         80

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
EOECLRG                        536          31         567          5
EOEWAPP                          0           9           9        100
EOIUAPP                          0           3           3        100
EPAPP                           30           5          35         14
EPLARGE                        498          27         525          5
ERAPP                            4           9          13         69
FAAPP                           29         271         300         90
FGAPP                            8          27          35         77
FSAPP                            0           5           5        100
GIAPP                            0           8           8        100
GPAPP                       38,207       2,705      40,912          7

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
HPAPP                        2,444         126       2,570          5
HRAPP                       26,326       1,319      27,645          5
HRAPP1                           2          20          22         91
HRAPP2                           6          12          18         67
HRAPP3                           0           7           7        100
HRAPP4                           3          13          16         81
HRAPP5                           2          11          13         85
HRAPP6                           1          34          35         97
HRAPP7                          25          23          48         48
HRLARGE                        369          22         391          6
HRSAPP                          23          41          64         64

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
HRSLARGE                         6           2           8         25
HRSWORK                          0          15          15        100
HRWORK                           0          20          20        100
PAAPP                            3          56          59         95
PIAPP                            0           9           9        100
PSDEFAULT                    1,900         148       2,048          7
PSIMAGE                      4,365         223       4,588          5
PSIMAGE2                       928          52         980          5
PSIMGR                           2           2           4         50
PSINDEX                     40,952       1,993      42,945          5
PSUNDOTS1                   27,986       4,777      32,763         15

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
PSUNDOTS2                   12,407      20,356      32,763         62
PTAMSG                         344       3,619       3,963         91
PTAPP                           15          35          50         70
PTAPPE                           2           3           5         60
PTAUDIT                         15           2          17         12
PTLOCK                           0           3           3        100
PTPRC                           29           3          32          9
PTPRJWK                          0           8           8        100
PTRPTS                         112          11         123          9
PTTBL                        2,982         152       3,134          5
PTTLRG                         454          68         522         13

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
PTTREE                           9           2          11         18
PTWORK                           1          11          12         92
PVAPP                            0           4           4        100
PY0LRG                           0         129         129        100
PYAPP                           12          98         110         89
SAAPP                            7         293         300         98
SRAPP                            1         150         151         99
STAPP                            1          31          32         97
STWORK                           0          17          17        100
SYSAUX                       1,572       2,158       3,730         58
SYSTEM                      14,346      33,782      48,128         70

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
TLAPP                            7          93         100         93
TLLARGE                          0          40          40        100
USERS                            0           5           5        100

69 rows selected.



View details of specific tablespace:
=======================
set linesize 124
col file_name format a75
col AUTOEXTENSIBLE format a18
SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
WHERE TABLESPACE_NAME='AAAPP';


FILE_NAME                                                                   BYTES/(1024*1024) MAXBYTES/(1024*1024)
--------------------------------------------------------------------------- ----------------- --------------------
AUTOEXTENSIBLE
------------------
+ORA_DB/hrprd/datafile/aaapp.625.852581469                                              32762           32767.9844
YES

+ORA_DB/hrprd/datafile/aaapp.741.947934975                                              10240                 7168
YES

+ORA_DB/hrprd/datafile/aaapp.851.948719703                                               5120                 5120
YES

Jenkins Startup and Configuration

Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...