I Published Some Scripts that every DBA Needs, these Scripts available for everyone, I used GitHub to Upload the scripts, this Blog post will be updated and will contains new scripts.
The Scripts Here.
Cheers
Osama ….
BLOG
Linux : Cannot Access …. Input/output error
/bin/ls: reading directory .: Input/output error
total 0
The above error indicate that i cannot access to the specific file on Linux, Delete not working. with root user as well.
so the error is not a problem to delete files, it’s a problem about the file system itself and/or an hardware problem, but before announce that it’s hardware issue 🙂 try the below solution :-
Option #1:-
use command dmesg.
(display message or driver message) is a command on most Linux- and Unix-based operating systems that prints the message buffer of the kernel. Read about that command here
Option #2 ( worked for me)
Use Fsck command to detect filesystem error and fix it.
How !!!
- First Umount File system ( that file located ). Using Umount command if it’s not able to un mount the file system use lsof command or fuser to check which user using this filesystem.
- run the fsck -y /dev/……………..
- mount file system again.
Fsck Command here
Cheers
Osama …
TT6003: Lock request denied because of time-out
Trying to create cache group lead to the below error :-
java.sql.SQLException: [TimesTen][TimesTen 11.2.1.4.0 ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out
Details: Tran 143.23106 (pid 19946) wants Sn lock on rowid BMUFVUAAAAxogAALDp, table SUBSCRIBER. But tran 144.67398 (pid 19946) has it in Xn (request was Xn). Holder SQL (select ID,identifierType,identifiervalue,subscriberId,groupName,siid from subscriptionidentifie…) — file “tindex.c”, lineno 4277, procedure “sbTixNext()”
After check the Timesten parameter found the issue was with LockWait
Lockwait :- Allows an application to configure the lock wait interval for the connection.
LockWait may be set to any value between 0 and 1,000,000 inclusive to a precision of
tenths of a second. The default is 10 seconds.
Actual lock wait response time is imprecise and may be exceeded by up to one tenth of
a second, due to the scheduling of the agent that detects timeouts. This imprecision
does not apply to zero second timeouts, which are always reported immediately.
Cheers
Osama …
Attempt to connect to a data store that has been manually unloaded from R AM
Timesten in-memory Database :-
ttisql DSN_NAME
ttIsql (c) 1996-2005, TimesTen, Inc. All rights reserved.
Type ? or “help” for help, type “exit” to quit ttIsql.
All commands must end with a semicolon character.
connect “DSN=DSN_NAME”;
707: Attempt to connect to a data store that has been manually unloaded from R
AM
The command failed.
This should be easy to resolve. A TimesTen datastore (physical database), which is what a DSN points at, has a property called its ‘ramPolicy’ The default value for this is inUse which means that TimesTen will load the datastore into memory whenever it is being used.
Solution :
ttAdmin -ramload DSN_NAME
Reference :-
1- Oracle OTN Forum here
Cheers
Osama ….
Cannot Integrated JDeveloper with SOA Server
When trying to integrated JDeveloper with SOA server the below error Appeared :-
Testing JSR-160 Runtime … failed.
Cannot establish connection.
Testing JSR-160 DomainRuntime … skipped.
Testing JSR-88 … skipped.
Testing JSR-88-LOCAL … skipped.
Testing JNDI … skipped.
Testing JSR-160 Edit … skipped.
Testing HTTP … success.
Testing Server MBeans Model … skipped.
all my searching on internet not working most of the blogs indicate it’s proxy setting which is already disables in my case.
After invesgtation and check logs on the both side adminserver and Jdeveloper i found it’s DNS server issue therefore i edited hosts in windows like the below
Adminserver-IP Hostname
After do this and put hostname instead of IP it’s worked Successfully.
Cheers
Osama Mustafa
OWB GUI Is Slow
Sometimes the default setting is not enough , therefore you need to apply some changes depend on your requirement and the work load. Today while working on OWB I faced huge slowness while open , mapping or even press any button.
to solve this issue all you have to do increasing JVM, to do this follow the below steps :-
- Depend on OS, Open the following File :-
- Windows :- C:\oracle\product\owb11_1\owb\bin\win32\owbclient.bat
Or
- Linux : $ORACLE_HOME/owb11_1\owb\bin\win32\owbclient.bat.
This file will indicate to setownenv.sh or setowbenv.bat usually in the same path. Open it with any editor.
be careful while adding this file If you notice or read this file there is more than one line looking the same, these lines only depend on OS for example in my case i am working on LINUX then i have to add Line that indicate for Linux only.
Next to the line -d64 add new parameter -Xmx=1024M or depend on your work.
Restart OWB now.
Cheers.
Osama Mustafa
Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..
Connection test failed with the following exception: weblogic.common.resourcepool.ResourceDisabledException: Pool EDNLocalTxDataSource is Suspended, cannot allocate resources to applications..
This Error Appeared on Weblogic Depend on Managed Server, Tuning Connection Pool By Increasing Maximum Capacity parameter in Datasource.
My Case Datasource EDNLOCALTXDatasource as the above error.
Solution :-
Increase depend on your application.
Thank you
Osama Mustafa
Oracle SOA Tablespace Is full
When Creating Domain for Oracle SOA it’s Mandatory to Run Oracle RCU before to create SOA Repository, This will create tables configuration and information about Oracle SOA.
But What happened the this tablespace was getting full, increase it 20GB is not enough which mean it’s strange case and not acceptable.
after investigation Table Called “REFERENCE_INSTANCE” include information about Running Composite in SOA ans instances. the size for this table 18GB.
Select * from Reference_instance;
Check the data in the above query, just in case you can use export data-bump utility for this table, however after this Truncate the table and from full tablespace toonly 2% usage.
Thank you
Osama Mustafa
NP_SOAINFRA.WL_LLR_ADMINSERVER Access Failed
java.sql.SQLException: JDBC LLR, table verify failed for table ‘NP_SOAINFRA.WL_LLR_ADMINSERVER’, row ‘JDBC LLR Domain//Server’ record had unexpected value
The above error appeared when trying to start Adminserver nothing changed on the Domain
Solution :-
- Goto domain location –> config folder.
- remove this line from the config.xml file, Take backup before you do this.
wlsbjmsrpDataSource
AdminServer,osb_server1
jdbc/wlsbjmsrpDataSource-jdbc.xml
Thank you
Osama Mustafa
Resource temporarily unavailable in tsStartJavaThread
Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 3G reserved, 3G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx: (e.g. “-
java.lang.OutOfMemoryError: Resource temporarily unavailable in tsStartJavaThread (lifecycle.c:1096).
Java heap 6G reserved, 6G committed
Paged memory=3145728/36425712K.
Your Java heap size might be set too high.
Try to reduce the Java heap size using -Xmx:
The Above error appeared on OEDQ when trying to run the process this error related to Java Heap Size the OS control the Heap Size to solve this issue add the below parameters depend on your enviroment :-
- Add the following to /etc/sysctl.conf:
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 4194304
net.core.wmem_max = 4194304
fs.file-max = 134283264
fs.aio-max-nr = 1048576
vm.min_free_kbytes = 512000
- Add the following to /etc/security/limits.conf:
oracle soft nproc 16384
oracle hard nproc 63536
oracle soft nofile 16384
oracle hard nofile 63536
- Add the following to /etc/pam.d/login:
session required /lib/security/pam_limits.so
Thank you
Osama Mustafa
Technology Geek 