There are 2 methods to move the data files of the tablespace to other location.

1 . When Database is Up (for some tablespace or datafile)

To move or rename the Data File  when database is up we should take the related tablespaces (eg. TESTD) offline, at this status we can’t do DML or SELECT to all objects that stored in that tablespace.

ATTENTION: You can use this way if the datafile that need to be changed or moved is not belong to SYSTEM tablespaces, and not contain active rollback segments or temporary segments.

• Take the Tablespace Offline
  • [oracle@levicorp ~] sqlplus ‘/as sysdba’
  • SQL > ALTER TABLEPSPACE testd OFFLINE;

To Extend Logical Volume :
Scenario :
Increase size of /backup to 90GB
 

$ df -H
 Filesystem              Size   Used  Avail Use% Mounted on
 /dev/mapper/vg00-lvol01 6.3G   187M   5.8G   4% /
 /dev/mapper/vg01-lvol02 8.3G   3.0G   5.0G  38% /archive
 /dev/mapper/vg01-lvol03  83G    11G    69G  13% /backup

Sometime we need to move Temporary Files to other location. This steps will guide you how to do that easily and safety

1. Login as SYSDBA
2. Check the Tempfile status

SQL> SELECT v.file#, t.file_name, v.status
 2  FROM dba_temp_files t, v$tempfile v
 3  WHERE t.file_id = v.file#;

 FILE#     FILE_NAME                 STATUS
---------- ------------------------- -------
 1         /u01/temp01.dbf           ONLINE
 2         /u02/temp02.dbf           ONLINE
 3         /u02/temp03.dbf           ONLINE 

After we assigning some responsibilities to a user in Oracle E-Business Suite. Unfortunately when user login to the system, he can’t found the responsibilities that he want in the web navigator. This problem usually happen after upgrading or patching.

To solve this problem :

1. Set the role_end_date to null in the wf_local_user_roles.
The sql used will depend on the responsibility missing. For example for the System Administrator responsibility, type in the following:

UPDATE wf_local_user_roles
 SET role_end_date = NULL
 WHERE user_name LIKE 'SYSADMIN%'
 AND role_name = 'FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD';

or

If we using Storage Area Network (SAN) with FC,  SAN can do scanning  all connected FC in the SAN Switch. From SAN storage we can get the World Wide Name (WWN) of the HBA –each HBA has unique WWN (same as MAC Address in the PC), but if there are many servers connected the FC into the same SAN Switch, might be we can get difficulties which server has particular WWN.

In this topic I only discuss how to know the WWN of the HBA in HP-UX server.

To monitor event in HP-UX server, first we must install and running Event Monitoring Services(EMS). After that we can use monconfig (a utility that allows a superuser to manage hardware event monitor requests for EMS).

In this working note, I will show you the example steps through creating a monitor request and sending any alerts that are greater than or equal to (>=) “Major Warnings” to an EMAIL address

Continue from previous posting.

B. Upgrade the Database of Oracle EBS

1. Check Prerequisites

• Compatibility

If the database still using original DB (EBS 11.5.9 using Oracle DB 9i) then we need to upgrade it first. Check the compatibility matrix on NOTE: 316889.1, which path that we must take. Minimum Version of the database that can be directly upgraded to Oracle 10g Release 2

      8.1.7.4 -> 10.2.X.X.X
      9.0.1.4 or 9.0.1.5 -> 10.2.X.X.X
      9.2.0.4 or higher -> 10.2.X.X.X
      10.1.0.2 or higher -> 10.2.X.X.X

The following database version will require an indirect upgrade path.

      7.3.3 (or lower) -> 7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      7.3.4 -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      8.0.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X
      8.1.n -> 8.1.7 -> 8.1.7.4 -> 10.2.X.X.X