[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: ...
Category
- APEX 5.0.3 ( 1 )
- Applications Manager ( 4 )
- BI Publisher ( 12 )
- Enterprise Manager Cloud 12c ( 2 )
- Identity Management ( 12 )
- Java ( 4 )
- MySQL ( 7 )
- OCDM ( 3 )
- OPAM ( 2 )
- Oracle ( 28 )
- P6 EPPM ( 13 )
- PeopleSoft ( 2 )
- Php ( 2 )
- Redhat ( 22 )
- Timesten ( 3 )
- WCCC ( 8 )
- windows ( 1 )
- yii framework ( 1 )
Saturday, August 22, 2015
Checking P6 connectivity to others servers

Syntax:
http://host:port/server/p6/dm/devmode.jsp
Sample:
http://192.168.2.156:8203/p6/dm/devmode.jsp
...
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)...
Subscribe to:
Posts (Atom)
- Weekly
- Recent
- Comment
Weekly
-
Step 1: Set JAVA environment for PENTAHO My...
-
Step 1: Create tablespace create tablespace...
-
Source Server Target ...
-
Step 1 : Setup the RREG utility ...