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" Quickstart - Oracle Database & Time Machine

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;     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;     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"





 

TM505ORA4ORCLXXGWP         &= nbsp;        Basic Setup for Oracle Datab= ase Server with Time Machine &nbs= p;            &= nbsp;           &nbs= p;            &= nbsp;           1

------=_NextPart_01C94BF9.8D12F6E0 Content-Location: file:///C:/02525983/TimeMachine_Whitepaper_Oracle_Basic_files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C94BF9.8D12F6E0--