OraNA :: Oracle News Aggregator

I have been using Vista for about 3 months and finally found a way to start my databases with a single double-click

The method I used until yesterday was a .BAT file that starts the services, I had then to right click on the shortcut, run as administrator, confirm the UAC warning. 3 Clicks. Way to much…

I have googled quite a lot and found Vista setuid - How to elevate without prompting

Ok, here we go :

1) run mmc
2) file - add snapin
3) Task Scheduler Library - Create Task
4) Name: startoracle
Run with highest privileges
Actions - New - Start a program - Program:net - Arguments: start OracleOraDb11g_home1TNSListener
Actions - New - Start a program - Program:net - Arguments: start OracleServiceLSC01
Actions - New - Start a program - Program:net - Arguments: start OracleServiceLSC02
…
5) create a batch file that runs : schtasks /run /tn startoracle

Same for stoporacle

It seems to work fine. Do not play too much with mmc if you do not know it. It is a powerful tool

select 
  timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-
  timestamp '1998-02-01 00:00:00 Europe/Zurich' 
from dual;
+000003802 22:59:59.999999999
select (
  timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-
  timestamp '1998-02-01 00:00:00 Europe/Zurich' 
  ) year to month 
from dual;
+10-05

I will tune my book in July and start a new challenge in August

It is quite a while I have not posted about Linux. The reason is I have bought in new notebook three months ago with Vista and did not have a program to resize the partition…

Do I need a program?
NO, I do not !!!

Vista has disk management that can resize my online partition.

Run: compmgmt.msc /s
Or go to control panel.

And shrink/extend your volumes!

How do I get the current number of milliseconds since 1970-01-01.

I still have no access to oracle.com so I created a new account to answer this question.

Either you use the difference between timestamp ‘1970-01-01 00:00:00 +00:00? and current_timestamp, or you can use java, which is more portable.

YMMV

create function epoch return number as language java name 
  'java.lang.System.currentTimeMillis() return int';
/ 
select epoch from dual;
           EPOCH
----------------
   1214562599878