Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » Exadata

Exadata上如何重置Cell节点root密码当你忘记时

如果之前建立的有ssh对等关系,重置会非常简单。如果没有,请参考下面的步骤去重置Exadata存储节点的root密码。首先确保,cell节点关闭不会对数据库造成影响,请参考Note1188080.1/1943722.1

Pre-Step1:

login to cell node with username "celladmin" as follow :
Steps to shut down or reboot an Exadata storage cell without affecting ASM (Doc ID 1188080.1/1943722.1)
    SQL> select dg.name,a.value from v$asm_diskgroup
    dg, v$asm_attribute a where dg.group_number=a.group_number and
    a.name='disk_repair_time';
    SQL> ALTER DISKGROUP DATA SET ATTRIBUTE 'DISK_REPAIR_TIME'='48H';

    cellcli -e list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

    Note: make sure the output from above command, the asmdeactivationoutcome='Yes'


Pre-Step2:
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 remote SP console:
           reset /SYS
           start /SP/console
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>.
   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"

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)

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

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.

Remember modify the DISK_REPAIR_TIME to original value(optional)

     SQL> alter diskgroup data set attribute 'disk_repair_time'='xH';



关键词:cell root exadata 

相关文章

Exadata最权威最完整的学习资料
Exadata上收集Cell节点的日志
Exadata上如何重置Cell节点root密码当你忘记时
Oracle性能加速之Write-Back Flash Cache
Exadata and ASM
Oracle ZDLRA (Zero Data Lost Recovery Appliance) FAQ
Oracle ZDLRA (Zero Data Lost Recovery Appliance) Features
Oracle Database 18c On Exadata
Migrate Oracle Database on AIX to Exadata
ExaWatcher Charts
qperf & iperf
How to config IB network listener
Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com