-
SQL* Plus
hi,
I am using sql*plus to connect to the database on the local machine. While i try to login as sys, what should i specify in the HOST text box.
As 9i doesn't allow me to connect as sys without specifying as sysdba.
Since the database is on the same host, i dont have any connect string....
If it is on sql plus on command prompt i can try
connect sys/password as sysdba
But on gui sql* plus how to achieve this....
Last edited by bang_dba; 04-05-2006 at 08:45 AM.
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
put the instance name in there
-
'Since the database is on the same host, i dont have any connect string....'
why dont you have a connect string?
In the sqlplus window when connecting as user sys,
for the host string, you need to put :
AS SYSDBA
thomasp
-
Thanx Davey. Instance name works.
User Name : sys
Password : password
Host String : (sid) as sysdba
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|