Want GUI in putty

Many times there will be a requirement of using GUI in putty. It might not be possible to install a vnc in some production environments, so it becomes necessary to have a way in which one can get GUI in putty.

For this one has to ENABLE X11 FORWARDING in putty.

To do this the steps are as follows.

1. Install Xming-6-9-0-31-setup.exe

2. Then enable x11 forwarding in putty as shown in the screenshot.

3. From the command prompt make a 'xhost+'

4. Make a xclock and there you are - you can see the display.

5. Please keep in mind that there may be a couple of things that may be missing if you fail to have gui. Check that xauth is installed in linux. In the eventlog of the putty session a message will come saying that x11 forwarding failed because xauth not available. Search rpm with name *xauth* and then install that rpm. Also if xclock is not coming up, one needs to install rpm corresponding to xclock.

Enable Database Vault in a single instance 11gR2 database

In 11.2, Database Vault binaries are installed by default.

So, there is no need to run the installer anymore. To complete the Database Vault install, you need to do the following:

1. Shutdown the database and link Database Vault on :

$ORACLE_HOME/rdbms/lib/make -f ins_rdbms.mk dv_on ioracle

(notice this changed from previous versions and it is only one step)

2. run dbca and choose configure options. Then check OLS and Database Vault.

Pre-requisites of installing 10.2.3.2 av agent on database

While installing av agent 10.2.3, make sure oracle home is selected as a path different from database home. Also there is no need to stop database or listener or any other service. Database can keep running and people can access it without their knowledge that something is getting installed.
While installing patch 10.2.3.2 on top of 10.2.3.0 or 10.2.3.1, make sure that oc4j is stopped at source database.
export ORACLE_HOME= agent_home
cd ORACLE_HOME/bin
./avctl stop_oc4j
Then go ahead with the installation of av agent 10.2.3.2.
Things should be fine.

dbconsole not starting

There can be many reasons why dbconsole might not start.
I am quoting one reason below.
Checke the logfiles at $ORACLE_HOME/hostname_sid/sysman/log
check the latest logs by doing a ls -ltr
In the file emagent.nohup
if you see something like this -
----- Thu Feb 11 14:05:44 2010::The agentTZRegion value in /home/oracle/oracle/product/10.2.3/av_1/sec_serverav/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script 'mgmt_target.set_agent_tzrgn' to get the value propagated to repository -----
....then give the follwoing command
emctl resetTZ agent
then login as sysman/password and run the following command-
SQL> exec mgmt_target.set_agent_tzrgn('sec:3938','Asia/Calcutta')
PL/SQL procedure successfully completed.

Stop database and listener before installing db vault

Other wise the following error may pop-up :-
Oracle Universal Installer has detected that there are processes running in the currently selected Oracle Home.The following processes need to be shutdown before continuing: oracle

Configure Database Vault in 11gR2 RAC setup

Assumption :-
SID is VIS12
SID for Node1 is VIS121
SID for Node2 is VIS122
The binaries of DV come automatically in 11gR2 home. So we see that option of enabling and disabling. Butthis doesn't mean the database has database vault installed because all dv related objects are missing in the datadictionary.So now we have to go to node1.set oracle home as VIS12stop db using the srvctl command.now enable DV at both nodes using the command with ORACLE_HOME set as VIS121 for node1 and VIS122 for node2-make -f ins_rdbms.mk dv_on ioracle {remember no relink oracle needed for 11gR2}Then start db using srvctl command.(ORACLE_HOME should be set to VIS12)Then come to node1.Let ORACLE_HOME be set as VIS121Run dbca.Select configure database.Select the database vault option.Now you are asked to give database vault owner and account manager user id and passwords.Give the userid and password and go ahead with the installation.

oc4j not starting at source database in audit vault setup

[oracle@primarydb bin]$ ./avctl show_oc4j_status

Exception in thread "main" java.lang.NoClassDefFoundError: oracle/av/avca/Avctl

Solution :

Set ORACLE_HOME to AGENT_HOME

then start oc4j at source database.