Binoy Kumar

(RHEL4 )     Overview The Linux distributions certified for Oracle Database 10 g Release 2 are: Oracle Enterprise Linux 5 (OEL5) Oracle Enterprise Linux 4 (OEL4) Red Hat Enterprise Linux  5 (RHEL5) Red Hat Enterprise Linux  4 (RHEL4) Red Hat Enterprise Linux 3 (RHEL3) Asianux 2.0 Asianux 1.0 We will cover the RHEL4 distributions only here.     Part I: Installing Linux   RHEL4 Boot the server using the first CD. You may need to change your BIOS settings to allow booting from the CD. The boot screen appears with the boot: prompt at the bottom of the screen. Select Enter to continue with a graphical install on the console. (For other installation methods and options, refer to the Red Hat Installation Guide .) The installer scans your hardware, briefly displays the Red Hat splash screen, and then begins a series of screen prompts. Language Selection Accept the default. Keyboard Configuration Accept the default. Welcome Screen Click on Next . Disk Partitioning Setup A thorough treatment...

It might be the wrong version that I had but it was not the version 1 of ASM. Here is how I fixed it. [root software]# rpm -qa | grep -i asm oracleasm-2.6.9-22.EL-2.0.0-1 oracleasmlib-2.0.1-1 oracleasm-support-2.0.1-1 oracleasm-2.6.9-11.0.0.10.3.EL-2.0.0-1 oracleasm-2.6.9-34.EL-2.0.1-1   [root software]# rpm -e oracleasm-2.6.9-22.EL-2.0.0-1 [root software]# rpm -e oracleasmlib-2.0.1-1 [root software]# rpm -e oracleasm-support-2.0.1-1 error: Failed dependencies: oracleasm-support >= 2.0.0 is needed by (installed) oracleasm-2.6.9-11.0.0.10.3.EL-2.0.0-1.i686 oracleasm-support >= 2.0.0 is needed by (installed) oracleasm-2.6.9-34.EL-2.0.1-1.i686   [root software]# rpm -e oracleasm-2.6.9-11.0.0.10.3.EL-2.0.0-1.i686 [root software]# rpm -e oracleasm-2.6.9-34.EL-2.0.1-1.i686 [root software]# rpm -e oracleasm-support-2.0.1-1 warning: /etc/sysconfig/oracleasm saved as /etc/sysconfig/oracleasm.rpmsave [root software]# rpm -qa | grep -i asm [root software]# ps -ef |...

Task: Set or change user password Type passwd command as follows> $ passwd Output: Changing password for oracle (current) UNIX password: Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully The user is first prompted for his/her old password, if one is present. This password is then encrypted and compared against the stored password. The user has only one chance to enter the correct password. The super user is permitted to bypass this step so that forgotten passwords may be changed. A new password is tested for complexity. As a general guideline, passwords should consist of 6 to 8 characters including one or more from each of following sets: => Lower case alphabetics => Upper case alphabetics => Digits 0 thru 9 => Punctuation marks Task: Change for any user You must login as root user, type the command to change password for user vivek: # passwd oracle Output: Enter new UNIX password: Retype new UNIX password: passwd: password updated ...

Following is the procedure to reset root password if you are using GRUB as a boot loader: Select the kernel Press the e key to edit the entry Select second line (the line starting with the word kernel) Press the e key to edit kernel entry so that you can append single user mode Append the letter S (or word Single) to the end of the (kernel) line Press ENTER key Now press the b key to boot the Linux kernel into single user mode At prompt type passwd command to reset password Change the root password, enter: # passwd Finally reboot system: # sync # reboot

The cause for missing image and JavaScript error regarding Oracle Application Express Missing Images And JavaScript Error was the wrong image prefix.   The correct installation should have "/i/" instead of "/apex/TEMP". C:\\oraclexe\\apex\\utilities>sqlplus /nolog SQL> connect / as sysdba Connected. SQL> @reset_image_prefix.sql   It will prompt for Enter the Application Express image prefix [/i/]   Just enter and go forward... Ur problem is solved..   The reser_image_prefix.sql is available in the apex_home/apex/utilities folder After using reset_image_prefix.sql to update the image prefix the images that are missing now shows. Trying to login the administrator or developer page also now works. If you still experience some problem maybe the cause is different one

  apxchpwd.sql is used to change the password. You will be prompted for 'Enter a password for the ADMIN user '   Enter it and your password is changed   See the apex admin password change script provided by Oracle Rem Copyright (c) Oracle Corporation 1999 - 2007. All Rights Reserved. Rem Rem NAME Rem apxchpwd.sql Rem Rem DESCRIPTION Rem Used to set the password for the Application Express ADMIN user. Rem Rem NOTES Rem Assumes the SYS user is connected. Rem Rem REQUIREMENTS Rem - Oracle 9.2.0.3 or later Rem Rem Rem MODIFIED (MM/DD/YYYY) Rem jstraub 08/08/2007 - Created Rem jstraub 09/04/2007 - Added HIDE to PASSWD accept (Bug 6370075) Rem jkallman 09/09/2008 - Change FLOWS_030100 references to APEX_030200 Rem   set define '&'   set verify off   prompt Enter a value below for the password for the Application Express ADMIN user. prompt prompt   accept PASSWD CHAR prompt 'Enter a password for the ...

Download apex3.2 Unzip and place it in c:\oraclexe\ In command prompt type cd c:\oraclexe\apex Then run sqlplus connect – sys as sysdba Declare oracle_home Then type @apexins password SYSAUX SYSAUX TEMP /i/ Once you complete the standard install, you need to perform the following steps to complete the upgrade: Connect to SQL*Plus as SYS @APEX_HOME/apex/apxldimg.sql APEX_HOME @APEX_HOME/apex/apxxepwd.sql password (where password is the password of the Application Express internal ADMIN account) For the steps above, APEX_HOME is the directory where the Application Express software was unzipped. In our case c:\oraclexe\