MIME-Version: 1.0
Content-Type: multipart/related; boundary="----=_NextPart_01C94BF9.8D12F6E0"
This document is a Single File Web Page, also known as a Web Archive file. If you are seeing this message, your browser or editor doesn't support Web Archive files. Please download a browser that supports Web Archive, such as Microsoft Internet Explorer.
------=_NextPart_01C94BF9.8D12F6E0
Content-Location: file:///C:/02525983/TimeMachine_Whitepaper_Oracle_Basic.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"

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 alre=
ady
successfully installed Time Machine on your UNIX or Linux system.
1. &=
nbsp;
Grant the =
Oracle
User the rights to set its own virtual clock.
(NOTE: This step is optional, however if not taken all v=
irtual-date
changes will need to be set within the root account)
A.&n=
bsp;
Log
in as root.
B.<=
span
style=3D'font:7.0pt "Times New Roman"'> Run the program /etc/ssstm/tmuser_s=
etup
and select “1“ to grant users the ability to set their own virt=
ual
clocks
C.<=
span
style=3D'font:7.0pt "Times New Roman"'> Exit from the root account
<=
/b>
2. Create a virtual date for the Oracle account=
A.<=
span
style=3D'font:7.0pt "Times New Roman"'> Log in as the Oracle user.
B.
Run
the UNIX/Linux command ‘id’ to determine your user’s ID
Example:
[root@Ellison ~]# id oracle
uid=3D500(oracle) gid=3D502(oinstall) groups=3D5=
02(oinstall),501(dba)
C. &n=
bsp;
Create
a virtual date for February 28, 2012
at 1:17 pm using the ID returned from the step above, in this case
‘500’.
Example:
# tmuser -a -u 500 –x 022801172012<=
/b><=
/p>
D.<=
span
style=3D'font:7.0pt "Times New Roman"'> Start up the original Oracle databa=
se owned
by oracle if not already started
&=
nbsp; &nbs=
p; # su - oracle
&=
nbsp; % [oracle@ Ellison ~]$ sqlpl=
us
SQL*Plus:
Release 10.2.0.1.0 - Production on Fri Nov 10 11:22:49 2008
Copyright=
(c)
1982, 2005, Oracle. All rights
reserved.
&nbs=
p;
Enter
user-name: / as sysdba
Connected=
to an
idle instance.
&nbs=
p;
SQL> s=
tartup
open
ORACLE in=
stance
started.
<=
/b>
E. &n=
bsp; Query the database for time.
SQL> select sysdate from dual;
SYSDATE
---------
28-FEB-12
SQL> select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Curre=
nt
Time" from dual;
Current Time
------------------------
Tue 28-Feb-2012 13:17:15
------=_NextPart_01C94BF9.8D12F6E0
Content-Location: file:///C:/02525983/TimeMachine_Whitepaper_Oracle_Basic_files/image001.png
Content-Transfer-Encoding: base64
Content-Type: image/png
iVBORw0KGgoAAAANSUhEUgAABAIAAACXAgMAAADyqhHFAAAAAXNSR0IArs4c6QAAAAlwSFlzAAAu
IAAALiAB1RweGwAAAAxQTFRFDyKMAGSAAJyx////CIX2MQAAB5pJREFUeNrt3U2S4yYUAGCq2HYV
V8kNuEI2Sc4Ye+EjmKo5QM6RXlGVVVy0SY/dlt6DBzx+3HYstFKrNYA+8Q/qEYJzSP+yhxVTYApM
gSkwBabAFJgCU2AKTIHP47f88esUmAJTYApMgSkwBabAFJgCWxD44/rTaRcdf25L4HKcX07A5cZ2
hMBpkIC7jCoZN17u03cUuESg+AK7VxMwlMDPi2/i9kskcH41gWs6KgROryZgswIiFnh/NQEj6HpA
fqZQUwL81vArez1WQGSrufUOvsCZLeBuk4j6gQLliUyXFXCxwIktsM6j6kYB2y1gljQoroCFAooQ
eOcK2G4BJ3oFnCgLWHyDE8MERLeA6BYwDAGDbxBQ4E3ZWIA7LoALDW31gOkXEBUCGkd6FZD2l2YB
0ytgRbeAqxawYpyA6BRwol/AcARgUXUCCyhpmgVcr4AYICBqBUQoIIxtFbD/MwHv2ALMtsA8gQDK
hzobkYwivQoYYVt7RM8gYDkCDjeFoYC0rb1iMVCg9agQ0BUCvJGRewYB0y9gKYHTKwr4lICyjXNE
jrHB5O4C4k4CQWtAC4B5F/NgAXlNTr0AfJT62XILXv6DBfQ1PSMFcCbICVzbGPcgAQeLoBkq4LkC
X7H+80gB9fXDWIFTUcAkHgBWCq0ChrruUkMTFd2KK4U2AVgOagRQzmgUoJ/LEXc7ug0ImqdGgXOT
gMMN0xK3WZ7JfqUOj2jif4R/VPS6Fy2A5sbRBEJiGEULgHJQIRD0D5oEDO5lfQlYqudFCljUP+gQ
WMsBX8AGEbQIOCoM5cleD1lecDetR8BzBDSV/5ZM0CJggq72VYCe8qcEggnsLoETQ0BRtUCQBasE
6DBuE7pBKhxxLZg87hK4lYOcgEzwX2NoEKDDUIYcghGLduHcXZ+ALwugYmDCsVKDAB2Gooc/LvE0
4OZOgVN5ZCSpOuj2YhoE6DDeyJSHDWco+PPmTgFfFgBBuWisWi+QCKMgIBJvQfYLnMsC6wtAGRBU
QzUCqTASMxHx1dECl8qwICDIDHi5v1dAcgWWBwruHiBwZswRyYECJnwCpoAg8+FnkN0CPzNBcZZM
ERkQpL5GQJQERLYLFgqoAQInzmw5IvFhU9Qg4OnmLCOAe5TajBPwHAHQ/VkzXouACxJeErBh8VjO
bycDBE6MNSOJO2gcATxsDx4XdrpDAZ3thy+nVpARkTMWBYEzZ+V0rcYVPKsWWNMdhLG+zaSAWgXw
kIEr8LtPFQPG6rkaKqDgE6w9XxMLeLLxkciiX+CdsYNCepjAIPXVAkQY8JdwpGyohkOthXSIwIm5
i2aN0jcLJMMQnhYIKoI+gWOqIuDspNLDBQwKY83iWCBoU9Y8FGUnhsAhlQmYu+nM2iaZLgEQhoCv
lRTALdKdBP5m7KhUaI4ap36UgKcEHCEAnrVKYF8t4O8pYFEYOiWA5xX7BHYpgX+TAhb6g1TZVgFR
L+AGChyrBfxdBFSVAHgNulfgUC/ggP+jBNZyoEHoTQKpYvCR+cbEfpOAzwg4UsAHbQhL4FgvsLyA
7xAwtACYsjSdAvsGAfcEAutaaa9AIhNkBdYlzQcKuGEC+wYB9wQCy2xCbz2QyAR5Af8MAjYWaGoL
EpmgIGC+onqkgIMCokeAzAQFAcsVkB6dVfUJoUCyKA4R2LUKMMYFDAHzBAKHOwuItrHhNwoQ5YAp
EKZetgqIXgENC2e9wK6tJmTMEWWmcAmBKIzvE9gzBVS1gGYKaLbAj6A1ZM4T6rxAVBUkBETQHzAB
Okz98kJsKKCRgM2EQQkYhdujQQJhVZASkLhPaJfYl7NAQMLt8BkBxReAeWgRKK4XFAV2PAFoLeHr
NQkBoS1LQJKKtABcsNPlNSNyayohsGcIOIEXtcCuT5ESuB0yTAyuJugwaAFw8yqgk+uGXAFcFXww
vjOCy1tW4AfKCkhKQFHrzymB9fDE2jEpIMsCu1oBRS7yOpwnKYHP21R6B0W1AL4Q7GqEkf5VEtjX
C+T2kGQEeHtIBgvgxyEFYHvAEdA+u4+ILWA6BKQn9hGFAoYtsB8q4CkBQwjYTBiEQPTCo71k7QIg
E3wwv7i0ifS0C6hqAT9QYF8tkNlTSuQPWiAXRklAR1dkLGD5Amsm+OB+c5owQQJyvd0SAr5DIK4Z
VJ/AoUJARbEHLfGSu1X4btbWW0dP4GsEMCvocCIBVyGwzwsQUdl0O7Su6xQEMmEUBFT8YnyfwI4v
IONsEbZDS6LA/ZRALoy8gI4aSEUI+BqBI1tARc1zVAeZ23UQvSEE6O+MOAJxujQlYO4iEF+L6iB7
uw6it5SAS4eRFVDRNekpAVshcOAKqChFMoobLS3hUiPL3xsyBOKEaVLADRMA2TVuIIj8Z0DDh/fj
y/I3pykBF+Z4kDDlSQHiE7FWgQVbR0nSnjhEane2IttZ5TkH+R1i9IiFSJsF8PtciWv+nqcgv72u
CcMS5Db/p30EtUO9viZ8oWMKNPaIpsAGBPabFzhsXuC4eQG/dYHD5gWOmxfwWxc4bF7guHkBvz2B
+T86TYEpMAWmwBSYAlNgCkyBrQuUjykwBabAFJgCU2AKTIEpMAWmwBR4ZYH/AOpi1ORAm9BHAAAA
AElFTkSuQmCC
------=_NextPart_01C94BF9.8D12F6E0
Content-Location: file:///C:/02525983/TimeMachine_Whitepaper_Oracle_Basic_files/image002.jpg
Content-Transfer-Encoding: base64
Content-Type: image/jpeg
/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCAAoAQ4DASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDzrRdH
l1q7S0tlZ7iVwkaAgbj9TXVN8JfFCLk6VMfpLGf61V+GP/I7aV/19L/I19SV7WMxdSjV5Y7Hm0qT
quV5NWf6Hyde+Dr7Trk293BJFMBkoXUkfXBqt/wjkv8Adf8AMV7P4g+HepLdz3Wnyi8jkYuUdsSD
PPfg1xV1Z3NjMYbu3lgkH8MilTWtPEOa0keHicRjKEmpKy/rqef39gLLAJbfuwQcV9g2X/Hjb/8A
XJf5V8meIv8Aj4P++P5V9Z2X/Hjb/wDXJf5Vy5hJuEG/P9D3MsqSqUuaW5PSEhRkkAeppa+X/FOv
6n408dSafcan9ksjdm2hSWQpDCobbuYevGSTXHhsM67etkjvnPlPp5XRjhWUn2NOrxfSPgtqOk63
pmpQa/DPFDcRyyoEZNyAgkAgnOfevVNd8RaT4asftmrXiW0RO1d2Szn0UDkmpq0oqSjSlzX8hqTt
7ysalRXNzDZ2stzcyrFBCheSRjgKoGSTXAQfGvwbNcCJp7yJScebJbHb+mT+ldD4nvbXUfh3rF5Z
zxz20unTNHJG2VYbD3pOhUjJKaauHMmtC7pHifRNelki0rU7a8kiUM6wvkqD3Na1eCfANgmt60x6
C1Qn/vo16joPxE8N+JdUGnaXeSS3JRn2tCyjA68kVricM6dSUYXaQoTurs6qiuW1/wCIXhzwzqf9
n6pdyRXOwSbVhZhtOccge1c98TPiFb6JpE+naZqElvrbpHJFthJwjHk5IwDjNZ08PUm0ktxuaR6V
WIfF/h1dW/so6xaC/wDN8n7Pv+ff/dx615t8JvH1p9kbS9a1O6uNYvr4+V5oeTcCqgfN0HIPFNls
PAZ+KvntrGojW/7SDfZxF+787cMLnb0z71t9U5ZyhO+i6L+tCee6TR7NRWRr/ifR/DFotzq96luj
khFOSzn0VRya5O3+NXg2e5ETXF3ApOPNltiF/TJH5VzwoVZrmjFtFOSWjZ6HRWdd65p1noUmtSXK
vp6RecZovnBT1GOtc2Piv4POly6gNSbyo5PL2mFg7tjOFXGTx36Uo0aktYxbG5Jbs7WiuT8MfEbw
54su2s9PuZEugu4Q3EexmA67ex/OuspThKD5ZKzBNPVBTTJGDguoPua8w+NfifUdD0ewsNOne3a/
Z/NmjOGCKB8oPbO7r7VwHhL4WXHjDQ11VPEUEckhbMO0yOpBx853DBOM/SuqlhIul7WpLlT8rkOp
73KkfSFFcz4F8P3XhTwpHpuoXSTyxSSO0ocldpOR97oMdqyNT+MXg/TbprcXk12ynDNawl1B/wB4
4B/CsFRlKTjT96xXMkrvQ72q99f2mm2j3d9cxW1vGMtJK4VR+JrG8N+OPD/ivcmlXwedBuaCRSkg
HrtPUe4ryL4zeMdP1w2ek6bdO/2O4l+1xlGUB1wq9ev8VaUMLOpV9nJNdxSmlG57Do/jLw7r941p
pWrW91cKpcxpnO0dTyPet2vCfhtrPgLw1YJqc11cjWVtiLsmN2VQzjgADH90ce9ZNl8Srqb4lR6h
qetXTaFDcytHGoIQR4YJlFHJ5HXJreWAk5yUL2Xfr6EqqrK59BX2pWWmQrLfXUVvGx2hpGwCapze
KNBt7UXU+sWMUBkMQkedVG8DJXk9cEHHvUcdzaeMPDC3GnXB+zXYBjlZCPuvzwcHqprj/FHwpPiO
e4kGqLEst0bkRtDuCswIY9epAjH/AAD3rmpwp3tVdi230PF/Bd+2ma7aXyIHaCdX2nv7V9M6N4p0
nW41+zXKrMRzBIdrj8O/4V8teH/+Plf98V1/Q5716mLw8as3fc+bq5jUwldpK6fQ+j6q3+nWep2z
W97bxzRHs46fQ9jXjGk+Mdb0l1EV208Q/wCWM/zg+w7j8K9qsp3urG3uJYWhkkjV2jbqhIzivKq0
JUWnc9bB46ljYtJeqZ8wfEPTE0fxNeWEblo4pV2E9cFQRn86+n7L/jxt/wDrkv8AKvm74uf8j1qP
/XSP/wBFrX0jZf8AHjb/APXJf5V1Ytt0Kbfn+hWCioKUY7Jv8yevJPG/wZXWtSuNV0O7jt7idi8t
tOD5bMepUjlc+mCPpXrdeH6x4U+KFr4i1O70W7mW1u7mSVEhvgAFLEj5Xxjj0rLBuSm3Gaj69Tqq
WtqrnFafrnin4beJRYzTzR+Q6+fZNLvikQ88dhkdCMVo/GXUJ77x+0EjkQW9vEsKnooZQxP1yf0F
beg/B/xHquvJqXiu4VIvMEswabzZZ8fwkjgDjHX8K6/4l/DFvFssWp6XLFDqUaCN0l4SZB05HQiv
SeJoRrxk2r21a2uY8knFoy/Hvw88NaT8NZrqxtI4buyjjdLpT80pJAO4985/liud+Gt9cSfDjxtY
OxNvDaPLGD/CWjcNj/vkUyfwB8UNVsYNGv5wdOgKhFmu1KADp0+Y4969G0X4e/8ACO/D3VdFtZVu
NSv7eQSzN8qtIUKqB6KM/wAzWMqkYUuSU+Zt39Ckm5XSseffAj/kK67/ANea/wDoRrK+C7KPiPGC
QC1tMB7ng13/AMKfAOueENT1GfVkthHcQLGnlS7+QxJzxXKax8H/ABRp3iSW78Nyxtb+YZbeUXHl
SRZP3T9M4yOorR1qU6lWPMlzJa/IXLJJO2xm/Gx1b4hlVYEraRBgD0PJ5/Aiu0+L+g6X/wAIVHrn
2NP7Tzbw/aMnds9MZxXMan8GPFs8kNyby3vbuZd91JLOeHz0BIy3GOa9f8XeF28T+C5tF8xYrgoh
ic8qsi4Iz7cY/Gs51qcHRUZXtv8AgNRb5ro89+CnhnRtQ0N9Yu7COXULW/IhnJOUwqEY5x1Jrkbj
/kvn/cbX/wBCFdL4I8I/EbwtrcFuixxaQ9yj3aieNldcgEj+IHHpjOKtS/DTxE/xV/4SEJaf2f8A
2kLnPnfPsDA9Mdav2kI1pyc001pr+ArNxSscb8VbqbU/ihcWtzIUhhaK3j3HiNCFJP5sTXbfE3wD
4b0TwCbzTrJLa5tGjVZVPzSgsAQx/i65/CtL4l/C2bxVejWNImijv9gSaKU4WYDoQexxx+Vcbc+A
fifrttb6XqlwpsYCNnn3alBgYB+XJbA9aKdWEo03GfLy7oHFpu6vcPBl7cTfBfxhZyOWhthmIH+H
cMkD2yM/iao/CPwZpfizUdRk1eNpre0jQLCHKhmfPJI54216hB8PDo3ww1Lw5p0iT6heRMZJn+RX
kOPyAAwKqfCfwRrPg99VOrLbgXIi8vyZd/3d2c8D1FRLFQ9nVdN2ben4DUHeNzy2x01PDvxrtdOs
3dYrfVEjjJOTsJHBPfg4rvvEvif4nWniXULfSNHebTo5StvILEvuXA5znmmXnw48Qz/FkeI0S1/s
8X8dxkzfPsGM8Y68V7FWeIxMLwlZS01uVCD1WxwV34Vl+IXgHTk8SI9lrCqZPMWPa0T5IwVPYjGR
9K8e8S+APEvw/wAaql2pt1cKt5aSlGUnpkdR+or2L4m+H/Emu2mmN4an8m4tZmdys5ibkYGD+dea
3ngP4peIhFa6vNJJbq2R9pvUKKfXC5JP4Vpg6tldzSi76Pp6E1FfpqXm8d6trfwW1b7VKzXsE8dp
JcLwZI3wcnHfGQfWj4NeDtC17TtSvtVtIrySOUQJFJyI125Jx6nPX2rvdD+Gdjp3gG68NXcxme9y
9zOgxiTjBX2XAx/9evO4Phx8RfCV7P8A8I7eI8UuFaSCZU3jtuV+hH49acatKUJ06cuW706A4yTT
auc28I8J/F9bfSXby7XUkjjAbJ2MQChPfhitdL8bfD2k6NdaZdadZJbz3sk8lw6knzGypycn1Y/n
Wz4H+Eep2niGLXvE1xG00MvnLAj+YzyZzudunXnjPNbfxY8E6z4w/sr+yVtz9m83zPOk2fe24xwf
Q1TxMPrELS0S1fcXI+R6DPAXgLwvqPgXTLy70eGW4u7Yee5Zsv8ANnnB9QPyryjwto2nX/xVj0m6
tVlsDdzxmEk42qHwPXjAr6H8GaVdaH4P0vTL0ILm2hCSBG3DOT0NeTeJfhf4qsPGc2t+GPLkR7g3
MLLKqPCxOSCG4IyT+FZ4fEXnUjKdr3tdlShomke16Zpllo2nQ2GnwLBawgiONSSFycnr7k1brE8J
R67H4btl8SSK+q5czFSpH3jt+7x0xW3XlTTUmm7my2PjSxvvsZJCtuzkEdqv/wDCRTesv5iiivq5
UYyd2eRUwtKpLmkrsmtPFl7Y3KXFtLIkyHKthTg/iK1v+Fp+KP8AoLXX5J/hRRUPC0pbocMPCmrQ
uvRnO6zrdxrl011eSSS3LsC8j4y2BgdPYCvruy/48bf/AK5L/KiivMzSChGEY7a/oduGio3SJ6KK
K8g6gooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//
2Q==
------=_NextPart_01C94BF9.8D12F6E0
Content-Location: file:///C:/02525983/TimeMachine_Whitepaper_Oracle_Basic_files/header.htm
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset="us-ascii"