Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com 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 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 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

1 Answer 1

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.