Wednesday, December 13, 2017

Hyperion Performance Management 11.1.2.4

$. .epm
cd $DOMAIN_HOME
$/apps/oracle/product/epm/user_projects/domains/EPMSystem
$ cd bin

-rw-r-----. 1 oracle oinstall    93 Dec 13 10:54 epmTopology.properites
drwxr-x---. 2 oracle oinstall  4096 Dec 13 10:55 server_migration
drwxr-x---. 2 oracle oinstall  4096 Dec 13 10:55 nodemanager
drwxr-x---. 2 oracle oinstall  4096 Dec 13 10:55 service_migration
-rwxr-x---. 1 oracle oinstall  1995 Dec 13 10:55 secureWebLogic.sh
-rwxr-x---. 1 oracle oinstall  2724 Dec 13 10:55 setEpmEnv.sh
-rwxr-x---. 1 oracle oinstall   872 Dec 13 10:55 processBootProperties.sh
-rwxr-x---. 1 oracle oinstall  1976 Dec 13 10:55 stopWebLogic.sh
-rwxr-x---. 1 oracle oinstall  5689 Dec 13 10:55 startWebLogic.sh
-rwxr-x---. 1 oracle oinstall  2422 Dec 13 10:55 stopManagedWebLogic.sh
-rwxr-x---. 1 oracle oinstall  3214 Dec 13 10:55 startManagedWebLogic.sh
-rwxr-x---. 1 oracle oinstall 16856 Dec 13 10:55 setDomainEnv.sh

password stored in boot.properties.

$.startWebLogic.sh  admin running on 7001
$new session startManagedWebLogic.sh EPMServer0 http://hostname:9000

console



EPM Server: start Hyperion Service

$INST_HOME

oracle@suthakar$pwd
/apps/oracle/product/epm/user_projects/epmsystem1/bin
oracle@suthakar$ls -ltr
total 108
-rwxr-x---. 1 oracle oinstall 1898 Dec 13 10:54 registry-cleanup.sh
drwxr-x---. 2 oracle oinstall 4096 Dec 13 10:54 deployment
-rwxr-x---. 1 oracle oinstall 8130 Dec 13 10:54 Utility.sh
-rwxr-x---. 1 oracle oinstall 2811 Dec 13 10:54 acr.sh
-rwxr-x---. 1 oracle oinstall 2551 Dec 13 10:54 epm_cloneexport.sh
-rwxr-x---. 1 oracle oinstall 2542 Dec 13 10:54 epm_cloneimport.sh
-rwxr-x---. 1 oracle oinstall 1570 Dec 13 10:54 epmactivity.sh
-rwxr-x---. 1 oracle oinstall  285 Dec 13 10:54 epmreports.sh
-rwxr-x---. 1 oracle oinstall 2874 Dec 13 10:54 epmsys_registry.sh
-rwxr-x---. 1 oracle oinstall 1934 Dec 13 10:54 loganalysis.sh
-rwxr-x---. 1 oracle oinstall  813 Dec 13 10:54 metrics.properties
-rwxr-x---. 1 oracle oinstall  683 Dec 13 10:54 setEnv.sh
-rwxr-x---. 1 oracle oinstall  799 Dec 13 10:54 was_config_epm.sh
-rwxr-x---. 1 oracle oinstall  430 Dec 13 10:54 configtool.sh
-rwxr-x---. 1 oracle oinstall  156 Dec 13 10:54 resetConfigTask.sh
-rwxr-x---. 1 oracle oinstall  195 Dec 13 10:54 ziplogs.sh
-rwxr-x---. 1 oracle oinstall  402 Dec 13 10:54 start.sh
-rwxr-x---. 1 oracle oinstall  401 Dec 13 10:54 stop.sh
-rwxr-x---. 1 oracle oinstall 1625 Dec 13 10:54 validate.sh
drwxr-x---. 6 oracle oinstall 4096 Dec 13 10:54 ReportingAnalysis
drwxr-x---. 2 oracle oinstall 4096 Dec 13 10:54 upgrades
-rwxr-x---. 1 oracle oinstall  135 Dec 13 10:54 stopRaFrameworkAgent.sh
-rwxr-x---. 1 oracle oinstall  136 Dec 13 10:54 startRaFrameworkAgent.sh
drwxr-x---. 2 oracle oinstall 4096 Dec 13 10:55 deploymentScripts
-rwxr-x---. 1 oracle oinstall  128 Dec 13 10:55 startEPMServer.sh
-rwxr-x---. 1 oracle oinstall  127 Dec 13 10:55 stopEPMServer.sh
 $start.sh
Starting all
Apache Ant version 1.7.1 compiled on June 27 2008
Buildfile: /apps/oracle/product/epm/EPMSystem11R1/common/config/11.1.2.0/resources/instance/start.xml
Finish all

/apps/oracle/product/epm/user_projects/epmsystem1/bin

validate.sh will give you result.


Oracle EPM System
Diagnostics
Generated on 12/13/2017 12:17 PM
Validation run on suthakar.prince
Build version: 11.1.2.4.0.9952
EPM System Diagnostics info: 11.1.2.4.0 drop 13 build 9601-on-12/12/2014 10:46 AM
OS name: Linux
OS version: 2.6.39-400.298.1.el6uek.x86_64
EPM System Instance location: /apps/oracle/product/epm/user_projects/epmsystem1

you can review diagnostics/reports/instance_report_20171213_121731.html





Friday, December 8, 2017

9502/xmlpserver/ : Server not initialized. Please make sure the repository is ready.


 cd oracle@suthakar$/apps/oracle/product/obiee/user_projects/domains/obiee/bitools/bin
./starts.sh obiccs                                                                                                                       
bash: ./starts.sh: No such file or directory                                                                                                             
oracle@suthakar$./start.sh obiccs                                                                                                                       
Starting domain; Using domainHome: /apps/oracle/product/obiee/user_projects/domains/obiee ...                                                           

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands




NodeManager already running
Reading domain...
/Servers/AdminServer/ListenPort=9500
Accessing admin server using URL t3://suthakar.prince:9500

AdminServer already running

Starting all servers ...
Server bi_server1 not started as already in state (RUNNING)
Starting obiccs1 (Original State:SHUTDOWN) ...
Started obiccs1

Starting obis1 (Original State:SHUTDOWN) ...
Started obis1

Starting obips1 (Original State:SHUTDOWN) ...
Started obips1

Starting obijh1 (Original State:SHUTDOWN) ...
Started obijh1

Starting obisch1 (Original State:SHUTDOWN) ...
Started obisch1


Finished starting servers

Status of Domain: /apps/oracle/product/obiee/user_projects/domains/obiee
NodeManager (suthakar.prince:9506): RUNNING

Name            Type            Machine                   Status
----            ----            -------                   ------
AdminServer     Server          suthakar.prince           RUNNING
bi_server1      Server          suthakar.prince           RUNNING
obips1          OBIPS           suthakar.prince           RUNNING
obijh1          OBIJH           suthakar.prince           RUNNING
obiccs1         OBICCS          suthakar.prince           RUNNING
obisch1         OBISCH          suthakar.prince           RUNNING
obis1           OBIS            suthakar.prince           RUNNING

oracle@suthakar$pwd
/apps/oracle/product/obiee/user_projects/domains/obiee/bitools/bin
oracle@suthakar$

Thursday, December 7, 2017

Oracle EBS 12.2.4 SOA Gateway

Oracle EBS 12.2.4 Instance configured for REST services. We Deploy API as Rest Service.

you can follow the Doc MOS Note : 1311068.1).


Sunday, December 3, 2017

Direct access to this page with the IDMDomainAgent is invalid.

 Error: Single Sign Off didn't take place Cause: The IDMDomainAgent for SingleSignOn is not enabled, but SingleSignOff tried to access the Agent's logout page.. Action: Enable the IDMDomainAgent or use a WebGate for SingleSignOn protection. Direct access to this page with the IDMDomainAgent is invalid.


Single Sign Off didn't take place" Error After OIM - OAM Integration When Loging Out From oamconsole. (Doc ID 1679851.1)


Add this entry in mod_wl_ohs.conf


 
            SetHandler weblogic-handler
            WebLogicHost suthakar.prince
            WebLogicPort 7001
    

 

 stop and restart ohs

oracle@suthakar$ohs_stop.sh

cdo - use alias cdo to change to   /apps/oracle/product/fmw_idm/iam
cdp - use alias cdp to change to   /apps/oracle/local/profiles

ORACLE_BASE for databases is   /apps/oracle/product

LOG_DIR for all  is   /apps/oracle/logs

opmnctl stopall: stopping opmn and all managed processes...
opmnctl status: opmn is not running.
oracle@suthakar$

oracle@suthakar$
oracle@suthakar$ohs_startup.sh

cdo - use alias cdo to change to   /apps/oracle/product/fmw_idm/iam
cdp - use alias cdp to change to   /apps/oracle/local/profiles

ORACLE_BASE for databases is   /apps/oracle/product

LOG_DIR for all  is   /apps/oracle/logs

opmnctl startall: starting opmn and all managed processes...
Picked up _JAVA_OPTIONS: -Xms512m -Xmx1024m

Processes in Instance: instance1
---------------------------------+--------------------+---------+----------+------------+----------+-----------+------
ias-component                    | process-type       |     pid | status   |        uid |  memused |    uptime | ports
---------------------------------+--------------------+---------+----------+------------+----------+-----------+------
ohs1                             | OHS                |   25302 | Alive    | 1776878944 |   924040 |   0:00:14 | https:9999,https:4443,http:7777
 

Thursday, November 30, 2017

How to increase kdump value



login to root











system-config-kdump

After increase you can reboot.






Monday, November 27, 2017

DB upgrade to 12.2 from 11.2.0.4

Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) (Doc ID 2173141.1)

I recently upgraded the database from 11.2.0.4 to 12.2




Oracle Database 12.2 Post-Upgrade Status Tool           11-27-2017 12:01:13

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:16:01
JServer JAVA Virtual Machine              VALID      12.2.0.1.0  00:00:01
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
OLAP Analytic Workspace                UPGRADED      12.2.0.1.0  00:00:12
Oracle OLAP API                        UPGRADED      12.2.0.1.0  00:00:10
Oracle XDK                             UPGRADED      12.2.0.1.0  00:00:18
Oracle Text                               VALID      12.2.0.1.0  00:00:26
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:01:26
Oracle Database Java Packages          UPGRADED      12.2.0.1.0  00:00:09
Oracle Multimedia                      UPGRADED      12.2.0.1.0  00:01:10
Spatial                                UPGRADED      12.2.0.1.0  00:03:54
Final Actions                                                    00:02:01
Post Upgrade                                                     00:00:12

Total Upgrade Time: 00:26:15

Sunday, November 26, 2017

JAVA_OPTIONS for IAM to avoid ORA-00001: unique constraint (DEV_OAM.PK_ENTITIES) violated

when I start my weblogic, I got the below error.


Error Code: 1
Call: INSERT INTO ENTITIES (ID, CREATE_TIME_STAMP, CREATOR, DESCRIPTION, JOURNAL_ID, MODIFIER, MODIFY_TIME_STAMP, NAME, NAME_PATH, TAG, TRANSACTION_ID, TYPE_NAMES, UNIQUE_ID, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
        bind => [14 parameters bound]
Query: InsertObjectQuery(oracle.security.am.found


1. Take backup of  setDomainEnv.sh 
2. end of the file add the following entry
export JAVA_OPTIONS=%JAVA_OPTIONS%  -DDISABLE_CONFIG_ENTRY=true

Environment: Linux 6.5 weblogic 10.3.6 OIM 11.1.2.3