SQL Plus

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Mar 2003 09:51:56 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7036749F9@lnewton.leeds.lfs.co.uk>

Morning James,

I presume you are talking about 817 or 9i and you want to startup the shutdown system, so as a Unix user who is in the 'dba' unix group I do this :

login to unix server as the 'dba' user
then either :

        sqlplus "/ as stsdba"
or

	sqlplus /nolog
	connect / as sysdba
followed by
	startup

And then after a while you have a running system.

On Windows, which I'm not all that familiar withm you need to be a member of the ora_dba group (I think) before you can connect as sysdba.

Have fun.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: James [mailto:james_at_nothing.com]
Posted At: Monday, March 10, 2003 8:36 AM Posted To: server
Conversation: SQL Plus
Subject: SQL Plus

Hi all
How do I connect with SQL plus when the databases is shutdown. (is it possible?)
If so what login name must I use? Sys or System? Is sys also a sysdba login?
cheers
James Received on Mon Mar 10 2003 - 03:51:56 CST