What's my Oracle DB service name?
Determine the services used against your deployed databaseHOW TO: Delete existing schemas from Oracle DB using RCU
The most efficient way on removing the DDL's from your Oracle DatabaseHOW TO: Startup Oracle database Instances
A .sh script to startup an Oracle DB instance, listeners and emctrlsERROR: NMO not setuid-root (Unix-only)
When trying to log into Enterprise Manager (EM) with the correct credentials, I was the error, RemoteOperationException: ERROR: NMO not setuid-root (Unix-only).ORA-28001 the password has expired (DBD Error:OCISessionBegin)
It seems that when you're experiencing a ORA-28001, or if the enterprise manager is unable to connect to the database instance, the probable cause to the issue is that the SYSMAN user password has expired. Not a problem, you an can unlock this user with the example below (in this case, the password for the SYSMAN is 'password')HOW TO: Install SQL Developer 3.2 on RHEL 5.x
A very simple installation on the product though here's a quick step-by-step instructions on how to install SQL developer 3.2 on Redhat linux 5.x'item_risk' defined in the schema file is not valid error
When importing the glossaries, I noticed that the glossary description within the OIA Oracle Documentation was incorrect, specifically with the 'item risk' attribute. You will however get a 'do not match schema' or that the field 'item_risk' defined in the schema file is not valid errorHOW TO: Install Oracle Linux 6.3
The steps required to install Oracle Linux 6.3 as a VM.HOW TO: Update Oracle Unix software packages
The steps required to initiate the software update on Oracle Linux 6.3HOW TO: Install Oracle Database 11.2.0.x on Linux 64bit
Oracle database 11.2.0.x on Linux 64bit including the prerequisites in preparation for OIM (OFM) 11gR2 11.2.0.xTwo SQL triggers on one table
It's not possible (to my knowledge) to have two triggers on one table that purposely has the same operation. I was trying to incorporate additional inserts into the table after the data has been imported in another table.ORA-28002 the password will expire within 7 days
A database warning was encountered performing the requested operation ORA-28002 the password will expire within 7 days Cause: The user's account is about to expire and the password needs to be changed Action Change the password or contact the DBAInstalling Oracle Database 11gR2
Whilst I was installing a new Oracle Database when running the runInstaller shell within terminal for OIM 11gR2 on Linux OEL 6.0 for a VMware instance, I would receive the following errorInstall oracle-rdbms-server-11gR2-preinstall without Oracle support
Within the installation of Oracle Database 11g Release 2, I noticed that the OS did not have the minimum requirements for installation in order to complete the installationSOLUTION: sqlplus: command not found
Once you have installed Oracle database and restarted the OS, you may experience 'sqlplus: command not found' erroremctl start dbconsole
emctl start dbconsoleLRM-00109: could not open parameter file '/home/oracle/app/oracle/product /11.2.0/dbhome_1/dbs/inito
The solution when the parameter file LRM-00109 occurs for Oracle Fusion MiddlewareTNS:net service name is incorrectly specified
Starting up database in preparation for the Oracle Identity Manager 11gR2 PS2 schema installationUnable to log in using sys password against ORCL service
You can test the sys connection by executing the following sqlplus command (by using the service name above:ORA-02095: specified initialization parameter cannot be modified
When trying to initiate the DB instance, I would receive the following error:ERROR at line 1: ORA-32001: write to SPFILE requested but no SPFILE is in use
When toggling around with the database startup, I was receiving the following errorERROR: LRM-00109: could not open parameter file '/opt/oracle/112/dbs/initorcl.ora'
Error when starting up the Oracle SQL instanceERROR: LRM-00109: could not open parameter file '/opt/oracle/112/dbs/initorcl.ora'
When trying to initiate the oracle database for the purpose on installing OIM 11gR2PS2, I would receive the following error:ERROR: LRM-00109: could not open parameter file opt oracle 112 dbs initorcl.ora
ERROR: LRM-00109: could not open parameter file /opt/oracle/112/dbs/initorcl.oraIssues when initiating Oracle Database whilst installing OIM11gR2PS2
I came across so many issues when trying to pack OIM 11gR2PS2 on my 7.5GB VM image. One alteration I had constantly manipulate was the control file.ORA-12516, TNS:listener could not find available handler with matching protocol stack
When starting up the OIM weblogic instance, I would receive the following error:Oracle Identity Manager (OIM) Terminologies
A couple of years ago I submitted a blog on the OIM 10g Terminology. It was a little lightweight though now I've pulled together the OIM technologies. Hope this helpsORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 180 M
I ended up noticing this issue when there's not enough memory assigned than the minimum requirement.HOW TO: Create a Oracle AQ Topic JMS message for java delivery
The steps to create a AQ Topic for a JMS text message. These are the pre-requisites in preparation to the following blog, HOW TO: Enqueue a JMS_TEXT_MESSAGE from java to Oracle database QueueMissing SID_LIST_ value left of equation for SID description in LISTENER.ORA
Access the listener.ora file (example vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora) and make sure that the lines of code in LISTENER.ORA containing SID_DESC or SID begin with SID_LIST_Comments
Tags
Recent Posts
Monthly Activity
Group by date