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?

migrated from stackoverflow.com Apr 25 '11 at 19:08

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

  • 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 5:31
  • 1
    Have you checked the Oracle documentation? – darreljnz Apr 21 '11 at 7: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 – 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy