In Oracle 11g, the one who is calling a remote site needs to get access to that site. This is done via the Access Control List.
I have written a blog about this error at my Whitehorses Blog: Oracle 11g: Access Control List and ORA-24247.
Today I had to babysit a demo machine I set-up for a proof of concept. All went well, as I expected.
A two gigabyte RAM Linux machine with SOA/BPEL 11g, two WebLogic 10.3 domains extended with ADF and Apex XE running on it. It kept running, but at one point is had only 30 megs of memory left!
Check out ‘Extending your WebLogic standalone environment with ADF runtime libraries‘ for more information about setting up the WebLogic environment with ADF.
When moving/deleting the listener.log, I used to stop and start the listener and move/delete the listener in between the actions.
This method has a big inconvenience: users can not connect to the database for a few seconds…
What I never knew was that the listener could be told to stop and start logging and take the appropriate action in between. Continue reading
When having multiple Oracle homes on Windows, how is decided which Oracle home (in the registry) is used by an Oracle binary? Which NLS_LANG or TNS_ADMIN setting from the registry is used?
The answer is binary, path, oracle.key, registry… and which for Windows. Continue reading
select from table
ORACLE block corrupted
RMAN is my friend
I have just explained a few test scenarios when trying to recover through RESETLOGS. You need to make sure you know your incarnations!
My Whitehorses colleague Edwin Biemond is now titled Java Developer of the Year 2009. After getting is ACE status earlier this year, his name is now also added to Oracles ‘Portraits of Excellence’ list. Continue reading
After a nice Lower Cost talk by Mark Townsend and the new Sun Oracle Exadata and Database Machine by Chris Baker, I attended ‘Upgrade to 11g – Best Practices’ by Mike Dietrich, ‘Consolidate on Low-Cost Server and Storage Grids’ by John Abrahams, ‘Oracle’s Maximum Availability Architecture’ also by John Abrahams & Lucas Jellema, CTO AMIS and ‘DBA 2.0’ by Ed Bangma.
It was nice to see our Whitehorses logo in the main presentation at the Oracle Netherlands 25 years sheet!
More on Oracle ASM Cluster File Management, Dynamic Volume Manager, RAC One Node, Grid Plug ‘n Play, Server Pools, Cluster Health Monitor and Electronic Sudoku Devices… Continue reading
Last week I created a new database (Oracle 9.2) and got the following message when the ‘create database’ script was almost finished: ORA-01991: invalid password file.
OK, the database instance existed before, so I created a new password file with orapwd. Trying to open the database after this gave me the following message: ORA-01403: no data found. Continue reading
When getting the following message using JInitiator: “Unable to verify the certificate – code will be treated as unsigned.”, please check “Control Panel > JInitiator > Cache”, to which location Java will store the ‘Oracle Jar Cache’ and JInitiator settings (like the ‘Grant Always’ setting and ‘Oracle Jar Cache’ directory) in <USERHOME>\.jinit\properties<jinit version> and jpicerts<jinit version>.
Java will get the USERHOME path from the Windows registry [HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders\Desktop] when looking for the Desktop path setting and truncates the ‘Desktop’ part. Most of the time this will result in the correct USERHOME directory, but when this setting is changed to a network path where users are not granted write access, Java is not able to store the Cache and JInitiator settings.
Ofcourse, this can be one of a few problems, but if you suspect a case like this, there might be a solution… Continue reading