Pageviews

Saturday, April 11, 2020

ORA-00600: internal error code, arguments: [4193]

ORA-00600: internal error code, arguments: [4193]

This is caused due to corrupted segment (may be due to power failure or database abrupt shutdown)- For more details visit - Oracle Support

Remember your database is up and running before following the below steps

Follow below instructions :

1. This command will give you segment_name. Copy the segment and use in below command.

 select segment_name,status from dba_rollback_segs where segment_id=8;


2. Use Segment_name from output of above command.

alter system dump undo header "_SYSSMU8_437891266$";

3. Offline the rollback segment:

alter system set "_smu_debug_mode"=4;

4. Check status,  if STATUS=OFFLINE

alter rollback segment "_SYSSMU8_437891266$" offline;

5.  if STATUS=OFFLINE

select status from dba_rollback_segs where segment_id=8;

6. Drop rollback segment

drop rollback segment "_SYSSMU8$";

7. Alter

alter system set "_smu_debug_mode"=0;


Thursday, December 26, 2019

OIM 12c Installation (12.2.1.4.0) , Oracle Identity Management 12c Installation Guide.



Installation steps have been posted on different pages to easily track the progress. 

1. Download and Install Redhat 7.7 as VM - click here
2. Download 12c specific binaries - click here
3. Oracle 12c Database installation - click here
4. Weblogic 12c - Infrastructure Installation - click here
5. SOA 12c Installation - click here
6. OIM 12c Installation - click here
7. Run RCU for OIM and SOA - click here
8. Weblogic OIM SOA Domain Configuration - click here
9. Post Installation Steps - click here
10. SOA OIM Integration - click here
Download and Install Redhat 7.7 as VM


Install Redhat 7.7





And I have installed it as VM and the user is oracle with below settings

 



Login with oracle user and check the internet connectivity -

·         ping google.com
·         ifconfig (and note the IP address to connect this machine outside VM)

Once internet connection confirmation, run below command and follow steps for subscribing the RedHat to start installing packages -

subscription-manager register

Attach a specific subscription through the Customer Portal
After registration, you can assign a subscription to the registered system from the Customer Portal by referring this article. -


After this, refresh the information on your machine using the following command. Be sure to run this any time you add or change the attached subscription from the Customer Portal:

After completing subscription above run -

subscription-manager refresh

Now try to install Xauth for installing OIM using GUI -

·         yum install xauth
·         To enable x-forwarding, enable it in ssh_config

vi /etc/ssh/ssh_config

ForwardX11 yes
ForwardX11Trusted yes

·         And then Reboot the system


After successful installation start downloading OIM binaries - https://rite-oim.blogspot.com/2019/12/download-12c-binaries-25-december-2019.html



Download 12C Binaries
25 December 2019
17:24

Recommended -

1. Before starting the below steps follow - https://rite-oim.blogspot.com/2019/12/download-and-install-redhat-7.html


2. Use wget command to directly download in VM.







Weblogic Server 12c (12.2.1.4) - Fusion Middleware Infrastructure Installer(1.5 GB) - https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html












Now login to oracle edelivery cloud - https://edelivery.oracle.com/


Download OIM and SOA 12c (12.2.1.4.0)

OIM 12.2.1.4.0





Add to cart -





SOA 12.2.1.4.0




Add to cart -




Checkout


Use WGET Options near download button to directly download in VM




























































After Downloading all binaries - start installing Oracle 12c Database - https://rite-oim.blogspot.com/2019/12/recommended-follow-previous-steps.html


Oracle DB – 12c Installation

Recommended - Follow previous steps before starting installation for downloading 12C binaries- https://rite-oim.blogspot.com/2019/12/download-12c-binaries-25-december-2019.html (Ignore, if already done)

1.      Set JAVA_HOME with jdk 8 (131 or above)


Extract downloaded JDK and export the JAVA_HOME and PATH

2.      Configuration file level configurations


Run as User (oracle is user)

ulimit -n 65536

ulimit -u 10240

ulimit -s 10240

Also - 

vi /etc/security/limits.conf and paste below values and save the file.

oracle soft nofile 10240
oracle hard nofile 65536
oracle stack nofile 10240



3.      Install Kernals and Packages


yum install compat-libcap1-1.10

yum install libstdc++-devel-4.8.*

yum install gcc-c++-4.8.*

yum install ksh

yum install libaio-devel(x86_64)-0.3.109


4.      Required System Level and Memory Configuration


vi /etc/sysctl.d/97-oracle-database-sysctl.conf and paste below values and save the file.

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576


/sbin/sysctl --system

/sbin/sysctl -a



5.      Now run the ./runInstaller to start DB installation.






















Below, oracle is the Linux user and by default got selected as group owners
















Click next and follow the instructions as suggested in next steps to complete the installation.


After DB installation - start Weblogic Installation https://rite-oim.blogspot.com/2019/12/weblogic-installation-12c-22-december.html





Weblogic Installation 12c
22 December 2019
17:40

Recommended - Follow previous steps for installing DB before starting Weblogic installation - https://rite-oim.blogspot.com/2019/12/recommended-follow-previous-steps.html (Ignore, if already done)
























After Weblogic Installation - Start SOA Installation - https://rite-oim.blogspot.com/2019/12/soa-installation-12c-22-december-2019_25.html
SOA Installation 12c
22 December 2019
17:57

Recommended - Follow previous steps to install Weblogic before starting SOA installation - https://rite-oim.blogspot.com/2019/12/weblogic-installation-12c-22-december.html (Ignore if already done)























































After SOA Installation Start OIM Installation - https://rite-oim.blogspot.com/2019/12/oim-installation-12c-22-december-2019.html