The power on sequence is as follows: Rack, including switches.Ensure that the switches have had power applied for a few minutes to complete power-on configuration before starting the storage controllers and compute nodes. Storage server heads attached to the chassis of the storage device.Wait for a few minutes for the storage appliance to boot and […]
The Exalogic power off sequence is as follows: Shut down all VMs (shutdown -h -y now) Compute nodes : Compute nodes and controllers can also be powered off by using operating system commands. For example, you can use the following command on the Oracle Linux operating system: shutdown -h -y now Storage server heads attached […]
Check Archivelog mode You can run the following command to check if you are running in ARCHIVELOG mode : [oracle@raafat ~]$ sqlplus “/as sysdba” SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 8 11:03:52 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With […]
You can check the Oracle DB uptime by run one of the following commands : SELECT host_name, instance_name, TO_CHAR(startup_time, ‘DD-MM-YYYY HH24:MI:SS’) startup_time, FLOOR(sysdate-startup_time) days FROM sys.v_$instance; OR SELECT TO_CHAR(logon_time, ‘DD-MM-YYYY HH24:MI:SS’) FROM v$session WHERE program LIKE ‘%PMON%’
Here are the steps to solve the problem of expired and locked accounts : log into your host running oracle and become the oracle user : -bash-4.1$ sqlplus / ‘as sysdba’ SQL*Plus: Release 11.2.0.3.0 Production on Sun Nov 8 14:33:23 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise […]
Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. If you want to delete archivelog from FRA(ASM Storage -Flash Revovery Area) or filesystem to free space, you can use the following commands: Start the RMAN executable at the operating […]
Copyright © 2015 Raafat IT blog
Theme created by PWT. Powered by WordPress.org