Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Apr 25 '11 at 19:08

This question came from our site for professional and enthusiast programmers.

please fix your Accept rate – V4Vendetta Apr 21 '11 at 4:33
You'd be better off on serverfault or 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 5:31
Have you checked the Oracle documentation? – darreljnz Apr 21 '11 at 7:14
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 – Alex Poole Apr 21 '11 at 7:28

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.