Oracle Application DBA (11i , 12.1 12.2): October 2017

Tuesday, October 31, 2017

Configuring Kernel Parameters and Resource Limits

example
[root@prince bin]# sysctl -w net.core.rmem_max=4194304
net.core.rmem_max = 4194304

Friday, October 20, 2017

ORA-12709 error while loading create database character set

sqlplus '/as sysdba'

SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 20 15:15:36 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 9999220736 bytes
Fixed Size                 12341968 bytes
Variable Size            1879051568 bytes
Database Buffers         8086618112 bytes
Redo Buffers               21209088 bytes
ORA-12709: error while loading create database character set

Solution :
got to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/old
[oracle@prince old]$ perl cr9idata.pl
Creating directory /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata ...
Copying files to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata...
Copy finished.
Please reset environment variable ORA_NLS10 to /home/oracle/product/obiedb/12c/12.2.0.1/nls/data/9idata!
[oracle@prince old]$

qlplus '/as sysdba'

SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 20 15:25:07 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 9999220736 bytes
Fixed Size                 12341968 bytes
Variable Size            1879051568 bytes
Database Buffers         8086618112 bytes
Redo Buffers               21209088 bytes
Database mounted.
Database opened.
SQL>

[FATAL] [DBT-06103] The port (5,500) is already in use. INFO: Read: ACTION: Specify a free port

Today I was installing oracle 12.2.1 db on Linux server, I got the error message.

Read: [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: [FATAL] [DBT-06103] The port (5,500) is already in use.
WARNING: Skipping line: [FATAL] [DBT-06103] The port (5,500) is already in use.
INFO: Read:    ACTION: Specify a free port.
INFO:    ACTION: Specify a free port.
WARNING: Skipping line:    ACTION: Specify a free port.
INFO: Completed Plugin named: Oracle Database Configuration Assistant

Solution:

edit your /etc/hosts and the entry if you do not have

#ipaddress hostname shotname

xxx.xxx.xxx.xxx example.test.haha example

After I retry the installation it works fine.

Thursday, October 5, 2017

OUD Installation

#! /bin/ksh
export JAVA_HOME=/apps2/jdk/jdk1.8.0_144/bin
export FMW=/apps2/OUD/fmw
export OUD_HOME=/apps2/OUD/fmw/Oracle_OUD1
export OUDIstance=/apps2/OUD/fmw/asinst_1

ofm_oud_generic_11.1.2.3.0_disk1_1of1.zip

setup your inventory, fusion middleware home. setup your java

Go to /apps2/OUD/fmw/Oracle_OUD1

OUD Instance location successfully created /apps2/OUD/fmw/Oracle_OUD1/../asinst_1"

/OUD/fmw/Oracle_OUD1$ ./oud-setup

OUD Instance location successfully created - /apps2/OUD/fmw/Oracle_OUD1/../asinst_1"

Launching graphical setup...

Equivalent non-interactive command-line to setup server:

oud-setup \

--cli \

--baseDN dc=domain,dc=com \

--sampleData 1000 \

--adminConnectorPort xxx \

--ldapPort xxxx\

--rootUserDN cn=Directory\ Manager \

--rootUserPasswordFile ****** \

--ldapsPort xxxx \

--generateSelfSignedCertificate \

--hostname server.domain.name \

--serverTuning -Xms1033m\ -Xmx1033m\ -d64\ -XX:+UseCompressedOops\ -server\ -XX:MaxTenuringThreshold=1\ -XX:+UseConcMarkSweepGC\ -XX:CMSInitiatingOccupancyFraction=55 \

--offlineToolsTuning -Xms1033m\ -Xmx1033m\ -d64\ -XX:+UseCompressedOops\ -server\ -XX:+UseParallelGC\ -XX:+UseNUMA \

--no-prompt \

--noPropertiesFile

/apps2/OUD/fmw/Oracle_OUD1$ netstat -an |grep xxxx

*.xxxx *.* 0 0 256000 0 LISTEN

*.xxx *.* 0 0 256000 0 LISTEN

/apps2/OUD/fmw/Oracle_OUD1$ netstat -an |grep xxxx port number

*.xxxx *.* 0 0 256000 0 LISTEN

*.xxxx *.* 0 0 256000 0 LISTEN

USER@SERVER:/apps2/OUD/fmw/asinst_1/OUD/bin$ ./status

>>>> Specify Oracle Unified Directory LDAP connection parameters

Administrator user bind DN [cn=Directory Manager]:

Password for user 'cn=Directory Manager':

--- Server Status ---

Server Run Status: Started

Open Connections: 1

--- Server Details ---

Host Name: server.domain.xxx

Administrative Users: cn=Directory Manager

Installation Path: /apps2/OUD/fmw/Oracle_OUD1

Instance Path: /apps2/OUD/fmw/asinst_1/OUD

Version: Oracle Unified Directory 11.1.2.3.0

Java Version: 1.8.0_144

Administration Connector: Port port#(LDAPS)

--- Connection Handlers ---

Address:Port : Protocol : State

-------------:----------:---------

-- : LDIF : Disabled

0.0.0.0:xxx : SNMP : Disabled

0.0.0.0:xxxx : LDAP : Enabled

0.0.0.0:xxxx : JMX : Disabled

0.0.0.0:xxx : LDAPS : Enabled

--- Data Sources ---

Base DN: cn=virtual acis

Backend ID: virtualAcis

Entries: 0

Replication: Disabled

Base DN: dc=domain,dc=com

Backend ID: userRoot

Entries: 1002

Replication: Disabled

USER@SERVER:/apps2/OUD/fmw/asinst_1/OUD/bin$

Now install weblogic on the middleware directory with fmw.

apps2/jdk/jdk1.8.0_144/bin/java -d64 -jar wls1036_generic.jar

you need to install AD for ODSM web interface. Adf should be installed in FMW directory.

run confisg.sh

/apps2/OUD/fmw/oracle_common/common/bin$

After installation you can see the directory structure

:/apps2/OUD/fmw$ ls -ltr

total 383

drwxr-x--- 3 UID group 3 Sep 28 10:34 asinst_1

drwxr-x--- 21 UID group 31 Sep 28 10:34 Oracle_OUD1

drwxr-xr-x 7 UID group 481 Sep 28 11:54 modules

drwxr-xr-x 8 UID group 9 Sep 28 11:54 utils

-rw-r--r-- 1 UID group 854 Sep 28 11:54 ocm.rsp

-rw-r--r-- 1 UID group 108875 Sep 28 11:54 registry.dat

-rw-r--r-- 1 UID group 1901 Sep 28 11:54 registry.xml

drwxr-xr-x 8 UID group 10 Sep 28 11:54 wlserver_10.3

drwxr-xr-x 6 UID group 9 Sep 28 11:54 coherence_3.7

drwxrwx--- 5 UID group 9 Sep 28 15:01 oraInventory_oud

drwxr-x--- 32 UID group 35 Sep 28 15:02 oracle_common

drwxr-x--- 3 UID group 3 Sep 28 15:13 user_projects

-rw-rw---- 1 UID group 423 Sep 29 12:18 domain-registry.xml

drwxr-xr-x 2 UID group 18 Oct 2 13:57 logs

set your boot.properties.

/apps2/OUD/fmw/user_projects/domains/domainoud_domain/servers/AdminServer/security$ ls -ltr

total 2

-rw-r----- 1 username group 186 Sep 29 12:18 boot.properties

Now you have to start OUD

:/apps2/OUD/fmw/asinst_1/OUD/bin$ sh start-ds

then start weblogic

/apps2/OUD/fmw/user_projects/domains/domainoud_domain/bin

Sh setDomainEnv.sh

Sh startWebLogic.sh

now you can login to console make sure your service is running. then you can login into odsm.

Subscribe to: Posts (Atom)