One excellent tool for Systems Management on Windows is the Windows Management Instrumentation (WMI), which allows you to remotely execute commands and query parameters on a Windows Host. Of course, all modern Windows systems have the WMI Client installed, but what about the Linux clients?
To get the same functionality on a Linux system (I am using Debian in this example), we need to get the following two packages from this website:
Read the rest of this entry
I just noticed that every time I need to create a password file, I have to look up the Oracle documentation for the correct syntax of the ORAPWD arguments. So this post is mainly for my own reference and contains the proper syntax for UNIX and Windows systems as well as an example for each system.
UNIX syntax:
Read the rest of this entry
Last week I had to perform an installation of Oracle 11g on a Windows Server 2008 R2 machine. When I tried to install a 11g database with the -silent
and -responsefile
options, I received the following error:
[SEVERE] - Email Address Not Specified
Obviously, I needed to specify an e-mail address for My Oracle Support. Lets have a look in the responsefile:
Read the rest of this entry
After a database update from 10.2.0.1.0 to 10.2.0.5 on Windows Server 2003, we encountered the ORA-12571 error when starting the Application Server. In the log files, the error showed up as an SQLException:
java.sql.SQLException: Io exception: Connection reset by peer: socket write error
I then used TNSPing to validate the connection to the database and I basically received this result:
OK
OK
OK
ORA-12571: TNS:PACKET WRITER FAILURE
This means that there is a problem with the TNS Listener. I checked the listener log ($ORACLE_HOME\network\log\listener_name.log
) for errors and saw this:
Read the rest of this entry