Monday, December 28, 2009
Exception in thread "main" java.lang.UnsatisfiedLinkError: owm2 (No such file or directory)
at java.lang.J9VMInternals.initializeImpl(Native Method)
To try to fix this error, we try to set the path for LD_LIBRARY_PATH to $ORACLE_HOME/lib but still the error persists. In the end , we found out that the error is due to the JDK , which we have upgrade from the existing 1.5 JDK to 1.6 JDK 64bit.
To fix it, we change the path in the file $ORACLE_HOME/bin/owm
to JRE_HOME=/ApplTop/ias10gr2/app/product/10.1.3/jdk.orig/jre/ (Points back to original 1.5 JDK)
Monday, October 19, 2009
" The process could not execute 'sp_replcmds' " and also
" Timeout expired (Source: ODBC SQL Server Driver (ODBC); Error number: 0)"
this is due to recent password changed.
To solved this , right click the Distributor -> choose configure Publisher and
distributor properties and choose -> Click on the Publishers/Distributors and the "..." in the lists below and then set the sa passsword.
Thursday, October 08, 2009
Oracle: Database for Debian installation guide
Installing Oracle XE on Debian
Installing Oracle XE on Debian
Tuesday, August 18, 2009
1. Goto $ORACLE_HOME/reports/conf/ , find your server report name e.g. TestReport.conf
2. find the connection maxConnect= and set it to a higher values.
3. Restart the reports services .
There is also a possibilities that after you increase to high value on the maximum database connection , the error still persists.
If so, then if your reports takes a long time to generated out and has many pages the possibilities are that the number of session in 1 reports engine more than the reports engine can handled.
Then you need to changed the engineid , engine id="rwEng" engLife="50" to lesser values such as 5 and increase your maxEngine from 1 to higher value like 5.
Monday, August 17, 2009
- Download the IBM Thread & Monitor Dump Analyzer for Java at http://www.alphaworks.ibm.com/tech/jca
- Follow the guide in How to Diagnose Java Resource Starvation http://java.sys-con.com/node/921279?page=0,1
- Use the JDK 1.5 to run the jca.jar and open the javacore*.txt file with all the same thread file name. e.g. javacore147902.xxxxx.txt
- In the Compare Monitors of the tool, you will noticed the blocked by 1. Clicked the blocked for more information. In the state, “Monitor”, the action is “Owns Monitor Lock on Heap Lock” , that means it is currently owning the lock when the dump is initiated.
- Notice the last thread information on the detail. If the information is something like below, then it is possible that your application is logging to many data in the logs file and caused the locking issue.
- In our case, the logging is set by the Log4j , which we found out that the settings is set to full debug mode, we changed it to WARN mode. "log4j.rootLogger=DEBUG, app" to "log4j.rootLogger=WARN, app" , more information at here http://www.laliluna.de/log4j-tutorial.html
- After this, our application server java core dump is greatly reduce.
Thursday, July 16, 2009
data id="java-options" value="-Xms1024m -Xmx2048m -Xss256k "
The Xms specified the start of the heap memory , Xmx , specified the maximum memory settings for the java container. the Xss specified to set the maximum native stack size for any thread.
Starts from the 512m for the memory settings and the xss128k until the issue can be resolved.
After that, dcmctl updateconfig to update the configuration.
For more information, on the using of this Java parameters, please refer to
Fine-Tuning Memory Usage of 32-Bit Java on AIX
Forum on Java Outofmemory issue,
Metalink Note : 298551.1
OPMN and Process Monitoring
Metalink Note : 823504.1
What are the minimum and maximum sizes recommended for Java heap configuration for OC4J?
exec dbms_scheduler.create_job(JOB_NAME => 'JOB_STATSPACK_SNAP',job_type=> 'PLSQL_BLOCK', JOB_ACTION => 'BEGIN STATSPACK.SNAP; END; ', START_DATE => trunc(sysdate) + 8/24 , REPEAT_INTERVAL => 'FREQ=HOURLY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=8,9,10,11,12,13,14,15,16,17,18,19,20', ENABLED => TRUE, AUTO_DROP =>FALSE, COMMENTS =>'Statpacks snap') ;
another example , would be below running in between the time 8am til 8pm with interval 15 mins
exec dbms_scheduler.create_job(JOB_NAME => 'JOB_STATSPACK_SNAP',job_type=> 'PLSQL_BLOCK', JOB_ACTION => 'BEGIN STATSPACK.SNAP; END; ', START_DATE => trunc(sysdate) + 8/24 , REPEAT_INTERVAL => FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI,SAT,SUN; BYHOUR=8,9,10,11,12,13,14,15,16,17,18,19;BYMINUTE=0,15,30,45', ENABLED => TRUE, AUTO_DROP =>FALSE, COMMENTS =>'Statpacks snap') ;
To check if your calendar string is correct , you can use below to do this.
l_start_date := trunc(SYSTIMESTAMP);
L_RETURN_DATE := L_START_DATE;
for ctr in 1..100 loop
'FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=8,20',
l_start_date, l_return_date, l_next_date
dbms_output.put_line('Next Run on: '
l_return_date := l_next_date;
Thursday, June 25, 2009
You need to create a view in the source DB to convert the lob to string using either view or materialized view.
or same as below, create a function / procedure to convert the lob to string.
you can use the following to workaround the issue.
create or replace function lobconverterproc
( col1 in varchar2) return varchar2
SELECT FYDSCR INTO var1 FROM tablename
select lobconverterproc('Test') from dual;
Monday, June 22, 2009
Other issue, is that it could be a bug as in the note “java.lang.NoClassDefFoundError: org/apache/log4j/Category After Upgrading from 10.1.3.1.0” ,Note ID : 460448.1
To resolved this follow the guide here
Sunday, June 21, 2009
2. For the Oracle® Containers for J2EE Configuration and Administration Guide, Using the admin_client.jar Utility please refered the link here.
3. Another important consideration in when migrating is that the default behaviour of the 10.1.3. 10.1.10 Invocation by Servlet Name without Mapping Is Disabled by Default
The 10.1.3.x Oracle Containers for J2EE Servlet Developer's Guide notes that by default, servlet invocation by class name is now disabled, but can be enabled through the property setting
-Dhttp.webdir.enable=true. (Servlet invocation by class name was enabled by default in versions 10.1.2.x and prior.)
What is similar, but undocumented, is that this also applies to invoking a servlet through its
value when there is no corresponding
entry. Invoking a servlet through its servlet name in this way was enabled by default in 10.1.2.x and prior, but requires the setting
-Dhttp.webdir.enable=true in 10.1.3.x versions.
For example, consider the following
web.xml entry, with no corresponding
In 10.1.2.x, you could access this servlet using
/servlet/TestIt without any property setting. In 10.1.3.x, you must set
-Dhttp.webdir.enable=true to access the servlet in this way with the given configuration.
Sunday, June 07, 2009
If you encounter these error "REP-56040: Server rep_
In MS Windows: %ORACLE_HOME%\bin\rwdiag.bat -findall
In Unix: $ORACLE_HOME/bin/rwdiag.sh -findAll
Broadcast mechanism used to locate servers------------------------------------------
Channel address = 18.104.22.168 Channel port = 14021
(1) Name =
(2) Name =
(3) Name =
(4) Name =
notice, that the report server services appear on the different hostname. In the rwservlet.trc,
Exception 51002 (): Bind to Reports Server
There's two way to resolve this , 1 way is to set different report_server name compare with other server or 2 , changing the naming method in the $ORACLE_HOME/reports/rwnetwork.conf
Uncoment the multicast and enabled the naming method. e.g.
multicast channel="22.214.171.124" port="14021" timeout="1000" retry="3"/
!--namingService name="Cos" host="%NAMING_HOST%" port="%NAMING_PORT%"/--
!-- multicast channel="126.96.36.199" port="14021" timeout="1000" retry="3"/--
namingService name="Cos" host="testserver" port="14021"
- Intermittent REP-51002 or REP-56040 and Same Repserver is Displayed Multiple Times in Rwdiag.sh Output, Note ID :563367.1
-REP-51002 And Rep-56040 if More than one OC4J_BI_FORMS Instance is Created, Note ID : 390412.1
Monday, May 18, 2009
Wednesday, May 06, 2009
HOW TO: Change the SQL Server Service Account Without Using SQL Enterprise Manager in SQL Server 2000
Monday, April 20, 2009
*ERROR at line 1:ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429ORA-06512: at line 1
This is a bug in the oracle 10g, to workaround this recreate the materialized view.
Friday, April 17, 2009
Recently, i have the problem of a query in a sp comparing null values and is unable to return values..
After going through this, found out that if a sp is created in query analyzer with null values setting is set to ANSI_NULL is set to on , the sp itself when run by user will take this settings.
"It is slightly more complicated to resolve ANSI_NULL problems when dealing with stored procedures, triggers and views as the ANSI_NULLS setting is saved when these objects are created or altered and is enabled (used) upon their execution. In other words, these objects inherit the ANSI settings of the user session that is used to creates them."
This is explain by the url below.
Understanding the Implications of ANSI SQL92 SET Options
Thursday, April 16, 2009
After checking the backups, found out that the only usable restoration is by using the backup tape. This is because the task to backup to tape reinitialized the transaction log , this caused the folder backup cannot be restored to point in time.
The point is, Make sure that if there are two backup policy ensure that both of them didn't clear the other one backup transaction log.
Monday, March 16, 2009
Log Directories In NFS Mounted Device Environment Causes Performance Problem With Apache , Note: 180522.1
Bad performance of Apache when filesystem is NFS mounted, Note : 467315.1
Monday, March 09, 2009
Then most probably you encounter the bug in oracle 10g. If the source package/procedure... is wrapped and uses mulitbyte character set when using the import data pump, it add extra line behind the wrap.
To workaround this , 1)use the imp/exp tools. 2) manually edit the source code to removed the extra lines. 3) Find and get the bug fixed patch in the metalink.
Impdp Returns ORA-39082 When Importing Wrapped Procedures
Metalink Note :- 460267.1
Thursday, February 26, 2009
Performance problem while starting up Opmnctl / Application for Oracle Application 10.1.2.0 in clustered
As higlighted , in the bug fixed for the 10.2.2.2 ,
In a clustered environment the command 'dcmctl updateConfig ..' in one node copies the orion-ejb-jar.xml to other node and as a result unnecessary redeployment of the j2ee application occurs in other node.
To check, goto both server of the clustered and compared the files at $ORACLE_HOME/j2ee/APP/application-deployments/AppName/AppName.jar/orion-ejb-jar.xml
You will also notice in the log files, if you have set the OC4J options -out
09/02/23 20:34:16 Auto-deploying - AppEJB.jar (orion-ejb-jar.xml had been updated since the previous deployment)...
Metalink Doc ID: 398955.1
Wednesday, February 25, 2009
If you encounter the below error, while installing your Oracle OID / Infrastructure , make sure that the /etc/hosts for both server contain your hostname and hostname.domain
LDAP error : ORA-31203: DBMS_LDAP: PL/SQL - Init Failed.
Eror: ORA-31203 (ORA-31203)
Text: DBMS_LDAP: PL/SQL - Init Failed.
Cause: There has been an error in the DBMS_LDAP Init operation. Action: Please check the host name in the hosts file and the port number to see if it's been taken up, or report the error number and description to Oracle Support.
Monday, January 19, 2009
PSSDIAG is a general purpose diagnostic collection utility that Microsoft Product Support Services uses to collect various logs and data files. PSSDIAG can natively collect Performance Monitor logs, SQL Profiler traces, SQL Server blocking script output, Windows Event Logs, and SQLDIAG output.
RML Utilities for SQL Server (x86)
Tools to help database administrators manage the performance of Microsoft SQL Server.
SQL Nexus Tool
Tool that helps you identify the root cause of SQL Server performance issues
DbDiff - DbScripting (without dmo,smo)
Compare MSSql database structures. (Sql 7,Sql 2000,Sql 2005)
Thursday, January 15, 2009
If the DBCC checkdb , returns error such as below, that means that the clustered index (index ID 0) could have been corrupted and data loss is a possiblities.
Server: Msg 8928, Level 16, State 1, Line 1Object ID 1335232803, index ID 0: Page (1:14469854) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1Table error: Object ID 1335232803, index ID 0, page (1:14469854). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8928, Level 16, State 1, Line 1Object ID 1335232803, index ID 0: Page (1:14469855) could not be processed. See other errors for details.Server: Msg 8928, Level 16, State 1, Line 1
If the Index ID is more than 1 , then only the index is spoilt.
After determining, the Page id we can get the raw data by using the below command. The 3 that's means formatted data and the 2 is the raw data.
DBCC TRACEON (3604);
DBCC PAGE ('DB', 1, 14469854, 3);
After this, we can find out the primary key of the tables . Based on this we can restored the data from the backup to here.
Another way is to restore the page data, this is only can be done minimumly in sql 2005
SQL Server in Recovery by Paul S. Randal.
Fixing damaged pages using page restore or manual inserts
Thursday, January 08, 2009
If you encounter this error, while restoring your sharepoint to another share point server,
Object Project Server Application failed in event OnPostRestore. For more information, see the error log located in the backup directory. SqlException: Access to module dbo.proc_MIP_GetObjectVersion is blocked because the signature is not valid.
This is could be due to that the shared services cannot be install in SQL server 2005 embedded version. The error when creating a new shared services "SSP Databases cannot be created in the Windows Internal Database; they must be created in SQLExpress or a full SQL Server installation"
or these error
Access to the table dbo.sites is blocked because the signature is not valid.
Access to module dbo.proc_GetCurrent is blocked because the signature is not valid.
Please follow the below guide,
This will provision the SPWebService service has not been fully provision after we restored.http://kbalertz.com/944154/receive-error-message-browse-SharePoint-collections-after-hotfix-package-public-update-Windows-SharePoint-Services-applied.aspx
If you still has error, then follow this guide to Restore a shared service provider administration site.
To check the shared services db is the problem , login to ms sql and query the shared_services1_db tables and you will see error.
Tuesday, January 06, 2009
Using PDF in Oracle Reports
which included Comparison of PDF Font Features ( which is interesting to note)
Resolving Cross-Platform Porting Issues
Managing oracle fonts in Oracle Reports