Thoughts

10g (1) 11c (1) 11g (5) 12c (4) 3.0 (1) ApEx (4) Cloud (11) database (10) DBA (1) EBR (1) EC2 (2) education (3) ExaData (1) F2F (1) Forms (7) java (1) language (2) memorabilia (2) Metalink vs MOS (4) multi-cultural (3) on-line communities (1) oracle (7) performance (5) projects (1) reciproke (1) Reports (2) RUP (1) sales (2) services (5) silence (1) SOA (3) SQL Server (2) standards (6) Sun (1) support (6) W8 (1) WebLogic Server (5)

Wednesday, August 26, 2009

Starting up a database Oracle 10g Windows

Did you also get a off-the-shelf installation of Oracle? Did the host crash?

And the Enterprise Manager did not succeed to get up the DB on the feet again? Well...on Windows there are two things that have to be done.
  1. Make sure that the User - on the local machine - that are running the processes is defined in the Local Security Settings.
  2. Make sure that you learn how to start up the database via DOS window.

Item 1 you can study on some Microsoft Windows page on the 'net.

Item 2, please follow these instructions:


SQLPLUS /NOLOG
SQL> connect username/password as sysdba
SQL> startup

Of course there are parameters, but the default way to start up a database are the steps above.

No comments: