The Art of Changing | Confessions of a Pragmatic Intellectual's Mind on The Constant in Life, Change!
I attended and successfully completed “Oracle Coherence 3.6: Share and Manage Data In Clusters” course offered by Red Hat in December 2013. Oracle Coherence 3.6: Share and Manage Data In Clusters – Certificate Oracle Coherence 3.6: Share and Manage Data In Clusters – Course The topics covered in this course were as follow: What is…
Just find the oc4j.cmd in the bin directory and use the following command to set your ORACLE_HOME set ORACLE_HOME=C:FilesDevelopExternaloc4j_extended_101340 add this line the to the first line of oc4j.cmd. Using this option, you don’t need to set ORACLE_HOME in your environment variables any more.
There are two ways to define Oracle home for the PL/SQL developer.One way is to have it in the environment variables, and point it to the installed directory. This works globally, so any other program/software is going to look for ORACLE_HOME will use this one.Another way is to use the ORACLE_HOME registry value. You would…
You can use any of these commands: SQL> Select name from v$database; SQL> select instance_name from v$instance; SQL> select * from global_name; SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME=’db_name’; SQL> select to_number(translate(substr(version,1,9),’1.$’,’1′)) from v$instance; SQL> select s.machine from v$session s where s.audsid userenv(‘sessionid’); SQL> select global_name from global_name;
Using oracle form builder, I get this error from time to time when compiling a form. It is said to be because of several forms being open at the same time. So if you get this error, better to close some forms and they try again. However, I have solved the problem another way. I…
If you get this error using Oracle Form Builder, you might want to try these ones (one of them, not both necessarily) Set the forms_class_path in the registry and in the environment file and put the files in the right places. If you get that error when invoking the Oracle-Forms Layout-Editor and you are sure…
These are mostly oracle application server commands:EMCTLTo start and stop the Management Service, the Management Agent, the Grid Control Console, the Application Server Control Console, and the Database Control, you use the Enterprise Manager command-line utility (emctl)OPMNCTLopmnctl is the supported tool for starting and stopping all components in an Oracle Application Server instance, with the…
Using Oracle Internet Directory you will find some profiles that you either need to change or use in order to synchronize from AD (Active Directory). Some of the default profiles are as follow: ActiveImport—The profile for importing changes from Microsoft Active Directory to Oracle Internet Directory by using the DirSync approach ActiveChgImp—The profile for importing…
There can be more than one Oracle instance on a single machine. In order to be able to distinguish these instances, Oracle uses a SID (System Identifier) which is a string. The SID can be set through the ORACLE_SID environment variable.D:oracleproduct10.1.0>set ORACLE_SID=ORA10 On Windows, each instance requires a Windows service. This service must first be…
I was trying to connect to database using the following URL : jdbc:oracle:thin:@//dbs03.~~~~.ca:1521/database_name_dev while JDBC needs an SID to connect to and not a database name or TSN name. Not sure how should you find it out what an SID is for a given database for now, but after changing it to jdbc:oracle:thin:@//dbs03.~~~~.ca:1521/db03, I could…