Example Creating tablespace in Oracle Database.

Create undo tablespace:

create undo tablespace undotbs2 datafile '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf' size 100M autoextend on next 10M;

Create tablespace:

create tablespace BOC datafile '/u01/app/oracle/oradata/ORCL/datafile/BOC.dbf' size 100M autoextend on next 10M;

Create temporary tablespace:

CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u01/app/oracle/oradata/ORCL/datafile/temp.dbf' SIZE 2000M;

Displaying Backup Information Oracle Database

[oracle@VTGDB-Server app]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Feb 25 13:56:15 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select session_key, input_type, status, start_time, end_time, elapsed_seconds/3600 hrs from v$rman_backup_job_details;

SESSION_KEY INPUT_TYPE  STATUS  START_TIM END_TIME     HRS
----------- ------------- ----------------------- --------- --------- ----------
 2 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .331388889
 6 DB FULL  FAILED  25-FEB-16 25-FEB-16 .004166667
11 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .097777778
22 DB FULL  COMPLETED  25-FEB-16 25-FEB-16 .098333333
31 DB FULL  RUNNING  25-FEB-16 25-FEB-16 .040555556

SSH Login & SCP Without Password Using ssh-keygen & ssh-copy-id

admin@local-host$ ssh-keygen

Generating public/private rsa key pair.

Enter file in which to save the key (/home/admin/.ssh/id_rsa):[Enter key]

Enter passphrase (empty for no passphrase): [Press enter key]

Enter same passphrase again: [Press enter key]

Your identification has been saved in /home/admin/.ssh/id_rsa.

Your public key has been saved in /home/admin/.ssh/id_rsa.pub.

The key fingerprint is:

33:b3:fe:af:95:95:18:11:31:d5:de:96:2f:f2:35:f9 admin@local-host

admin@local-host$ ssh-copy-id -i ~/.ssh/id_rsa.pub remote-host

admin@remote-host's password:

Now try logging into the machine, with "ssh 'remote-host'", and check in:

.ssh/authorized_keys

to make sure we haven't added extra keys that you weren't expecting.

How to fix: You do not have sufficient permissions to access the inventory

Describe:
 

 Solution:
[root@PTUD-VM02-3 setup]# rm -fr /etc/oraInst.loc

P6 EPPM R15.2 Installation step by step

Table of Contents

I.     Prerequisite: 2

1.    JDK Installation: 2

2.    Installing a Database: 2

II.    Download the software: 3

1.    Download Web Services. 3

2.    Download WebLogic Server 12.1.2.0.0. 3

3.    Download P6 EPPM R15.2 software: 3

III.       WebLogic Server Installation. 3

IV.       P6 Installation. 8

V.    P6 Configuration. 12

1.    Configure Database: 12

2.    Configure P6: 13

VI.       P6 Components: 20

1.    WebLogic Server Administration Console 12c. 20

2.    P6 EPPM Web. 20

3.    P6 EPPM Team Member: 21

4.    P6 EPPM Pro Cloud Connect: 22

5.    P6 EPPM Web Services: 22

6.    P6 EPPM Administrator: 22

VII.      Document 22

P6 EPPM R15.2 Installation

I.     Prerequisite:

1.      JDK Installation:

Download JDK 1.7.0_80 from My Google Drive:

https://drive.google.com/open?id=0B7a3DEnQ0-uzeWZPeTB2U3hmT0U

unzip the downloaded file.

[p6@PTUD-VM04-3 setup]$ pwd /u01/p6/setup [p6@PTUD-VM04-3 setup]$ls jdk-7u80-linux-x64.gz [p6@PTUD-VM04-3 setup]$tar –xzvf jdk-7u80-linux-x64.gz [p6@PTUD-VM04-3 setup]$ls jdk-7u80-linux-x64.gz jdk-7u80 [p6@PTUD-VM04-3 setup]$mv jdk-7u80 jdk [p6@PTUD-VM04-3 setup]$rm –fr jdk-7u80-linux-x64.gz [p6@PTUD-VM04-3 setup]$ls jdk

Set Java Environment:

[p6@PTUD-VM04-1 ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then             . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH # Java Home export JAVA_HOME=/u01/p6/setup/jdk export PATH=$JAVA_HOME/bin:$PATH

Check java version

[p6@PTUD-VM04-1 ~]$ java -version java version "1.7.0_80" Java(TM) SE Runtime Environment (build 1.7.0_80-b15) Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)

2.      Installing a Database:

My database is Oracle 12c.

II.     Download the software:

1.      Download Web Services

If you plan to install Web Services, you must download the wsdl4j-1.6.2.jar on your machine.

To download the jar:

·         Go to http://mirrors.ibiblio.org/pub/mirrors/maven2/wsdl4j/wsdl4j/1.6.2/.

·         Select the wsdl4j-1.6.2.jar.

·         Save the file to your machine.

·         Note the location where you save the jar file. ( My location is /u01/p6/setup/Web_service)

2.      Download WebLogic Server 12.1.2.0.0

You can download file wls_121200.jar from My Google Drive:

https://drive.google.com/open?id=0B7a3DEnQ0-uzc2JuT0FHc2tLcWM

3.      Download P6 EPPM R15.2 software:

You can download file V77742-01.zip from My Google Drive:

https://drive.google.com/open?id=0B7a3DEnQ0-uzWkJITG1PeUYzMWs

III.     WebLogic Server Installation

Create Weblogic Server directory:

[p6@PTUD-VM04-3 ~]$ pwd /u01/p6 [p6@PTUD-VM04-3 ~]$ mkdir fmw

Running the installer:

 

Click Next

 

Choose Oracle Home is /u01/p6/fmw

 

Choose Installation Type: WebLogic Server Installation

 

 

Click Next

 

Click Install.

 

Click Next

 

Click Finish.

IV.     P6 Installation

Unzip the downloaded file V77742-01.zip

[p6@PTUD-VM04-3 setup]$ pwd /u01/p6/setup [p6@PTUD-VM04-3 setup]$ ls jdk  V77742-01.zip  Web_service  wls_121200.jar  wsdl4j-1.6.2.jar [p6@PTUD-VM04-3 setup]$ unzip V77742-01.zip

Create P6 Home Directory:

[p6@PTUD-VM04-3 ~]$ mkdir p6 [p6@PTUD-VM04-3 ~]$ cd p6 [p6@PTUD-VM04-3 p6]$ pwd /u01/p6/p6

Run the installer

Welcome dialog appears

 

Click Next

 

The Location is created (/u01/p6/p6). Click Next

 

Click Select All and click Next

 

Browse JDK Home and click Next.

 

Select installation Web Service Directory and click Next.

 

Click Install.

 

Click Exit.

V.     P6 Configuration

1.      Configure Database:

Before installing P6 EPPM, execute grant privileges to the SYSTEM user.

Transfer script manual_script_before_install.sql to database server.

[p6@PTUD-VM04-3 PM_15_02_00]$ pwd /u01/p6/setup/P6_152/p6suite/database/scripts/install/PM_15_02_00 [p6@PTUD-VM04-3 PM_15_02_00]$ ls manual_script_after_upgrade.sql   orpm_create_plus_users.sql         orpm_grant_privileges.sql  orpm_reset_priv.sql       SchemaWorkflow.xml            sspm_drop_users.sql   sspm_settings.sql manual_script_before_install.sql  orpm_create_private_user.sql       orpm_init_db.sql           orpm_secpac.sql           sspm_create_plus_users.sql    sspm_init_bgjobs.sql  sspm_tables.sql manual_script_before_upgrade.sql  orpm_create_users.sql              orpm_init_px.sql           orpm_tables.sql           sspm_create_private_user.sql  sspm_init_db.sql      Suite.xml orpm_admuser.sql                  orpm_drop_users.sql                orpm_lock_px_stats.sql     orpm_trunc_px_tables.sql  sspm_create_users.sql         sspm_ins_aux.sql orpm_create_bguser_upgrade.sql    orpm_grantpriv_bguser_upgrade.sql  orpm_querylib.sql          pmSchema.xml              sspm_database_version.sql     sspm_querylib.sql [p6@PTUD-VM04-3 PM_15_02_00]$ scp manual_script_before_install.sql oracle@VTGDB.COM:/u01/app/oracle/scripts

On database server, run the script.

[oracle@VTGDB.COM script]$ ls agentHome  manual_script_before_install.sql  manual_script_before_upgrade.sql  oracleasmlib-2.0.4-1.el6.x86_64.rpm  oracleasm-support-2.1.8-1.el6.x86_64.rpm  scripts  test  tomcat_sync_job_8198 [oracle@VTGDB.COM ~]$ sqlplus / as sysdba @manual_script_before_install.sql SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 15 13:39:06 2016 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. Grant succeeded. SQL> commit; Commit complete. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options

2.      Configure P6:

[p6@PTUD-VM04-3 p6]$ pwd /u01/p6/p6/p6 [p6@PTUD-VM04-3 p6]$ ls adminpv.cmd  dbconfigpv.cmd  eppmconfig.cmd  lib      migration_lib      migrationtool.sh  p6help         p6services.jar adminpv.sh   dbconfigpv.sh   eppmconfig.sh   license  migrationtool.cmd  p6.ear            P6Reports.zip  precompile_utility [p6@PTUD-VM04-3 p6]$ chmod 775 -R . [p6@PTUD-VM04-3 p6]$ ./eppmconfig.sh

 

Click Next

 

Choose Create a new P6 EPPM database, uncheck Install Sample Projects

 

Enter Host, Port, username dba, password, sid to connect database.

 

Enter username, password of 5 schemas and 1 Application User. Click Next

 

I choose default name of new configuration, then click Next.

 

Tick Configure WebLogic and Create a new WebLogic domain.

 

WebLogic Server Home: (/u01/p6/fmw/wlserver)

 

I will connect a content repository later. ( read it for detail http://vtgdb.blogspot.com/2015/09/connecting-content-repository-to-p6-r151.html )

 

I will connect BI Publisher later. 

 

I will connect EPM workflows later.

 

Review Configuration, click Next

 

Click Next

 

Click Finish.

VI.     P6 Components:

After you finished installation, you can access following components:

1.      WebLogic Server Administration Console 12c

You can access via address: http://YOUR_HOST:7001/console

 

2.      P6 EPPM Web

You can access via address: http://YOUR_HOST:8203/p6/

 

3.      P6 EPPM Team Member:

You can access via address: http://YOUR_HOST:8207/p6tmweb

 

4.      P6 EPPM Pro Cloud Connect:

	You can access via address: http://YOUR_HOST:8208/p6procloudconnect
	5.      P6 EPPM Web Services: You can access via address: http://YOUR_HOST:8206/p6ws/services 6.      P6 EPPM Administrator: You can access via address: http://YOUR_HOST:8203/p6/action/adminconfig

VII.     Document

The tested Configurations document :

http://docs.oracle.com/cd/E59283_01/EPPM/15_2/eppm_15_2_tested_configs.xls

 Download this guide from:

https://drive.google.com/open?id=0B7a3DEnQ0-uzS09IRDNtbWZjYXc