How to check if the User is connected to the Databaes from SQLPLUS or TOAD


SQL> desc v$session;

sql> select program, machine, CLIENT_IDENTIFIER   from V$session;


SQL> SELECT USERNAME, SCHEMANAME,PROGRAM FROM V$SESSION;

sql> select osuser, machine, terminal from v$session;

sql> select client_info, machine columns from V$session;

sql> select program from v$session;

sql> select distinct machine from v$session;

sql> select program, osuser, machine, client_info from V$session;



SQL> set line 50000

SQL> SELECT USERNAME, SCHEMANAME, OWNERID,  LOGON_TIME, CLIENT_INFO, SERVER, CLIENT_IDENTIFIER,RESOURCE_CONSUMER_GROUP,PROGRAM FROM V$SESSION;

USERNAME                       SCHEMANAME                     PROGRAM
------------------------------ ------------------------------ ------------------------------------------------
APPS                           APPS                           frmcmp_batch@sujeet.com (TNS V1-V3)
APPS                           APPS                           frmcmp_batch@sujeet.com (TNS V1-V3)


How to configure VNCSERVER on RHEL5.8

Introduction
Most of the time as a system administrator you are managing your servers over the network.
 It is very rare that you will need to have a physical access to any of your managed servers.
 In most cases all you need is to SSH remotely to do your administration tasks.
In this article we will configure a GUI alternative to a remote access to your RHEL server,
which is VNC. VNC allows you to open a remote GUI session to your server and thus providing you with a full graphical interface accessible from any remote location.

 Installation of VNC server
In order to enable an access to our Redhat Linux system using VNC we first need to install it. Make sure that you have your repository enabled and execute the command:

# yum install tigervnc-server

The above command will install the VNC server on your system.

Configuring VNC Server Access on a Redhat Linux5.8

I will show how to configure VNC server on Red Hat server and using VNC Viewer connect the server remotely from Windows XP.

Prerequisite:-

Disable Selinux.  
[root@sujeet ~]# cat /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted


How to Disable the Firewall for Oracle Linux or Red Hat Enterprise Linux

To disable the firewall, run the following commands.

# service iptables stop

# chkconfig iptables off

1. Introduction

VNC allows you to open a remote GUI session to your
server and thus providing you with a full graphical
interface accessible from any remote location.

VNC allows you to open a remote GUI session to your
server and thus providing you with a full graphical interface accessible from any remote location.


2. Configure steps:-

Edit /etc/sysconfig/vncservers, and add the following to the end of the file.Hear my port=4
VNC User=root
save it.


[root@sujeet]# vi /etc/sysconfig/vncservers


# VNCSERVERS="2:myusername"
# VNCSERVERARGS[2]="-geometry 800x600 -nolisten tcp -nohttpd -localhost"


VNCSERVERS="4:root"
VNCSERVERARGS[4]="-geometry 1600x1200"



or

If you want multiple VNC session than you can use below lines add /etc/sysconfig/vncservers file.

VNCSERVERARGS[1]="-geometry 640x480"
VNCSERVERARGS[2]="-geometry 640x480"
VNCSERVERARGS[3]="-geometry 800x600"

3. Reset VNC User password.

Use below command-

[root@sujeet]# vncpasswd
Password: XXXXX
Verify: XXXXX

This password you can use connection time.


4. firewall setting

If you have firewall enable on Red Hat, be sure that your firewall configuration won’t block connection from remote computer by open port TCP 5901 for remote access. Open Applications -> System Settings -> Security Level. Add ’5901:tcp’ on Other ports.
Note: VNC uses TCP protocol on port 5901.

Open TCP port 5901 for remote access


5.  start the vncserver.

 [root@sujeet]#
service vncserver start
[root@sujeet]#
service vncserver stop

[root@sujeet]#

service vncserver status


service vncserver restart

Now you can connect Red Hat server from remote computer. On my Windows XP computer, open VNC Viewer on Windows XP, type IP Address of Red Hat server with number as a username specify. In this example, I want to remote to Red Hat server as ‘root’ user which I assign as number 2 in step 2 and my Red Hat server is 10.110.141.220. So I type ’10.110.141.220:1′.
  1. Note: You can download VNC Viewer for free at Download VNC® Viewer
    Test connect to Red Hat server from remote computer
  2. Type your password for ‘root’ user which has been assign in step 3.
    Specify password



Now you have connect to Red Hat server remotely. But you’ll see that the interface looks different. You have to do a little thing more.



6.  If You want to execs Server Desktop Than do next steps.

 On Red Hat server, open terminal and type ‘vi /home/username/.vnc/xstartup’.

In this example,
I type ‘vi /home/admin/.vnc/xstartup’.


Note: If you going to enable remote access for user ‘root’,  the file would be at ‘/root/.vnc/xstartup’.

[root@sujeet ~]# vi /root/.vnc/xstartup

UN-commit below 2 lines after that save it.
 
unset SESSION_MANAGER
exec /etc/X11/xinit/xinitrc


7. Restart VNCSERVER

[root@sujeet ~]# service vncserver restart

Shutting down VNC server: 4:root                           [  OK  ]
Starting VNC server: 4:root
New 'sonu.oracle.com:4 (root)' desktop is sujeet.oracle.com:4

Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/chintels.chintels.com:4.log                [  OK  ]

8. Now you can connect Red Hat server from remote computer. On my Windows XP computer, open VNC Viewer on Windows XP, type IP Address of Red Hat server with number as a username specify. In this example, I want to remote to Red Hat server as ‘root’ user which I assign as number 2 in step 2 and my Red Hat server is 10.110.141.220. So I type ’10.110.141.220:1′.
  1. Note: You can download VNC Viewer for free at Download VNC® Viewer
    Test connect to Red Hat server from remote computer
  2. Type your password for ‘root’ user which has been assign in step 3.
    Specify password
 





 Find vnc processes id.

 [root@sujeet]# ps -ef | grep vnc | grep root



X Servers

How to check X Server status???

 Testing your X Server configuration:-

The easiest way to test your X Server is to use an X11 based program that comes with the native operating system such as "xclock". In the session where you are trying to start the Oracle java product such as "runInstaller", "dbassist" or "netasst" do the following:

Sun Solaris:
      % /usr/openwin/bin/xclock
 
HP/UX, Compaq Tru64 and IBM RS6000:
      % /usr/bin/X11/xclock
 
Linux:
      % /usr/X11R6/bin/xclock 

After executing the "xclock" command a clock should be displayed on your X Server display. If a clock is not displayed
 
% setenv DISPLAY :0.0
example: setenv DISPLAY 192.168.1.128:0.0

For sh, ksh and bash:
    $ DISPLAY=:0.0; export DISPLAY
example: DISPLAY=192.168.1.128:0.0; export DISPLAY

How to change form colour in R12

Post Clone Steps.

Changing Color Scheme and look and feel of Application R12 ???


Means How to differentiate the PROD or TEST instance???

1. Login with Sysadmin or other user which user have System Administrator Responsibility.

Click on System Administrator>>>
Click on Profile>>>>
click on SYSTEM>>>





Open Profile window.
Find
'Java Color Scheme' or


Java Look and Feel Profile option. Like below screen.




 Change below both profile option as per your choice.Save it.

1. Java Look and Feel.
 
Java Look and Feel can have two values: GENERIC or ORACLE.
 
If set to GENERIC, then set Java Color Scheme to blank. Which will leave look 
and feel to generic. The Generic look and feel adheres to the native interface 
and color scheme of the current operating system. 
 
If set to ORACLE (or if the value is left blank), then the profile option 'Java 
Color Scheme' can be used to personalize the colors of your screen.
 
2. Java Color Scheme.
 
If 'Java Look and Feel' is set to ORACLE (or if the value is left blank), then 
'Java Color Scheme' can be set to the following values:  
 
 Blaf
 Blue
 Khaki
 Olive
 Purple
 Red
 Teal
 Titanium

the 'Java Color Scheme' profile has no effect if 'Java Look and 
Feel' is set to GENERIC.


Logout or again login open any form its display what you made changes Java colour scheme or Java Look and Feel. 


 

How to change SITE NAME in R12

Post Clone activity.

1. How to change SITE NAME.
2. How to change form Colour.

Means How to differentiate the PROD or TEST instance???

1. Login with Sysadmin or other user which user have System Administrator Responsibility.

Click on System Administrator>>>
Click on Profile>>>>
click on SYSTEM>>>





Open Profile window.
Find "SITE NAME" Profile option. Like below screen.



  Change SITE NAME what you want. Save it.
Logout or again login open any form its display what you changes below SITE NAME.

Here I am editing R12.1.3 PROD to R12.1.3 New TEST. Save it.

Next time its display for every one.






  

RC-00215: Warning: File /u01/db/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv not found


**RC-00215: Warning: File /u01/db/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv not found

Please find below ENV & Error Detailed---

Data Base=11.1.0

 platform OS =oracle linux 5.8

Apps= 12.1.3

when running adcfglone.pl on Target database tier getting this error cant move forward from this step kindly update

{sujeet-bin ]$  perl adcfgclone.pl dbTier

 Target system RDBMS ORACLE_HOME directory [/u01/db/db/tech_st/11.1.0]:

**RC-00215: Warning: File /u01/db/db/tech_st/11.1.0/appsutil/template/addbtmpl.drv not found


Solution :-


Check your file location & give right ORACLE_HOME Path.

Or File location.

My ORACLE_HOME path= /u01/db/tech_st/11.1.0

its will take wrong path than error will come.

 



No devices found to install Red Hat Enterprise Linux5.5

No devices found to install Red Hat Enterprise Linux5.5






Solution:-

Check your CD/DVD drives,

Its HARDWARE Issue,

You need to use other external CD/DVD driver.


Your boot partition is on a disk using the GPT partitioning scheme but this machine cannot boot using GPT



After partitioning the disks when I installed OEL5.8, it gave me the following error message: “Your boot partition is on a disk using the GPT partitioning scheme but this machine cannot boot using GPT”.





This issue comes if your
Environment:-
Red Hat Enterprise Linux 5.2 or higher,
Large storage device (2TB or more)   
 
BUT
 
If your environment is RHEL 5.5 or Higher.
Hard disk  is 1TB after that facing same issue..


Solution:-


FORMAT Your Hard disk after that try to install.


 
                            

500 Internal Server Error

Last day i was open my Oracle Apps Front hand login page Got below Error.

ERROR:-
500 Internal Server Error OracleJSP: An error occurred. Consult your application/system administrator for support. Programmers should consider setting the init-param debug_mode to "true" to see the complete exception message.

Solution:-

Please go to $ORACLE_HOME/oc4j/j2ee/OC4J_SEARCH/config/global-web-application.xml

Extend the servlet node this way:

<servlet>
<servlet-name>jsp</servlet-name>
<servlet-class>oracle.jsp.runtimev2.JspServlet</servlet-class>
<init-param>
<param-name>debug_mode</param-name>
<param-value>true</param-value>
</init-param>
 
 
Restart OC4J and thats should be it.
Also have a look at $ORACLE_HOME/oc4j/j2ee/OC4J_SEARCH/application-deployments/ses_query/application.log

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...