Standard Oracle Configuration for Unix and Linux

Setting up an Oracle Database to run Time Machine

This paper covers the basic process on how to configure Oracle server on a UNIX or Linux system for date & time testing with Solution-Soft’s Time Machine®.

The following assumes you have already successfully installed Time Machine on your UNIX or Linux system. 

1. Grant the Oracle User the rights to set its own virtual clock.

(NOTE: This step is optional, however if not taken all virtual-date changes will need to be set within the root account)

A.      Log in as root.

B.      Run the program /etc/ssstm/tmuser_setup and select “1“ to grant users the ability to set their own virtual clocks

C.      Exit from the root account


2. Create a virtual date for the Oracle account

A.       Log in as the Oracle user.

B.       Run the UNIX/Linux command ‘id’ to determine your user’s ID

[root@Ellison ~]# id oracle
uid=500(oracle) gid=502(oinstall) groups=502(oinstall),501(dba)

C.       Create a virtual date for February 28, 2012  at 1:17 pm using the ID returned from the step above, in this case ‘500’.

# tmuser -a -u 500 –x 022801172012

D.      Start up the original Oracle database owned by oracle if not already started

                                # su - oracle

                       % [oracle@ Ellison ~]$ sqlplus

SQL*Plus: Release - Production on Fri Nov 10 11:22:49 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Enter user-name: / as sysdba

Connected to an idle instance.


SQL> startup open

ORACLE instance started.

E.  Query the database for time.

SQL> select sysdate from dual;

SQL> select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Current Time" from dual;
Current Time
Tue 28-Feb-2012 13:17:15