Sunday, September 28, 2014

How to change Language To Arabic in Toad Oracle

Step 1: Check what NLS_LANGUAGE is being used in your database.

SELECT    (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_LANGUAGE')
       || '_'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_TERRITORY')
       || '.'
       || (SELECT VALUE
             FROM nls_database_parameters
            WHERE parameter = 'NLS_CHARACTERSET') LANGUAGE
  FROM DUAL




Step 2: Change the NLS _ LANGUAGE in Toad to the same.
Step 3: Open Toad
Step 4: Click on the button as shown below




Step 5 : Click on the current  NLS_LANGUAGE
Sept 6 : Change it according to the database.
Sept 7 : Save the changes and close toad application then start again.

 Now Connect to the database...


Starting concurrent managers in Apps


In a previous article I had discussed how to bounce Apache/Web server on Oracle. In this article I have discussed how concurrent managers are bounced.
Check the running concurrent managers from the front end
Responsibility: System Administrator
Navigation: Concurrent > Manager > Administrator
You can see that the concurrent managers are running. You can individually stop the managers from this form by selecting the concurrent manager and clicking on Deactivate. If you do so, Oracle will spawn the concurrent program, Deactivate All Managers (Deactivate), to stop the individual manager.
To activate an individual manager you need to select the manager and click on Activate (the deactivate button changes to Activate when the manager is deactivated). Once the Activate button is clicked it spawns the concurrent program, Activate Cost Worker Manager (Activate).
To bounce all the running concurrent managers together we need to run an admin script from Unix.
Log into Unix.
Go to the admin scripts directory
cd $INST_TOP/admin/scripts
Execute the script adcmctl.sh in stop mode to stop all the running concurrent managers.
Enter adcmctl.sh stop

Enter the apps user name and password

The script output shows that all running concurrent managers are being shut down.
Now check the concurrent managers in Apps
You will notice that the managers are deactivated.
We shall now start the managers. Execute the script adcmctl.sh in start mode
$adcmctl.sh start
Enter apps database user name and password
The script gives the output that the managers have been started.
Now let’s check the managers from the front end.
We see that the managers have been activated.