Re: SQL*Plus security details needed (newbie question)

From: Brent Tucker <bxtucke_at_sp5-18>
Date: 1995/12/02
Message-ID: <49pi0l$7s4_at_cpcnews.cp.nts.uswest.com>#1/1


A couple of things you might check...

  1. Make sure you can connect in SQL*DBA with internal. Do the following:
  2. Start SQL*DBA.
  3. connect internal (in Windows, password is probably Oracle)
  4. show sga

    You should get a report of the instance variable size, fixed size, etc. If not, your database is probably not running. If the database isn't running, you will get mem shared segement errors. In this case (you are still connected as internal):

  1. startup (to start the instance)
  2. show sga (when database is open)

   BE PATIENT when the database is starting. You will get several messages (database starting, mounted, open) and when you get the SQLDBA> prompt you can enter the show sga command.

2) Now connect in SQL*DBA as scott/tiger.

  1. connect scott (password tiger

    You should get a message saying you are connected.

3) If you can connect in SQL*DBA, then you have lots of things to check:

  1. Make sure your connection string is clear in the connection dialog box when logging in to SQL*PLUS if you are on a single user (Windows) platform.
  2. Try connecting as system (password is whatever you specified during install) to make sure the scott id is ok.
  3. Check your install log. Did SQL*PLUS load OK?

Hope this helps.

Brent
bxtucke_at_cp.mnet.uswest.com Received on Sat Dec 02 1995 - 00:00:00 CET

Original text of this message