Tip #1: Finding the CPU cache sizes from Solaris operating environment Use the prtpicl utility to list out system configuration, and look for the cache sizes within that output. eg., $ prtpicl -v |grep cache :l1-icache-size 0x10000 :l1-icache-line-size 0x40 :l1-icache-associativity 0x2 :l1-dcache-size 0x10000 :l1-dcache-line-size 0x40 :l1-dcache-associativity 0x2 :l2-cache-size 0x500000 :l2-cache-line-size 0x100...
Friday, 28 December 2012
Friday, 23 November 2012
emca fails with "Database instance is unavailable" though available
Posted on 09:33 by Unknown
The following example shows the symptoms of failure, and the exact error message. $ emca -repos create...Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: YNov 19, 2012 10:33:42 AM oracle.sysman.emcp.DatabaseChecks checkDbAvailabilityImplWARNING: ORA-01034: ORACLE not availableNov 19, 2012 10:33:42 AM oracle.sysman.emcp.DatabaseChecks throwDBUnavailableExceptionSEVERE: Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.Some of the possible reasons may be : 1) Database may not be...
Monday, 15 October 2012
Consolidating Oracle E-Business Suite R12 on Oracle's SPARC SuperCluster
Posted on 16:45 by Unknown
An Optimized Solution for Oracle E-Business Suite (EBS) R12 12.1.3 is now available on oracle.com. The Oracle Optimized Solution for Oracle E-Business Suite This solution was centered around the engineered system, SPARC SuperCluster T4-4. Check the business and technical white papers along with a bunch of relevant useful resources online at the above optimized solution page for EBS.What is an Optimized Solution?Oracle's Optimized Solutions are designed, tested and fully documented architectures that are tuned for optimal...
Monday, 24 September 2012
E-Business Suite : Role of CHUNK_SIZE in Oracle Payroll
Posted on 00:14 by Unknown
Different batch processes in Oracle Payroll flow have the ability to spawn multiple child processes (or threads) to complete the work in hand. The number of child processes to fork is controlled by the THREADS parameter in APPS.PAY_ACTION_PARAMETERS view. THREADS parameter The default value for THREADS parameter is 1, which is fine for a single-processor system but not optimal for the modern multi-core multi-processor systems. Setting the THREADS parameter to a value equal to or less than the total number of [virtual] processors available on the...
Friday, 3 August 2012
Enabling 2 GB Large Pages on Solaris 10
Posted on 00:15 by Unknown
Few facts:- 8 KB is the default page size on Solaris 10 and 11 as of this writing- both hardware and software must have support for 2 GB large pages- SPARC T4 hardware is capabile of supporting 2 GB pages- Solaris 11 kernel has in-built support for 2 GB pages- Solaris 10 has no default support for 2 GB pages- Memory intensive 64-bit applications may benefit the most from using 2 GB pagesPrerequisites:OS: Solaris 10 8/11 (Update 10) or laterHardware: SPARC T4. eg., SPARC T4-1, T4-2 or T4-4Steps to enable 2 GB large pages on Solaris 10:Install the...
Sunday, 29 July 2012
[OID] ldap_modify: Failed to find member in mandatory or optional attribute list
Posted on 19:51 by Unknown
A sample LDAP entry and the resulting error message are shown below. The objective is simple - adding a new member (employee) to an existing group (Administrators).% cat assigngrp.ldifdn: cn=Administrators,ou=groups,ou=entappchangetype: modifyadd: membermember: cn=emp1234,ou=people,ou=entapp% ldapmodify -p 3060 -h localhost -D "cn=orcladmin" -w passwd -f assigngrp.ldifadd member: cn=emp1234,ou=people,ou=entappmodifying entry cn=Administrators,ou=groups,ou=entappldap_modify: Object class violationldap_modify: additional info: Failed to find member...
Saturday, 30 June 2012
Session Sharing with another User on *NIX and Windows
Posted on 23:31 by Unknown
Oracle SolarisSince Solaris is not widely known for its graphical interface, let's just focus on sharing a terminal session in read-only mode with another user on the same system. Here is an example.eg.,% fingerLogin Name TTY Idle When Whereroot Super-User pts/1 Sat 16:57 dhcp-amer-vpn-rmdc-asunperf ??? pts/2 4 Sat 16:41 pitcher.sfbay.sun.comIn this example, two users root and sunperf are connected to the same system from two different terminals pts/1 and...
Tuesday, 12 June 2012
Oracle E-Business Suite Tip : SQL Tracing
Posted on 01:22 by Unknown
Issue:Attempts to enable SQL tracing from concurrent request form fails with error:Function not available to this responsibility. Change Responsibilities or contact your System AdministratorResolution:Switch responsibility to "System Administrator". Navigate to System -> Profiles, and query for "%Diagnostics% ("Utilities : Diagnostics")". Once found the profile, change its value to "Yes". Restart web browser and try enabling SQL trace aga...
Tuesday, 8 May 2012
OBIEE 11g: Resolving Presentation Services Startup Failure
Posted on 21:45 by Unknown
ISSUE:Starting Presentation Services fail with the error:[OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] Authentication Failure.Odbc driver returned an error (SQLDriverConnectW).State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.[nQSError: 43113] Message returned from OBIS.[nQSError: 43126] Authentication failed: invalid user/password. (08004)[[Also connecting to the metadata repository (RPD) in online mode fails with similar...
Friday, 27 April 2012
Solaris Volume Manager (SVM) on Solaris 11
Posted on 23:35 by Unknown
SVM is not installed on Solaris 11 by default.# metadb-bash: metadb: command not found# /usr/sbin/metadb-bash: /usr/sbin/metadb: No such file or directoryInstall it using pkg utility.# pkg info svmpkg: info: no packages matching the following patterns you specified areinstalled on the system. Try specifying -r to query remotely: svm# pkg info -r svm Name: storage/svm Summary: Solaris Volume Manager Description: Solaris Volume Manager commands Category: System/Core State: Not installed Publisher: solaris...
Friday, 30 March 2012
Resolving "PLS-00201: identifier 'DBMS_SYSTEM.XXXX' must be declared" Error
Posted on 18:47 by Unknown
Here is a failure sample. SQL> set serveroutput onSQL> alter package APPS.FND_TRACE compile body;Warning: Package Body altered with compilation errors.SQL> show errorsErrors for PACKAGE BODY APPS.FND_TRACE:LINE/COL ERROR-------- -----------------------------------------------------------------235/6 PL/SQL: Statement ignored235/6 PLS-00201: identifier 'DBMS_SYSTEM.SET_EV' must be declared.. By default, DBMS_SYSTEM package is accessible only from SYS schema. Also there is no public synonym created for this package. So, the solution...
Tuesday, 28 February 2012
Oracle RDBMS & Solaris : Few Random Tips (Feb 2012)
Posted on 17:57 by Unknown
These tips are just some quick solutions or workarounds. Use these quickies at your own risk. [#1] Oracle Data Pump Q: How to exclude the table definition while importing a table using Oracle Data Pump import utility? A: Use EXCLUDE=TABLE/TABLE option. eg., impdp login/password DUMPFILE=<DUMP_FILENAME> LOGFILE=<LOGFILE_NAME> \ DIRECTORY=<DB_DIR_NAME> TABLES=<TABLE_NAME> EXCLUDE=TABLE/TABLE [#2] Workaround to ORA-01089: immediate shutdown in progress - no operations are permitted When the database is in the middle of an...
Tuesday, 17 January 2012
Solaris Tip: How-To Identify Memory Mapped Files
Posted on 18:46 by Unknown
A memory mapped (mmap'd) file is a shared memory object, or a file with some portion or the whole file was mapped to virtual memory segments in the address space of an OS process. Here is one way to figure out if a given object (file or shared memory object) was memory mapped in a process or not. find the file system inode number of the object look for that inode number in the address space of a given process And here is an example. We are about to check a log file and a shared memory segment in a Siebel object manager's process address space....
Wednesday, 4 January 2012
Unwanted Software Installers
Posted on 23:43 by Unknown
After all these years of software evolution, it is odd to see not much improvement in the area of software installation. Customers do not seem to mind dealing with different, complex installers. Nevertheless this whole process can be simplified to save time, effort and energy.In an ideal world, a software installer is supposed to have just one function - copying the software bits to a designated location and nothing else. However today we interact with different installers that does variety of things -- some install the pre-compiled binaries, few...
Subscribe to:
Posts (Atom)
