Solved

Change date in Sco Unix 4.2

Posted on 2003-12-07
6
4,636 Views
Last Modified: 2013-12-05
I got a system which  is Oracle database system run under Sco Unix 4.2. for circumstance I might need to change my system date. like 08/11/2003 to 08/11/2002, how can I make sure both Sco Unix 4.2 and Oracle databse be changed also?

so I not reallly familiar on both OS and Oracle. please advise me.

thanks
sukfliu  
0
Comment
Question by:sukfliu
6 Comments
 
LVL 38

Expert Comment

by:yuzh
ID: 9892129
You can change the date in the PC BIOS (CMOS).

or login as root

use "date" command to retset the date
man date

to learn more

if you use "date" change the system date, you need to reboot your system.
0
 
LVL 1

Expert Comment

by:edvinkv
ID: 9902193
sqlplus scott/tiger;
select sysdate from dual;


on the unix box run..
date to check the system data.

date can also be used to set the system date.

Thx.
0
 
LVL 62

Expert Comment

by:gheist
ID: 9902576
run date -y to see format it accepts
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 6

Expert Comment

by:bira
ID: 9903484
See man date in order to find out the format to use, for that
differs from some kind of unix.

Once Oracle gets the date from OS, it will be right to the
database.
0
 
LVL 7

Accepted Solution

by:
sppalser earned 500 total points
ID: 9907918
if you have uod426d installed on your system then you should be y2k compliant and the date command will work correctly.  Use:

     date mmddhhmmyy

for example today is 12/09/03 and approx 3:52PM

     date 1209155203

Good Luck.

0
 
LVL 1

Expert Comment

by:stan64
ID: 9921024
on 3.2.4.2 you also have a utility called asktime which is the same format as the time/date check when you boot the system.  setclk will read/write the real time clock to/from your system time.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question