is Http service enabled on Web ILOM Url ?

What if your https:///iPages/i_login.asp doesn’t work ?
connnect ILOM IP with ssh connection,

set /SP/services/http servicestate=enabled
Set ’servicestate’ to ’enabled’

and then invoke your address again
https:///iPages/i_login.asp

Advertisements

How to reset Exadata root password

This is a little bit Linux server issue.If you’re familiar with resetting root password on Linux server,it will be easy for you.
Here the action plan:

Please note: From step 2 below all commands have to be executed on System Console (either directly sitting in front of the physical system with console screen attached or via Web Based ILOM remote console option.

1. Reboot via the ILOM either:
via the web interface:
go to “System Overview”, at “Host Power” choose ‘Power Cycle”
From ILOM web interface start remote console by going to Remote Control -> Launch Remote Console
via ssh:
reset /SYS
2. When the splash screen appears, immediately hit the ESC key. Please note, here is a short window for this , so carefully watch the terminal.
3. Select a line and enter “p” enter password > sos1Exadata —> Generally this password works
On the storage servers use the “default” entry, which is usually the first entry in the grub boot menu
4. At the grub line starting with “kernel” add at the end the following string: “single init=/bin/bash” —> Syntax is very important,please be carefull
5. Hit “Enter” key (will save changes )
6. Hit “b” key (to boot)
7. On the command line: mount -o remount,rw / (mount / in read/write mode) –> without executing this commmand,the OS is read-only mode
8. On the command line: passwd (change the password)
9. On the command line: the following command, which will avoid the requirement to reset password and expiration every 90 days:
# chage -d 14000 -E -1 -m 0 -M -1 root

10. To resume the boot process, run steps 11 and 12:
11. On the command line: mount -o remount,ro / (mount / in read-only mode, as expected by the fsck init script)
12. On the command line: exec /sbin/init (to spawn init in it’s default runlevel and resume the boot)
13. If steps 11 or 12 above fail, then run on the command line “sync” and reboot or power cycle the system.

ORA-01624: log 73 needed for crash recovery of instance

On the primary standby side,when I tried to drop log file I got this error.
Why I need to drop this redolog file,the reason is that resized online redol log file on primary side

SQL> ALTER DATABASE CLEAR LOGFILE GROUP 73;

Database altered.

SQL> alter database drop logfile group 73;
alter database drop logfile group 73
*
ERROR at line 1:
ORA-01624: log 73 needed for crash recovery of instance pdw1k9 (thread 9)
ORA-00312: online log 73 thread 9:
‘+DATAX2KSC00/pdw1k/onlinelog/group_73.5219.849813663’

The action plan is offered from oracle support

On the primary:

1). Add online redo logs of the desirable sizes.

2). Then do a log switch and drop ORL when status is INACTIVE

3). Add SRL and drop the ones with INACTIVE status

4). On the standby follow this concise procedure to recreate standby controlfile:

>> Step By Step Guide On How To Recreate Standby Control File When Datafiles Are On ASM And Using Oracle Managed Files (Doc ID 734862.1)