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


Wednesday, November 22, 2017

How to change to bash to ksh

 oracle@suthakar$ chsh -s /bin/ksh
Changing shell for oracle.
Password:
Shell changed.


oracle@suthakar$grep oracle /etc/passwd
oracle:x:54321:54321::/home/oracle:/bin/ksh
oracle@suthakar$


Sunday, November 19, 2017

OBIE Installation step by step

OBIEE

1, Install infra structure java -jar 12.2.1.0.0_infrastructure.jar
2. install  Bi Platform setup bi_plotform-12.2.1.0.0_linux64.bin
3. Run rcu (comes with it)
4.create Domain (/apps/oracle/product/obieinfra/bin/bin/config.sh)
5 Start and Stop Servers.
  obieinfra/user_projects/domains/bidev/bitools/bin/.start/stop.sh

 Entry points
        WebLogic Console
            http://suthakar.prince:9500/console
        Fusion Middleware Control
            http://suthakar.prince:9500/em
        BI Publisher
            http://suthakar.prince:9502/xmlpserver
        BI Analytics
            http://suthakar.prince:9502/analytics

  Integration with OIM - OBIEE (Single Sign on ).






























































































































RCU
























































































































































































































Config.sh
----









































































































































































export JAVA_HOME=/apps/oracle/product/JDK/jdk1.8.0_151
export PATH=$JAVA_HOME/bin:$PATH



oracle@suthakar$/apps/oracle/product/JDK/jdk1.8.0_151/bin/java -d64 -jar  fmw_12.2.1.0.0_infrastructure.jar


./bi_platform-12.2.1.0.0_linux64.bin


/apps6/oracle/product/obi12c/oracle_common/bin ./rcu


/apps6/oracle/product/obi12c/bi/bin



suthakar.prince:1525:oidamdev port 9500 - 9999

/apps6/oracle/product/obi12c/user_projects/domains/bi/bitools/bin/start.sh

/apps6/oracle/product/obi12c/user_projects/domains/bi/bitools/bin/stop.sh


-----