SELECT 'Hostname : ' || HOST_NAME "Host name",
'Instance Name : ' || INSTANCE_NAME "Instance Name",
'Started At : ' || TO_CHAR(STARTUP_TIME, 'DD-MON-YYYY HH24:MI:SS') "Startup Time",
'Uptime : ' || FLOOR(SYSDATE - STARTUP_TIME) || ' days(s) ' ||
TRUNC(24 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))) ||
' hour(s) ' || MOD(TRUNC(1440 * ((SYSDATE - STARTUP_TIME) -
TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' minute(s) ' ||
MOD(TRUNC(86400 *
((SYSDATE - STARTUP_TIME) - TRUNC(SYSDATE - STARTUP_TIME))),
60) || ' seconds' "Uptime"
FROM V$INSTANCE
Subscribe to:
Post Comments (Atom)
Command to do active duplicate for Oracle Database
1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...
-
Srvctl is not able to start database [oracle@orcldb-n2 ~]$ srvctl start database -d orcl PRCR-1079 : Failed to start resource ora.orcl.d...
-
Getting below error in EBS R12.1.3 in Oracle Database SMTP Error. Getting below error while trying to send email in XXXXXXX instance ...
-
Oracle R12 application and getting following error when trying to launch General Ledger Account Hierarchy Manager Java Plug-in 1.6.0_07 Us...
No comments:
Post a Comment