change HP server boot order remotely using iLo

1). SSH to HP server
2). cd system1/bootconfig1
3). show bootsource1 #please write down the bootorder number, I use 1 in this case
4). set bootsource1 bootorder=1 'this will give you the descriptive msg'
5). set bootsource$b bootorder=$p 'replace $b and $p to the device and boot order you want to set'

6). voila. reboot the machine.

add temp table space

alter tablespace temp add tempfile size 128m autoextend on next 32m maxsize 8g;

Oracle turn on Archive mode

his is a two-step process. email if you have questions: fayoubi@gmail.com

STEP ONE : Modify your initSID.ora

Modify your initSID.ora to include the following three lines:

log_archive_start = true
log_archive_dest = /mount_point/oradata/SID/ARCHIVE/arch
log_archive_format = _%s.arc

log_archive_start: This parameter specifies whether archiving should be started automatically when the database is started.

log_archive_dest: This value specifies the default location of the file to be used when archiving redo log files.

log_archive_format: This parameter is used to specify the default file name format for the archive log files, this value is appended to the log_archive_dest value ( %s is the log sequence number ).

STEP TWO : Starting archive logging

The final step to starting archive logging, involves an Oracle SQL*DBA command which is run when the database is mounted but not open.

With the database shut down, use one of the many DBA tools available to manually start the database ( I still prefer to use SQL*DBA ) and execute the following sequence of commands:

startup mount exclusive
connect internal
alter database archivelog;
alter database open;

Now check to ensure archive logging is running. Whilst still connected internal, execute the command archive log list as shown below:

SQLDBA> archive log list
Database log mode ARCHIVELOG
Automatic archival ENABLED
Archive destination /mount_point/oradata/SID/ARCHIVE/arch
Oldest online log sequence 2
Current log sequence 3
SQLDBA>