Oracle Cloud Computign - Introduced by Oracle

Here is the video by Oracle that presents the Oracle Cloud Computing Technology. Enjoy...

Monitoring User Activity with “Sign-On: Audit Level” Profile Option in Oracle E-Business Suite R12

1.      Overview:

Users Activity in Oracle E-Business Suite can be monitored online (using a given form) or via reports available in the system administration responsibility.

The online monitoring of user activity within Oracle Applications is achieved via the Monitor Users form (Form Name: FNDSCMON.fmx). In order to use this form and also to use the reports the profile option Sign-On: Audit Level must be set to an appropriate value. The available options are: - 

Useful Select Statements

To view the default tablespace:

SELECT PROPERTY_NAME, PROPERTY_VALUE

FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

To view the database name:

SELECT NAME FROM V$DATABASE;

Moving Data between two AIX Servers using Shared File System

 Part 1: Introduction:

This document describes how to move data between two AIX servers using shared file system. The concept used is that one machine share a file system over the network and allow other machines to access this file system. In our example the source machine that we move data from, is called Production Server and the destination machine that we move data to, is called Test Server, so we are moving data from Production to Test. Note that this approach can be used with clone purpose of Oracle Applications or database (Like In our case) or any other task that requires moving data between two server. The steps are as follows…

Day 1: Documenting the Database Environment

Hi everyone,

Today is my first day blogging my current experience dealing with oracle database as database administrator and Applications administrator. I decided to start with documenting the environment I work with as this task is really missing out of most DBAs. To review more information about the importance of documentation google for “The Art of Being a Successful DBA” from Remote DBA web site.

So today I’ll document the environment I work with like if it is the first time I meet this database(s).

Changing default desktop in Linux

There is a configuration file called /etc/sysconfig/desktop. This file defines default display manager and desktop name.

Changing Desktop from Gnome to KDE

1. Open /etc/sysconfig/desktop file:

    # vi /etc/sysconfig/desktop

2. Set DESKTOP variable to KDE instead of GNOME:

Accessing Linux Desktop from Windows XP using TightVNC

You need to use TightVNC server software on Linux and TightVNC client on Windows XP desktop. With TightVNC, you can see the desktop of a remote Linux machine and control it with your local mouse and keyboard, just like you would do it sitting in the front of that computer.

Step 1: Install TightVNC server on Linux

1. Download TightVNC server from www.tightvnc.com into your Linux server.