Monday, August 24, 2015

Check connection to Linux server

Syntax: traceroute -nT   -p Example: [root@ptud ~]# traceroute -nT 10.79.255.87 -p 22 traceroute to 10.79.255.87 (10.79.255.87), 30 hops max, 60 byte packets  1  192.168.2.158  0.511 ms  1.071 ms  1.320 ms  2  192.168.2.1  9.100 ms  9.121 ms  9.105 ms  3  10.79.255.253  16.590 ms  16.575 ms  16.555...

Enabling TDE in Oracle Privileged Account Manager Data Store

Before that, you need to read the documents: https://docs.oracle.com/cd/E52734_01/core/INOAM/opam.htm#INOAM98442 and https://docs.oracle.com/cd/E11882_01/network.112/e40393.pdf [oracle@PTUDServer3 oracle]$ cd $ORACLE_HOME [oracle@PTUDServer3 db_1]$ mkdir wallet         [oracle@PTUDServer3 admin]$ more sqlnet.ora  # sqlnet.ora Network Configuration File:...

Setting Up Non-TDE Mode for Oracle Privileged Account Manager

Firstly, you need to read the document: https://docs.oracle.com/cd/E52734_01/core/INOAM/opam.htm#INOAM98326 [omss@ptudvtg149 ~]$ export ORACLE_HOME=/home/omss/fmw/Oracle_IDM1 [omss@ptudvtg149 ~]$ export ANT_HOME=/home/omss/fmw/modules/org.apache.ant_1.7.1 [omss@ptudvtg149 ~]$ export JAVA_HOME=/home/omss/setup/jdk [omss@ptudvtg149 ~]$ export ANT_OPTS="-Xmx512M -XX:MaxPermSize=512m" [omss@ptudvtg149...

Saturday, August 22, 2015

How to set security ssh on linux

[root@App1 ~]# vi /etc/ssh/sshd_config ### insert the command to apply only monitor, survey, oam user OS can ssh from anywhere, others ### cannot ssh from other machine AllowUsers monitor survey oam Now, Restart sshd [root@App1 ~]# /etc/init.d/sshd restart Stopping sshd:                              ...

Monitoring memory and CPU using JVisualVM

[oracle@App1 ~]$ export JAVA_HOME=/u01/app/software/jdk/ [oracle@App1 ~]$ cd $JAVA_HOME/bin [oracle@App1 bin]$ ls appletviewer  javac           jconsole  jps         native2ascii  serialver apt        ...

P6 Primavera Database Tuning - Use turned Table Statics

Run P6 db scripts that set table statistics (orpm_stats_gather.sql) These scripts can be found at /database/scripts/common/aux_script They adjust statistics to be off for certain dynamic tables [oracle@App1 software]$ cd P6_R151/p6suite/database/scripts/common/aux_script/ [oracle@App1 aux_script]$ ls orpm_stats_gather_b.sql  orpm_stats_gather_c.sql  orpm_stats_gather.sql [oracle@App1...

Friday, August 21, 2015

How to start P6 Primavera R15.1 server step by step

 First, we start AdminServer [access@ptud PrimaveraP6EPPM]$ pwd /home/access/fmw/user_projects/domains/PrimaveraP6EPPM [access@ptud PrimaveraP6EPPM]$ ls autodeploy  console-ext           init-info  nodemanager ...

Wednesday, August 12, 2015

Find tablespace belong to a schema in Oracle Database

Syntax: SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER='SCHEMA_NAME'; Example: [oracle@PTUD-SV01 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 12 09:24:04 2015 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,...

Thursday, August 6, 2015

How to upgrade java version

[omss@ptud ~]$ java -version java version "1.7.0_65" [root@ptud omss]# ln -s -v /home/omss/jdk/bin/java /usr/bin/java `/usr/bin/java' -> `/home/omss/jdk/bin/java' [root@ptud omss]# ln -s -v /home/omss/jdk/bin/javac /usr/bin/javac ln: creating symbolic link `/usr/bin/javac': File exists [root@ptud omss]# rm -fr  /usr/bin/javac [root@ptud omss]# ln -s -v /home/omss/jdk/bin/javac...

Tuesday, August 4, 2015

How to start/stop Oracle Unified Directory 11gR2

[omss@ptud bin]$ pwd /home/omss/middleware/asinst_1/OUD/bin [omss@ptud bin]$ ./start-ds  [04/Aug/2015:09:50:22 +0700] category=CORE severity=INFORMATION msgID=132 msg=The Directory Server is beginning the configuration bootstrapping process [04/Aug/2015:09:50:22 +0700] category=CORE severity=NOTICE msgID=458886 msg=Oracle Unified Directory 11.1.2.3.0 (build 20150414142803Z,...

Monday, August 3, 2015

How to set Security Mode "Fustion Middleware" on Bi Publisher

1) Navigate to ${OBIEE}/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Admin/Configuration directory [obiee@ptudvtg149 Configuration]$ pwd/home/obiee/middleware/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Admin/Configuration 2) Open the file xmlp-server-config.xml [obiee@ptudvtg149 Configuration]$ vi xmlp-server-config.xml 3)...