Tuesday, February 26, 2013

To Install Firefox on Linux server

FTP the software from Mozilla site.


ftp ftp.mozilla.org
user: Anonymous
cd pub/firefox/releases/

Extract the software
tar xjf firefox-10.0.tar.bz2

you should have root privilege to install in the server:

sudo rm -r /opt/firefox
sudo mv firefox /opt/firefox10
sudo mv /usr/bin/firefox /usr/bin/firefox-old
sudo ln -s /opt/firefox10/firefox /usr/bin/firefox

Now you can use firefox from Linux server VNC.

How to create read only user in oracle Apps database

Use the below step to create a read only user who can have select privilege in oracle for all apps objects.

create user readonly identified by readonly default tablespace users temporary tablespace temp;
grant connect, select any table to readonly;

Enable archivelog mode in Oracle 11g database

First lets check the current log mode:

SQL> archive log list

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 67
Current log sequence 69
  or   SQL> select name, log_mode from v$database;
--------- ------------

SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter system set log_archive_dest_1='location=/home/oracle/archivelog' scope=spfile;

SQL> shutdown immediate
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;

SQL> select name, log_mode from v$database;

--------- ------------

SQL> alter system switch logfile;

To install Telnet Client on Windows 7 or Windows Vista

Login to Windows Desktop

Click Start, and then click Control Panel.

On the Control Panel Home page, click Programs.
In the Programs and Features section, click Turn Windows features on or off.
If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

In the Windows Features list, select Telnet Client, and then click OK.

How to fix upload file issue in Oracle support site

Here is the fix for the uploading the files to Oracle support site

Open Internet Explores & Click on Tools Menu

Tools-> internet options -> security -> custom level ->Include local Directory Path when uploading files to the server (enable)

How to Validate Oracle Applications frontend password

Here is the step to validate Oracle Applications frontend password from Sqlplus:

sqlplus apps/apps

select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;
select fnd_web_sec.validate_login('sysadmin','sysadmin') from dual;