Tuesday, 13 December 2011

How to start Oracle on AIX...

....after shutting it down with the Enterprise Manager console and crapping yourself as you can't get it back up!

Yes, this happened to me earlier today so I thought I'd share how to start Oracle back up on AIX. It's not quite as simple as on Windows (i.e. by starting the service) but it's not too painful.

First of all, you need a sysdba user and password...which you probably have if you've shut it down via the EM console.

Next you need to run the following command...

$ sqplus /nolog
SQL> CONNECT SYS/sys_password as SYSDBA
SQL> STARTUP

...and with a bit of luck you should be in business!

No comments:

Post a Comment