0

I'm not an Oracle DBA, but now must install a instance. I use sqlplus to login but all commands return '2'

Why is this so?

  • 3
    You'd be better off on serverfault or dba.stackexchange.com. If you have the database software installed and are logged into the server as the oracle user, the "dbca" command should get you started. – Gary Apr 21 '11 at 05:31
  • 1
    Have you checked the Oracle documentation? – darreljnz Apr 21 '11 at 07:14
  • 4
    Are you actually submitting the command - terminating with a `;`, or putting a `/` on the second line? It sounds like SQL*Plus is just waiting for the second line of the command to be entered. But as @darreljnz says, read the [documentation](http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/qstart.htm) – Alex Poole Apr 21 '11 at 07:28

1 Answers1

0

First look here Oracle® Database 2 Day DBA 11g Release 2 (11.2), in the Oracle documentation.

If the only thing you want is a running Oracle Instance, create an init.ora file, with minimum parameters and from sqlplus issue startup pfile=/your/pfile/x.ora If the instance is running you can create a database, where the data is stored in datafiles. In Oracle, an instance is just a collection of processes that serves as an interface to the database files.