NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Useful Command for VNC

No comments
Below are some useful command for VNC server
 
1. Start a vncserver
     Command : vncserver
      You will prompted to provided the password.
 
2. Changing the password for VNC
     Command: vncpasswd : n (e.g. vncpasswd : 1)
      n- The port on which the vnc is running.
 
3. Killing a VNC server
     Command: vncserver -kill :n (e.g. vncserver -kill :n)
      n- The port on which the vnc is running.
      As a good practice we should use above command to clear vnc server. Killing a OS    level process will not release the lock on the vnc port which was used previously for running vnc . So next time we will not be able to start on that locked vnc port.

No comments :

Post a Comment

Scipt to Find the Concurrent Manager for a Concurrent Program

No comments
We can use the below query to find the Manager name for a Concurrent Program


Script

SELECT fcqc.INCLUDE_FLAG,
       fcqc.QUEUE_APPLICATION_ID,
       fcq.USER_CONCURRENT_QUEUE_NAME,
       fcp.CONCURRENT_PROGRAM_NAME
  FROM APPLSYS.FND_CONCURRENT_QUEUE_CONTENT fcqc,
       APPLSYS.FND_CONCURRENT_PROGRAMS fcp,
       APPS.FND_CONCURRENT_QUEUES_VL fcq
 WHERE     type_id = fcp.concurrent_program_id
       AND fcp.concurrent_program_name = '&PROGRAM_SHORT_NAME'
       AND fcq.concurrent_queue_id = fcqc.concurrent_queue_id;

 

No comments :

Post a Comment

Moving Oracle Home/ Making a Duplicate Oracle Home

6 comments
If we want to create/clone/move oracle home or move the oracle home then we can use the clone.pl utility provided by oracle. With the use of this utility we can create a Oracle Home with all the required patches already applied.

Utility Details

Perl Script: $ORACLE_HOME/clone/bin/clone.pl.
It accepts ORACLE HOME and ORACLE HOME NAME as parameters.

Steps

Current Oracle Home: /u01/app/oracle/db
New Oracle Home: /u02/app/oracle/db
1) Tar the current ORACLE_HOME as ‘oracle’ user or the dbuser(what ever defined)
$> cd /u01/app/oracle/db
$> tar -cvf orahome.tar *
2) Copy the tar to new ORACLE_HOME location/ new server Oracle Home location
$> cd /u02/app/oracle/db
$> tar -xvf orahome.tar
3) Execute perl clone.pl script to clone a new ORACLE HOME

Setting up the environment
export ORACLE_BASE=/u02/app/oracle  
export ORACLE_HOME=/u02/app/oracle/db  
export PATH=${ORACLE_HOME}/bin:$PATH 

Executing the clone.pl
perl ${ORACLE_HOME}/clone/bin/clone.pl ORACLE_HOME=/u02/app/oracle/db ORACLE_HOME_NAME=OraDb10g_home2  

 /runInstaller -silent -clone -waitForCompletion  "ORACLE_HOME=/u02/app/oracle/db" "ORACLE_HOME_NAME=DbOra10g_Home2" -noConfig -nowait
 Starting Oracle Universal Installer... 
 No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
 Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-12_12-12-09AM.
 Please wait ...Oracle Universal Installer, Version 10.2.0.5.0 Production Copyright (C) 1999, 2010, Oracle. All rights reserved.  
 You can find a log of this install session at: /oracle/oraInventory/logs/cloneActions2013-07-12_12-12-09AM.log .................................................................................................... 100% Done.       Installation in progress (Friday, July 12, 2013 12:19:30 AM EDT) ...........................................................................75% Done.
 Install successful  
 Linking in progress (Friday, July 12, 2013 12:20:22 AM EDT) Link successful  
 Setup in progress (Friday, July 12, 2013 12:27:50 AM EDT) Setup successful  
 End of install phases.(Friday, July 12, 2013 12:28:39 AM EDT)
 WARNING: The following configuration scripts need to be executed as the "root" user. #!/bin/sh #Root script to run /u02/app/oracle/db/root.sh
 To execute the configuration scripts:
 1. Open a terminal window
 2. Log in as "root"
 3. Run the scripts  
 The cloning of DbOra10g_Home2 was successful.
 Please check '/oracle/oraInventory/logs/cloneActions2013-07-12_12-12-09AM.log' for more details.

You need to have access to run root.sh or get in touch with you UNIX admin to get it executed.

4.Make sure you check/verify  the new path location in all files like tnsnames.ora,listener.ora,sqlnet.ora,ifile location and pfile intDEV.ora


 

6 comments :

Post a Comment

PDE-PEP006 Encoded Program unit has an unknown format

2 comments
If compiling a form in Oracle Apps 11i the below error is occured

Error

Forms 6.0 (Form Compiler) Version 6.0.8.27.0 (Production)
Forms 6.0 (Form Compiler): Release  - Production
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
     With the Partitioning, Oracle Label Security, OLAP and Data Mining options
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #0 - Production
Oracle Virtual Graphics System Version 6.0.5.39.0 (Production)
Oracle Multimedia Version 6.0.8.25.0 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 - Production
PDE-PEP006 Encoded Program unit has an unknown format.


The Cause and solution to this problem is ad below.

Cause

If the 6i form has been opened in higher form builder version(10g or 11g) and saved even if no changes are done. But the form header will contain a slightly different value so when compiling the with formbuilder 6 version it will throw error "PDE-PEP006 Encoded Program unit has an unknown format".
There is not backward compatibility in Oracle forms.

Solution

Try to open the 6i backup fmb in form builder 6 and save . Then try to compile the form.

REFERENCE :- PDE-PEP006 When Opening FMB, MMB or PLL in Forms Builder? (Doc ID 294958.1)

2 comments :

Post a Comment

Calling SuperPutty from Command Line

No comments
Like we call putty from command line the same way we can call superputty from command line.
 
Steps
 
1. Open Command Prompt
 
2. Run the below command. It will launch superputty and automatically login.
 


"C:\Himanshu\Personnal\SuperPutty.exe" <hostname> -l <userid> -pw <password>
 
 

No comments :

Post a Comment