Sujeet APPS DBA

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