Thursday, January 16, 2014

NodeManager not starting WLS 10.3.6 On Solaris 11 on SPARC: Java: Fatal: Libucb.so.1: Open Failed: No Such File Or Directory

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 ...

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