How to fix security digital signature hang problem in Oracle Forms

In the name of Allah, the most Beneficial, the most Merciful

In this article i will be describing "How to fix security digital signature hang problem in Oracle Forms". When you try to launch Forms application the following signature verification window open to trust it or not.

Figure - 1

You will be unable to click the Run or Cancel buttons. Only thing you can do is to open the task manager and kill the forms application. It is due to the sequence in which browser load the jar files in "archive" or "WebutilArchive" parameters in formsweb.cfg file. This problem has following workarounds.

1. Change the sequence of jar files in "archive" and "WebutilArchive" parameters in formsweb.cfg file.

2. set the parameter separateFrame = false and launch the application, Trust the digital signature and then return back to separateFrame = true.

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

How to connect Oracle Database to Microsoft SQL Server by using Heterogeneous Services

In the name of Allah, the most Beneficial, the most Merciful

In this article i will be describing "How to connect Oracle Database to Microsoft SQL Server by using Heterogeneous Services". Access and other databases can also be connected by this method. First of all we need to create ODBC connection on oracle host machine. Go to "Control Panel" -> "Administrative Tools" -> "Data Sources (ODBC)" following screen will appear.

Figure - 1

Click on Add button.

 

Figure - 2

Select "SQL Server" and click Finish button.

 

Figure - 3

Name the Data Source and provide the Server information as shown above and click Next button.

Figure - 4

Provide login information and click Next button.

 

Figure - 5

Select the default database from list and click Next button.

 

Figure - 6

Optionally check the logging for query and statistics and click Finish button.

Figure - 7

Click the "Test Data Source" button.

 

Figure - 8

Click Ok button. Now create a init<ODBC>.ora file in ORACLE_HOME\hs\admin as follows.

Figure - 9

Add the SID_DESC in SID_LIST_LISTENER parameter in listener.ora file as shown in screen below.

Figure - 10

Now restart listener by "lsnrctl reload" command.

lsnrctl reload

Create a connection sting in tnsnames.ora file as shown in figure below.

Figure - 11

check the string by tnsping command

tnsping attendence

 Now create a database link for the Sql Server database as follows.

CREATE PUBLIC DATABASE LINK sqlsrv CONNECT TO "sa" IDENTIFIED BY "MyPassword" USING 'attendence';

Now query the table in SQL Server from oracle by following query.

SELECT "acol", "bcol"

FROM     atab@SQLSRV;

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

How to Upgrade Oracle Enterprise Manager Grid Control Release 10.2.0.4 to 11.1.0.1

In the name of Allah, Most Gracious, Most Merciful.

In this article i will describe "How to upgrade Oracle Enterprise Manager Grid Control Release 10.2.0.4 to 11.1.0.1" on Red Hat Linux 5.3 OS. For this you have to download Oracle Enterprise Manager Grid Control 11gR1 from oracle website http://www.oracle.com/technetwork/oem/grid-control/downloads/index.htm 

Pre-Upgrade Tasks

1. Oracle WebLogic Server 10.3.2 should be installed. Guide available here

2. Upgrade the repository database to Oracle 11gR2. Guide available here

3. Take Cold backup of repository database.

4. Switch the repository database to archive log mode. (not mandatory)

5. Stop the OMS and agent connected to the repository database.

6. set parameter job_queue_processes to 0 for the duration of upgrade.

7. set parameter log_buffer parameter to 10485760 or higher.

8. set parameter processes to 500 or higher.

9. Grant execute on DBMS_RANDOM to SYSMAN and DBSNMP users.

Execute following query to see the log mode of the database.

$ sqlplus / as sysdba

SQL> select log_mode from v$database;

LOG_MODE

-----------

ARCHIVELOG

if it is in NOARCHIVELOG then execute following script to switch it to archivelog mode.

$ sqlplus / as sysdba

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> alter database open;

Stop OMS and agents connected to the repository database by following commands

$ $<OMS_HOME>/opmn/bin/opmnctl stopall

$ $<AGENT_HOME>/bin/emctl stop agent

Set database parameters and grants by following script

$ sqlplus / as sysdba

SQL> alter system set job_queue_processes=0;

SQL> alter system set log_buffer=10485760 scope=spfile;

SQL> alter system set processes=500 scope=spfile;

SQL> grant execute on DBMS_RANDOM to SYSMAN, DBSNMP;

SQL> shutdown immediate;

SQL> startup;

Upgrade Tasks

Unzip the installation source and start the installer by running following command

$ cd /tmp/GridControl

$ unzip GridControl_11.1.0.1.0_Linux_1of3.zip

$ unzip GridControl_11.1.0.1.0_Linux_2of3.zip

$ unzip GridControl_11.1.0.1.0_Linux_3of3.zip 

$ ./runInstaller

Figure - 1

Leave the email and support password blank and click Next.

Figure - 2

Click Yes.

Figure - 3

Click the "Skip Software Updates" and then click Next.

Figure - 4

Click "Upgrade to Enterprise Manager 11g" and then click Next.

Figure - 5

Select the Enterprise Manager 10g you want to upgrade and click Next.

Figure - 6

If all the tests are succeeded then click Next otherwise check and fix the problem.

Figure - 7

Enter the SYS users password for the repository database and click Next.

Figure - 8

Click Next.

Figure - 9

Enter WebLogic username and passwords and click Next.

Figure - 10

Click Next.

Figure - 11

Review information and click Install.

Figure - 12

View Progress.

Figure - 13

View Progress.

Figure - 14

View Progress.

Figure - 15

Open a new terminal, login with root, make a directory for oracle files and run the script in the above figure.

$ mkdir /usr/local/bin/gc11g

$ /u01/oracle/Middleware/oms11g/allroot.sh

Figure - 16

Provide the directory path created above when prompted then click OK on figure 15.

Figure - 17

View Progress.

Figure - 18

View Progress.

Figure - 19

Note the Enterprise Manager URL and then click Close. Open the URL in brower.

Figure - 20

Enter username and password for repository database and click Login.

Figure - 21

Oracle Enterprise Manager Grid Control Release 10.2.0.4 is upgraded to 11.1.0.1.

Post-Upgrade Tasks


Reset the job_queue_processes parameter.

$ sqlplus / as sysdba

SQL> alter system set job_queue_processes=10;

SQL> exit;

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

How to Upgrade Oracle Management Agent Release 10.2.0.1 to 10.2.0.4

In the name of Allah, Most Gracious, Most Merciful.

In this article i will describe "How to upgrade Oracle Management Agent Release 10.2.0.1 to 10.2.0.4" on Red Hat Linux 5.3 OS. For this you have to download patch number 3731593 from Oracle Metalink site.

Before upgrading Oracle Management Agent to Release 10.2.0.4 you should upgrade Oracle Grid Control to 10.2.0.4. You can find this guide here.

1. Stop Management Agent bu using following command

$ <AGENT_HOME>/bin/emctl stop agent

2. Take backup of Agent home directory

3. set ORACLE_HOME to Agent home directory

$ export ORACLE_HOME=/u01/oracle/product/10.2.0/grid/agent10g

4. unzip the patch zip file to /tmp directory

$ unzip p3731593_10204_LINUX.zip

5. Run Installer from patch

$ /tmp/3731593/Disk1/runInstaller

Figure - 1

Select agent Home name and path and click Next.

Figure - 2

Click Next.

Figure - 3

Click Next.

Figure - 4

Review Summary information and click Install.

Figure - 5

View progress.

Figure - 6

View configuration progress.

Figure - 7

Oracle Management Agent Release 10.2.0.1 is upgraded to 10.2.0.4.

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.