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)...