Oracle Your Life: Oracle

Showing posts with label Oracle. Show all posts

2012/03/24

Making Oracle Database XE Available to Remote Clients

I installed one Oracle Database XE for testing purpose.

And found that it won't be accessable from different client.

And finally I found the answer in Oracle Document

Here is the copied sentence...

Start SQL*Plus and log in as SYSTEM:

SYSTEM_DRIVE:\> sqlplus system
Enter password: SYSTEM_password

Or, if you are logging in remotely:

SYSTEM_DRIVE:\> sqlplus system@xe_server_host_name
Enter password: SYSTEM_password

At the SQL prompt, enter the following command:

SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

And it can be remote access now.

2012/03/18

Upgrade Oracle E-Business Suite R12.1.1 to R12.1.3 on Oracle Linux

Reference from Oracle Support DocId : 1080973.1

My EBS on my Oracle Linux is 12.1.1. I want to upgrade it to 12.1.3 to experience the new OAF Rich UI.

Here are my steps, the issues I encountered and the solutions.

Apply Patch 9239089

This one is easy.

Download the patch 9239089.

Unzip it.

Apply patch.

Apply Patch 9239090

This patch is big. It is seperated into 6 files, but still the same steps.

Download the patch 9239090.

Unzip them.

Apply the patch.

It spends a lot of time to apply this patch. And during applying the patch, there are several issues come to my server.

One is EGOSILDU.sql issue, which can be solved by DocId. 847687.1. But I don't use "Advanced Product Catalog" which I can ignore this issue by using adctrl and press 8.

And I also encountered another issue which is some form objects could not be compiled correctly.

au resource ASTACLIB.pll
au resource ASTCORE.pll
au resource ASTCUREL.pll
au resource ASTLSLIB.pll
au resource ASTCPREP.pll
au resource ASTOPLIB.pll
au resource IEXCORE.pll
au resource ASTRCALL.pll
au resource OKSSRVAV.pll
au resource ASTSLLIB.pll
au resource ASTCULIB.pll
au resource CSCUTILS.pll

And in this document

https://forums.oracle.com/forums/thread.jspa?threadID=2131259

Just recompile the db package AS_API_RECORDS_PKG and recompile the previous pll files to plx would solve this issue.

Apply Patch 9239095

This one is easy, too.

Download the patch 9239095

Unzip the patch

Apply the patch

Post-Updates Steps

Finally the patches of Oracle E-Business Suite R12.1.3 is done.I also need to apply patches 9817770 & 9966055, otherwise my responsibilities won't appear.

Update Code Level

To keep application tier and database tier the correct code level, do the following steps:

cd $AD_TOP/bin, run admkappsutil.pl.

This will generate latest appsutil.zip under $INST_TOP/admin/out

Then login as database os user, cd $ORACLE_HOME, ftp or copy the appsutil.zip (which is created by application os user) to current folder.

unzip -o appsutil.zip

Run adautocfg.sh on $ORACLE_HOME.

then run adpreclone.pl dbTier using database user, and adpreclone.pl appsTier using application user.

Now everything is ready, you may startup your Oracle E-Business Suite 12.1.3 now!

2012/03/13

Oracle E-Business Suite R12 OAF Rich User Interface Enhancement

Reference from Oracle
There are some new enhancements since Oracle EBS R12.1.2 was introduced, especially the OAF Rich UI.
I think Oracle is getting better and better now. I'm going to upgrade my R12.1.1 on my Oracle Linux later on.
Now let's give it a glance.

I just captured the picture from the document. All the copyright of the picture belong to Oracle.

Now we have new navigator in the left

You can put some embedded content, see the right

You can have Drop-Down Navigator Menu. I love this function myself.

The Drop-Down Favorites. I love this one too.

This one is even better! The Inline, look-ahead LOV window.

The Inline View Attachment Window

Inline Popup Window

Embedded OBIEE Analytic Contents. Every boss asked about this!

Embedded Custom Rich Content

Function after R12.1.3

Exceptions as Popups.

AutoVue Integration.

View Object Creation.

Create your own Dynamic View Object

Copy & Undo funtion

Summary

I think Oracle is really trying hard to get Oracle E-Business Suite better and better. Though it's not fast enough, but I think I still love these new functions introduced.
Keep visiting my blog, I might have a chance to share my process of upgrade from R12.1.1 to R12.1.3.
See you soon.

2012/02/05

Database parameter setting (Reference)

alter system set processes=300 scope=spfile;
alter system set session_cached_cursors=200 scope=spfile;
alter system set sga_target=2G scope=spfile;
alter system set shared_pool_size=600M scope=spfile;
alter system set pga_aggregate_target=1G scope=spfile;
alter system set job_queue_processes=20 scope=spfile;

2012/01/31

Oracle Database 11gR2 Installation (Oracle Linux 5.7)

Memory Requirement

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
To determine the RAM size, enter the following command:

# grep MemTotal /proc/meminfo

Available RAM	Swap Space Required
Between 1 GB and 2 GB	1.5 times the size of the RAM
Between 2 GB and 16 GB	Equal to the size of the RAM
More than 16 GB	16 GB

# grep SwapTotal /proc/meminfo

Package Requirment

The following or later version of packages for Asianux 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 must be installed:

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2

Oracle ODBC Drivers

On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5:

unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (64-bit) or later
unixODBC-2.2.11 (64-bit) or later

Create Required Operating System Groups and Users

The following local operating system groups and users are required if you are installing Oracle Database:

The Oracle Inventory group (typically, oinstall)
The OSDBA group (typically, dba)
The Oracle software owner (typically, oracle)
The OSOPER group (optional. Typically, oper)

To determine whether these groups and users exist, and if necessary, to create them, follow these steps:

To determine whether the oinstall group exists, enter the following command:
```
# more /etc/oraInst.loc
```
If the output of this command shows the oinstall group name, then the group exists.
If the oraInst.loc file exists, then the output from this command is similar to the following:
```
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
```
The inst_group parameter shows the name of the Oracle Inventory group, oinstall.
To determine whether the dba group exists, enter the following command:
```
# grep dba /etc/group
```
If the output from this commands shows the dba group name, then the group exists.
If necessary, enter the following commands to create the oinstall and dba groups:
```
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
```
To determine whether the oracle user exists and belongs to the correct groups, enter the following command:
```
# id oracle
```
If the oracle user exists, then this command displays information about the groups to which the user belongs. The output should be similar to the following, indicating that oinstall is the primary group and dba is a secondary group:
```
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)
```
If necessary, complete one of the following actions:
- If the oracle user exists, but its primary group is not oinstall or it is not a member of the dba group, then enter the following command:
```
# /usr/sbin/usermod -g oinstall -G dba oracle
```
- If the oracle user does not exist, enter the following command to create it:
```
# /usr/sbin/useradd -g oinstall -G dba oracle
```
  This command creates the oracle user and specifies oinstall as the primary group and dba as the secondary group.
Enter the following command to set the password of the oracle user:
```
# passwd oracle
```

Configuring Kernel Parameters

Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
Note:
Include lines only for the kernel parameter values to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value.

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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 = 1048586

sysctl –p

Check Resource Limits for the Oracle Software Installation Users

If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240

Creating Required Directories

# mkdir -p /u01/app/
# chown -R oracle:oinstall /u01/app/
# chmod -R 775 /u01/app/

Installation

./runInstaller

uncheck the checkbox, then Next

Yes

Create and configure a database, then Next

Choose Server Class, then Next

Choose Single instance database installation, then Next

Choose Typical install, then Next

Give Global database name, and Administrative password, note that there are some restrictions about the password, then Next

Give the oracle inventory directory and specify the oraInventory Group Name to oinstall, then Next

This part is weired, I cannot pass it, so I choose Ignore All, then Next

We're ready to install the database software, Finish

dbca is running

to keep use the same administrator password click OK

when the installer prompt you the instruction logon as root and run the script in specified directories

orainstRoot.sh

root.sh

The prompt screen, after finish previous two steps, then OK

The database in installed, enterprise manager can be accessed via https://yourhostname:1158/em

Appendix

5.2.8 Enabling and Disabling Database Options

When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the chopt tool. See Example 5-1.
The chopt tool is a command-line utility that is located in the ORACLE_HOME/bin directory. The syntax for chopt is:

chopt [ enable | disable] db_option

The possible values for db_option are described in the following table:

Value	Description
`dm`	Oracle Data Mining RDBMS Files
`dv`	Oracle Database Vault
`lbac`	Oracle Label Security
`olap`	Oracle OLAP
`partitioning`	Oracle Partitioning
`rat`	Oracle Real Application Testing
`ode_net`	Oracle Database Extensions for .NET 1.x
`ode_net_2`	Oracle Database Extensions for .NET 2.0

Example 5-1 Complete Example of Running the Chopt Tool
To enable the Oracle Label Security option in your Oracle binary files, use the following command:

cd %ORACLE_HOME%
srvctl stop database -d myDb
chopt enable lbac
srvctl start database -d myDb

Oracle Enterprise Manager Cloud Control Installation(Oracle Linux)

The installation begins…

We've done the previously prerequisite check
opt-out the option of security update via My Oracle Support if you don't have a Oracle Support account, then Next

Yes

Skip the Software Updates, then Next

We'll install a Simple Enterprise Manager System, and Middleware Home Location is the where you want to install the software (binary), Next

Input the Administrator Password twice and give the repository database connection information, then Next

Because my default Oracle 11g R2 database will install Database Control automatically, we need to follow the instruction to remove that Database Control on repository database.