Recently while zipping a few directories for a clone, I got this error when the file size became greater than 2 GB.
File too large
zip error: Output file write failure (write error on zip file)
I tested the file system's ability to create files greater than 2 GB by creating a dummy 3GB file:
dd if=/dev/zero of=3gb-file bs=1024k count=3000
The 3 GB file got created without issues.
Then I checked the zip version.
$ zip -v
Copyright (c) 1990-2006 Info-ZIP - Type 'zip "-L"' for software license.
This is Zip 2.32 (June 19th 2006), by Info-ZIP.
Currently maintained
(more...)
Raghava asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:
select language_code
from fnd_languages
where installed_flag='I'
For currencies, I told him that in EBS all currencies are enabled. I executed the following query:
select CURRENCY_CODE,symbol
from apps.fnd_currencies
where enabled_flag='Y'
It returned 71 rows.
Total rows in fnd_currencies was 249.
However, I thought of a more logical way of getting this data. That would be to query transaction tables. Which transaction table to query here ? I queried dba_segments for the largest objects:
select object_name,bytes
from dba_segments
(more...)
In SOA Suite the inspection.wsil URL is:
http://soahostname:soaport/inspection.wsil
However this was showing the physical hostname of the server on which SOA Suite was installed. We had configured SOA to listen on virtual names. Rajiv Bhalla provided the solution to this problem by providing the My Oracle Support Article: Applications like Oracle IPM fail to retrieve WSDL's to SOA composites via URL's that use different protocol/hostname/port than they are configured to [ID 1290812.1]
Solution
1.Access the WebLogic server Admin console: e.g. http://host:port/console.
2.From the left pane, use the following path through the hierarchical menu to
(more...)
./startManagedWebLogic.sh soa_server1
SOA Managed Server wouldn't start with this error:
BEA-141281 unable to get file lock, will retry
cd $MW_HOME/user_projects/domains/soa_domain/servers/soa_server1/tmp
rm *.lok
Retry command
./startManagedWebLogic.sh soa_server1
On starting weblogic on Solaris 10, I got this error
Could not load the performance pack that can take advantage of /dev/(e)poll device due to:
java.lang.NegativeArraySizeException.
I checked ulimit:
ulimit -n
65536
I reduced ulimit to 65534:
ulimit -n 65534
and weblogic started up fine.
I remember reading somewhere that java has array overflow issues if ulimit is set to maximum.
This morning I got a call from various people complaining about OTM not allowing them to login. Anyone who tried logging in got this error:
A connection to the server could not be established: null (user=any_valid_otm_user)
I checked $GLOG_HOME/logs/weblogic/console.log.0:
INFO | 2011/12/14 09:40:07 | -- OTM Event: serverReady
INFO | 2011/12/14 09:47:01 | javax.management.MBeanException: MBean invoke failed: weblogic.management.mbeanservers.edit.EditTimedOutException:
INFO | 2011/12/14 09:47:01 |
INFO | 2011/12/14 09:47:01 | javax.management.MBeanException: MBean invoke failed: weblogic.management.mbeanservers.edit.EditTimedOutException:
INFO | 2011/12/14 09:47:01 | at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:205)
INFO
(more...)
On both source and target servers ensure these permissions exist:
$ chmod go-w ~/
$ chmod 700 ~/.ssh
$ chmod 600 ~/.ssh/authorized_keys
$ chmod 600 ~/.ssh/id_rsa
$ chmod 644 ~/.ssh/id_rsa.pub
$ chmod 644 ~/.ssh/known_hosts
It didn't work for me in one case where $HOME directory had 777 permission
Looking at /var/log/auth.log on my server revealed the problem: sshd was
refusing to use my public key because my home directory was
group-writable. In order to do pubkey auth, both the home directory
and the .ssh directory must writable only by the owner.
Two parts:
(more...)
OA_HTML is defined in $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/config/oc4j.properties
If you are getting this in 11i then you can apply this patch as per article
Patch 6629280: APPSST11G:11510CU2: IGW: INVALID GROUP BY EXPRESSION IN VIEW DUE TO CBO IFX
Originally we got 70 invalids after applying R12.1.3 patch 9239090. Oracle advised us to run utlirp.sql, followed by utlrp.sql.
We ran utlirp.sql which invalidates all objects
then ran utlrp.sql which reduced the count to 53
then we ran utlrp.sql which reduced the count to 2:
VIEW IGW_BUDGET_CATEGORY_V
PACKAGE BODY IGW_REPORT_PROCESSING
The package was not compiling because of the invalid view. So I extracted
(more...)
After Oracle SSO enabled edelivery.oracle.com, we were unable to access the site through Opera browser. Whenever we clicked on Sign On/Register button a screen with Oracle Access Manager would come up with
Error
System error. Please re-try your action. If you continue to get this error, please contact the Administrator.
A google search revealed the answer from OTN. You have to make Opera identify itself as Internet Explorer. It works fine then. This is from http://www.opera.com/support/kb/view/843/
Go to edelivery.oracle.com. Click on Sign in / Register button. Wait for the error to appear.
Right click
(more...)