Applies to:
Oracle Weblogic Server - Version 10.3.6 and later
Oracle Solaris on SPARC (32-bit)
Oracle Solaris on SPARC (64-bit)
SPARC
Sun SPARC Sun OS
Symptoms
Node Manager fails to start in WLS 10.3.6 running on Solaris 11 on SPARC. The following error is seen in the node manager logs:
Mar 04, 2013 3:10:55 PM weblogic.nodemanager.server.NMServer main
SEVERE: Fatal error in node manager server
weblogic.nodemanager.common.ConfigException: Native version is enabled but nodemanager native library could not be loaded
at weblogic.nodemanager.server.NMServerConfig.initProcessControl(NMServerConfig.java:269)
at weblogic.nodemanager.server.NMServerConfig.(NMServerConfig.java:210)
at weblogic.nodemanager.server.NMServer.init(NMServer.java:182)
at weblogic.nodemanager.server.NMServer.(NMServer.java:148)
at weblogic.nodemanager.server.NMServer.main(NMServer.java:380)
at weblogic.NodeManager.main(NodeManager.java:31)
Caused by: java.lang.UnsatisfiedLinkError: /u01/app/weblogic/wls10.3.6/wlserver_10.3/server/native/solaris/sparc/libnodemanager.so: ld.so.1: java: fatal: libucb.so.1: open failed: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary1(ClassLoader.java:1939)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1864)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1854)
at java.lang.Runtime.loadLibrary0(Runtime.java:845)
at java.lang.System.loadLibrary(System.java:1084)
at weblogic.nodemanager.util.UnixProcessControl.(UnixProcessControl.java:24)
at weblogic.nodemanager.util.ProcessControlFactory.getProcessControl(ProcessControlFactory.java:22)
at weblogic.nodemanager.server.NMServerConfig.initProcessControl(NMServerConfig.java:267)
... 5 moreCause
libucb.so.1 is not obsolete in Solaris 11 but it is not installed by default. So the ucb resources are not available until your Solaris sysadmin installs them. See http://www.oracle.com/technetwork/systems/solaris-developer/o10-015-s11-isv-adoption-198348.pdf for changes to the ucb directory in Solaris 11.
Solution
Have your Solaris sysadmin install the compatibility/ucb package from http://pkg.oracle.com/solaris/release/en/index.shtml and the ucb libraries should be available. See https://forums.oracle.com/forums/thread.jspa?messageID=10512396 for more instructions.
And the set the env variable
export LD_LIBRARY_PATH=/u01da/MW_Home/wlserver_10.3/server/native/solaris/sparc:/lib/
PS: No need to set any soft link
After installing the library I was able to start the node manager succesfully ...
Thursday, January 16, 2014
Tuesday, January 7, 2014
Automatic Storage Management
What's ASM and how it works?
http://ora-x2.blogspot.com/2011/05/whats-asm-and-how-it-works.html#!/2011/05/whats-asm-and-how-it-works.html
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/10g/r2/prod/install/asminst/asminst_otn.htm?cid=4507&ssid=103147333707116
This article provides a general insight on working of Oracle ASM and the associated admin tasks.
Oracle ASM is a volume manager and a file system for Oracle database files that supports single-instance Oracle Database and Oracle Real Application Clusters (Oracle RAC) configurations.
Oracle ASM uses disk groups to store data files; an Oracle ASM disk group is a collection of disks that Oracle ASM manages as a unit. Within a disk group, Oracle
ASM exposes a file system interface for Oracle database files. The content of files that are stored in a disk group is evenly distributed to eliminate hot spots and to provide uniform performance across the disks. The performance is comparable to the performance of raw devices.
The Oracle ASM normal and high redundancy disk groups enable two-way and three-way mirroring respectively. You can use external redundancy to
enable a Redundant Array of Independent Disks (RAID) storage subsystem to perform the mirroring protection function.
You can add or remove disks from a disk group while a database continues to access files from the disk group. When you add or remove disks from a disk group, Oracle ASM automatically redistributes the file contents and eliminates the need for downtime when redistributing the content.
Oracle ASM also uses the Oracle Managed Files (OMF) feature to simplify database file management. OMF automatically creates files in designated locations. OMF also names files and removes them while relinquishing space when tablespaces or files are deleted.
Oracle ASM Files
Files that are stored in Oracle ASM disk groups are called Oracle ASM files. Each Oracle ASM file is contained within a single Oracle ASM disk group. Oracle Database communicates with Oracle ASM in terms of files. This is similar to the way Oracle Database uses files on any file system. You can store the various file types in Oracle ASM disk groups, including:
· Control files
· Data files, temporary data files, and data file copies
· SPFILEs
· Online redo logs, archive logs, and Flashback logs
· RMAN backups
· Disaster recovery configurations
· Change tracking bitmaps
· Data Pump dumpsets
Striping in ASM explained :
Oracle ASM striping has two primary purposes:
· To balance loads across all of the disks in a disk group
· To reduce I/O latency
Coarse-grained striping provides load balancing for disk groups while fine-grained striping reduces latency for certain file types by spreading the load more widely.
Lets first understand how the files are stored in ASM.
The lowest level of granularity in ASM in "Allocation Unit " (AU) . When you create a disk group, you can set the Oracle ASM allocation unit size with the AU_SIZE disk group attribute. The values can be 1, 2, 4, 8, 16, 32, or 64 MB, depending on the specific disk group compatibility level. Larger AU sizes typically provide performance advantages for data warehouse applications that use large sequential reads
Next comes the EXTENT . All files in ASM are stored as set or collection of extents. An extent is made up of multiple Allocations units (AU) . Each extent fits in one single disk. To accommodate increasingly larger files, Oracle ASM uses variable size extents.
OK with the above AU and Extents explained, lets continue with Striping :
To stripe data, Oracle ASM separates files into stripes and spreads data evenly across all of the disks in a disk group. The fine-grained stripe size always equals 128 KB in any configuration; this provides lower I/O latency for small I/O operations. The coarse-grained stripe size is always equal to the AU size (not the data extent size).
Figures 1 is illustrations of Oracle ASM file striping. In both illustrations, the allocation unit size has been set to 1 M (AU_SIZE = 1M) for the disk
group which consists of 8 disks. The Oracle ASM instance is release 11.2 and the disk group compatibility attributes for ASM and RDBMS have been set to 11.2, so variable extents are shown in the graphic
Figure 1
Discovering Disks in ASM
The disk discovery process locates the operating system names for disks that Oracle ASM can access. Disk discovery finds all of the disks that comprise a disk group to be mounted. The set of discovered disks also includes disks that could be added to a disk group.
An Oracle ASM instance requires an ASM_DISKSTRING initialization parameter value to specify its discovery strings. Only path names that the Oracle ASM instance has permission to open are discovered. The exact syntax of a discovery string depends on the platform, ASMLIB libraries, and whether Oracle Exadata disks are used.
For example:
For general storage : ASM_DISKSTRING = '/dev/raw/disk*'
For Exadata: ASM_DISKSTRING = 'o/*/data*'
Make sure to change the device permissions to read/write and ownership to grid:asmadmin or oracle:dba ( the owner of the disk devices should be the same as the owner of the Oracle binary software. The group ownership should be OSDBA of the Oracle ASM instance, which is defined at installation)
How to maintain it?
Let’s talk about some general administrative tasks that you would be doing.
Some useful queries
· Checking which instances are served by the ASM and which diskgroups belong to which DB, with V$ASM_CLIENT view
SQL> SELECT dg.name AS diskgroup, SUBSTR(c.instance_name,1,12) AS instance,
SUBSTR(c.db_name,1,12) AS dbname, SUBSTR(c.SOFTWARE_VERSION,1,12) AS software,
SUBSTR(c.COMPATIBLE_VERSION,1,12) AS compatible
FROM V$ASM_DISKGROUP dg, V$ASM_CLIENT c
WHERE dg.group_number = c.group_number;
· Checking which disks belong to the Diskgroups with v$ASM_DISKGROUP and v$ASM_DISK
SQL> SELECT SUBSTR(d.name,1,16) AS asmdisk, d.mount_status, d.state,
dg.name AS diskgroup FROM V$ASM_DISKGROUP dg, V$ASM_DISK d
WHERE dg.group_number = d.group_number;
· Check available free space in disk groups
SQL> select group_number "Group", disk_number "Disk",
path "Path", header_status,
trunc(free_mb/1024) "Free GB",
trunc(total_mb/1024) "Total GB",
round(free_mb/total_mb, 3)*100 "Pct Free"
from v$asm_disk
/
· Viewing Intelligent Data Placement information with V$ASM_FILE
SQL> SELECT dg.name AS diskgroup, f.file_number, f.primary_region, f.mirror_region, f.hot_reads,
f.hot_writes, f.cold_reads, f.cold_writes
FROM V$ASM_DISKGROUP dg, V$ASM_FILE f
WHERE dg.group_number = f.group_number and dg.name = 'DATA';
Create GRID Disks
For Exadata only :
CellCLI> CREATE GRIDDISK ALL PREFIX=sales, size=75G
Create Disk Groups
The SQL statement in Example below creates a disk group named data with normal redundancy consisting of two failure groups controller1 or controller2 with
four disks in each failure group. The data disk group is typically used to store database data files.
Creating the DATA disk group
CREATE DISKGROUP data NORMAL REDUNDANCY
FAILGROUP controller1 DISK
'/devices/diska1' NAME diska1,
'/devices/diska2' NAME diska2,
'/devices/diska3' NAME diska3,
'/devices/diska4' NAME diska4
FAILGROUP controller2 DISK
'/devices/diskb1' NAME diskb1,
'/devices/diskb2' NAME diskb2,
'/devices/diskb3' NAME diskb3,
'/devices/diskb4' NAME diskb4
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '11.2',
'compatible.advm' = '11.2';
Checking ASM alert log
All the ASM related files are stored under $ORACLE_BASE/diag or the directory that you list in the init.ora DIAGNOSTIC_DEST initialization parameter
$ ls $ORACLE_BASE/diag/asm/+asm/+ASM
alert cdump hm incident incpkg ir lck metadata stage sweep trace
Note : You can do all the tasks using oracle database console or Enterprise manager grid control GUI.
General Helpful commands:
# Start / Stop ASM and Listener
srvctl stop listener
srvctl start listener
srvctl stop asm
srvctl start asm
srvctl status asm
# Connect to local/remote ASM isntance
$ sqlplus / as sysasm (local connection )
$ sqlplus sys@\"myhost.mydomain.com:1521/+ASM\" AS SYSASM (remote connection)
Other considerations:
Disk Sizing
The number of disks required depends on the size of your database.
At the minimum its recommended to have two disk groups. One for Data and one for Recovery area. Each diskgroup should have a minimum of four grid disks for better performance.
Keep all the disks of same size and performance in the diskgroup.
ASM Disk Rebalancing
Oracle ASM automatically initiates a rebalance after storage configuration changes, such as when you add, drop, or resize disks. The power setting parameter determines the speed with which rebalancing operations occur.
You can minimize the impact on database performance with the setting of the POWER_LIMIT initialization parameter.
Backup the ASM binaries and init.ora files
Remember to backup your ORACLE_HOME and GRID_INFRASTRUCTURE binaries using OS backup tools.
For 11.2 you can move the ASM init.ora to one of the diskgroups. The disk group COMPATIBLE.ASM should be set to 11.2
$ sqlplus / as sysasm
SQL> CREATE SPFILE = '+DATA/asmspfile.ora' FROM PFILE = '$ORACLE_HOME/dbs/asmpfile.ora';
If you create the spfile to some other location then, create a PFILE with one line in it that identifies the path to the SPFILE.
For example:
Create the /u01/oracle/dbs/spfileasm_init.ora file that contains:
SPFILE='+DATA/asm/asmparameterfile/asmspfile.ora'
Alternatively use the ASMCMD to fix the auto lookup
ASMCMD> spset +DATA/asm/asmparameterfile/asmspfile.ora
Restart the ASM to read the new spfile.
Oracle E-Business Suite Installation Guide: Using Rapid Install Release 12.2 (12.2.0)
Oracle E-Business Suite Installation Guide: Using Rapid Install Release 12.2 (12.2.0)
Part Number E22950-15
Getting Started
This chapter contains basic information about using Rapid Install to install or upgrade an Oracle E-Business Suite system, a general description of the Rapid Wizard interface, and a description of the setup steps you must complete before you begin an installation or upgrade.
This chapter covers the following topics:
How Rapid Install Works
Installed Components and System Requirements
Before You Install
Starting Rapid Install
Gathering Configuration Information
What To Do Next
How Rapid Install Works
With Rapid Install, you can perform the following tasks:
Install a new, fully configured Oracle E-Business Suite system, including the latest certified Oracle E-Business Suite technology stack and patches, product family release update packs, release update packs, and other updates available at the time of this Oracle E-Business Suite release.
Lay down the file system and configure server processes for an upgraded system.
Rapid Install employs a wizard that guides you through the screens used to carry out the selected task. On the wizard screens, you enter configuration values for your system; these will typically be saved in the Oracle E-Business Suite database for later use.
Previous releases of Oracle E-Business Suite only used a text file, config.txt, to store the supplied configuration values. The name of this configuration file includes the database SID, to give a file name of conf_.txt (for example, conf_PROD.txt). This file stores the information collected by Rapid Install for all database and Applications nodes.
Rapid Install stores copies of the conf_.txt file in three separate locations:
Database 11gR2 /appsutil: This copy is used on database nodes, on Applications nodes in multi-node installs, and in upgrades. It is permanently stored and not deleted.
$INST_TOP: This copy is used on Applications nodes in multi-node installs, and in upgrades. It is permanently stored and not deleted.
/tmp/
JDK 7 Installation on the Oracle Solaris Operating System and to check the version of jdk in 32 bit and 64 bit
http://docs.oracle.com/javase/7/docs/webnotes/install/solaris/solaris-jdk.html
To check the jdk version
The output that you show from java -version is from a 32-bit version. If it is 64-bit, you'll see something like "64-bit Server VM" in there instead of "Client VM".
java -d64 -version
If it's not a 64-bit version, you'll get a message that looks like:
This Java instance does not support a 64-bit JVM. Please install the desired version.
http://docs.oracle.com/javase/7/docs/webnotes/install/solaris/solaris-jdk.html
Wednesday, January 1, 2014
Informatica PowerCenter and PowerConnect Adapters 9.5.1 Download
Please follow the below steps to download Informatica PowerCenter and
PowerConnect Adapters 9.5.1 and Oracle Business Intelligence Data Warehouse
Administration Console 11g
Step 1 : Go to edelivery.oracle.com
Step 2 :Click on Sign In (give your emaild id and password )
Step 3: Accept the Terms and Conditions and Export Restrictions .
Step 4 :Select a Product Pack Oracle Business Intelligence
Platform : Microsoft Windows x64 (64-bit)
Click Go
Step 5: Oracle Business Intelligence 11g Media Pack for Microsoft Windows x64
(64-bit)
Click Continue
Step 6:
Download Oracle Business Intelligence Data Warehouse Administration Console
11g and Informatica PowerCenter and PowerConnect Adapters 9.5.1 for Windows x86
(64-bit) (Part 1 of 4) V41973-01 Part 1 of 4 867M
Download Oracle Business Intelligence Data Warehouse Administration Console
11g and Informatica PowerCenter and PowerConnect Adapters 9.5.1 for Windows x86
(64-bit) (Part 2 of 4) V41973-01 Part 2 of 4 2.0G
Download Oracle Business Intelligence Data Warehouse Administration Console
11g and Informatica PowerCenter and PowerConnect Adapters 9.5.1 for Windows x86
(64-bit) (Part 3 of 4) V41973-01 Part 3 of 4 2.0G
Download Oracle Business Intelligence Data Warehouse Administration Console
11g and Informatica PowerCenter and PowerConnect Adapters 9.5.1 for Windows x86
(64-bit) (Part 4 of 4) V41973-01 Part 4 of 4 2.0G
Step 7: whoooooooooooom
Subscribe to:
Posts (Atom)