Install Redhat 6

Link https://www.facebook.com/cold.xxboy/videos/10205021218482462/

How to create a role and grant the role for user/schema in Oracle Database

create role "DEV" NOT IDENTIFIED;
       
grant CREATE TRIGGER to "DEV";
grant CREATE SEQUENCE to "DEV";
grant CREATE TABLE to "DEV";
grant CREATE TYPE to "DEV";
grant CREATE SESSION to "DEV";
grant "CONNECT" to "DEV";
grant CREATE JOB to "DEV";
grant CREATE LIBRARY to "DEV";
grant CREATE INDEXTYPE to "DEV";
grant CREATE ASSEMBLY to "DEV";
grant CREATE PROCEDURE to "DEV";
grant CREATE SYNONYM to "DEV";
grant CREATE VIEW to "DEV";

grant  DEV to schema_name;

SQL ORACLE select column name of a table

SET LINESIZE 32000;
SET PAGESIZE 40000;
SET LONG 50000;
SELECT  column_name
FROM USER_TAB_COLUMNS
WHERE table_name = 'TABLE_NAME'
order by COLUMN_NAME

How to configure jre for P6 EPPM R15.2 on client

Step  1: Download  jre 1.8.0_60 from svn

http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html

Step 2: Install jre 1.8.0_60 

1.Run file ire-8u60-windows-i586

2. Welcome dialog appears. Optional ( tick Change destination folder). Click Next.

3. Choose directory to install ( Default: C:\Program Files(x86)\Java\jre1.8.0_60) . Click Next.

4.  Java Setup Progress is running

5. Java Setup - Complete. Click Close

Step 3: Configure jre 

1.Start | Configure Java

2. In Java Control Panel tab Update. Click Update Now.

.

3. Click Update

4.Downloading Process

5. Dont choose Yahoo, Tick Do not update browser settings. Click Next

6. Java Setup Progress

7.  Update - Complete

8. Check version after update

 

9. Start / Configure Java / Security. Ensure that ticked Enable Java content in the browser. Here,Security Level choose High

In  Exception Site List add P6 EPPM Server url. Example

http://IP_SERVER_P6:8203/p6

10. In Advanced tab. Java Console choose Do not start console.

11. Check information regedit.

regedit | HKEY_LOCAL_MACHINE | SOFTWARE | Wow6432Node | MozillaPlugins | @java

Step  4: Configure client browser

Choose Allow and Remember and tick  OK like this