Home » SQL & PL/SQL » Client Tools » Isqlplus connection string
Isqlplus connection string [message #456189] Sat, 15 May 2010 15:46 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi i created a database test and i tried to login to it through isqlplus.
But when i tried to login as sysdba it gives me a error.I can login as sysoper by giing the connecton string as test.

What is the connection string i need to specify for logging in as sysdba?

username:sys as sysdba
password:********
connection string:test


I get a error saying incorrect format.

username:system
password:********
connection string:test


I am able to connect.



Pls clear this.Thank you

Re: Isqlplus connection string [message #456190 is a reply to message #456189] Sat, 15 May 2010 15:55 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

isqlplus is/was a one hit wonder & no longer supported.
Doing DBA activity over the web is a security breach waiting to happen.

Log directly onto DB server system
access DB via sqlplus then do your DBA work from there.

Re: Isqlplus connection string [message #456191 is a reply to message #456190] Sat, 15 May 2010 16:00 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Fine.But even in sqlplus I am facing the same problem?How to login as sys user in sqlplus?
Re: Isqlplus connection string [message #456192 is a reply to message #456190] Sat, 15 May 2010 16:14 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
or post Oracle version to 4 decimal places

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

If Windows post results from following command

SET

If *NIX post results from following command

env | sort

COPY results from above then PASTE all back here

If your OS user is a member of the OS group "dba" (default group)
then you can log into DB by doing below EXACTLY

sqlplus
/ as sysdba


I
Re: Isqlplus connection string [message #456193 is a reply to message #456192] Sat, 15 May 2010 16:28 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
My os is Windows xp sp2

Oracle version 10.2.0.1


C:\Documents and Settings\Special One>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\Special One\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=CHELSEA
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\Special One
LOGONSERVER=\\CHELSEA
NUMBER_OF_PROCESSORS=4
OS=Windows_NT
Path=G:\oracle\product\10.2.0\db_1\bin;C:\Program Files\PC Connectivity Solution
\;C:\Program Files\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOW
S;C:\WINDOWS\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=G:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;G:\oracle\prod
uct\10.2.0\db_1\perl\5.8.3\lib;G:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWi
n32-x86;G:\oracle\product\10.2.0\db_1\perl\site\5.8.3;G:\oracle\product\10.2.0\d
b_1\perl\site\5.8.3\lib;G:\oracle\product\10.2.0\db_1\sysman\admin\scripts;
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 16 Model 4 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=16
PROCESSOR_REVISION=0402
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\SPECIA~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\SPECIA~1\LOCALS~1\Temp
USERDOMAIN=CHELSEA
USERNAME=Special One
USERPROFILE=C:\Documents and Settings\Special One
windir=C:\WINDOWS


I am able to login to sqlplus using / as sysdba.



Re: Isqlplus connection string [message #456194 is a reply to message #456193] Sat, 15 May 2010 16:31 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
>I am able to login to sqlplus using / as sysdba.

so problem is now solved!

YEA!
Re: Isqlplus connection string [message #456195 is a reply to message #456194] Sat, 15 May 2010 16:38 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Actually now the problem is I am able to login as sysdba as anyuser even without specifying password.I created a ORAPWD file and set the password in it,but its not checking the password.

conn sekar as sysdba
password:asdf

connected

conn sekar as sysdba
password:aaaaaa

connected




What is the problem now.
Re: Isqlplus connection string [message #456196 is a reply to message #456195] Sat, 15 May 2010 16:47 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
>What is the problem now.
This is NOT a problem, but normal, expected & desired behavior.
Oracle is using Operating System authentication.
Any OS user in the dba group can access the DB "as sysdba"
If folks can not logon to DB server or are not in dba group, then DB is secure.
Re: Isqlplus connection string [message #456197 is a reply to message #456196] Sat, 15 May 2010 16:50 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
sekar is not a os user.I created the user in the database.
Re: Isqlplus connection string [message #456198 is a reply to message #456197] Sat, 15 May 2010 17:00 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
>sekar is not a os user.I created the user in the database.
Any OS user that is in OS "dba" group can log into any DB user (even "as sysdba") without any password!

If you log onto DB server as OS user not in "dba" group, then Oracle will require "oracle password" to access DB.

[Updated on: Sat, 15 May 2010 17:02]

Report message to a moderator

Re: Isqlplus connection string [message #456199 is a reply to message #456197] Sat, 15 May 2010 17:04 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hey pls help me

I did this
1.Login to sqlplus as SYSTEM

2.Create user sekar identified by sekar

3.Grant connect to sekar

4.exit

then

created a password file in dbs directory for the instance with a password.


Now

sqlplus 

username:sekar as sysdba
password:aaaaa
connected

username:sekar as sysdba
password:bbbbb
connected

How to make users logging in as sysdba to give the password specified in Orapwd file.


How is sekar created in sqlplus becoming a os user?What do you mean by os user in dba group?How can we find os users in dba group?

[Updated on: Sat, 15 May 2010 17:07]

Report message to a moderator

Re: Isqlplus connection string [message #456201 is a reply to message #456199] Sat, 15 May 2010 17:17 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
>What do you mean by os user in dba group?How can we find os users in dba group?

Is GOOGLE broken for you?
Windoze come with built-in HELP system. Use it!

Create a new OS user, say "tester".
logon to PC as OS user TESTER

Now repeat previously posted commands.

Your issues are STRICTLY with existing OS user & NOT with Oracle.
Re: Isqlplus connection string [message #456202 is a reply to message #456201] Sat, 15 May 2010 17:40 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Tried it and got it clear.

But now when i try to login sekar as sysdba and give password specified in pwdfile it doesnt login in says insufficient privs(after logging into os using tester).

Is my pwdfile working?I created it in dbs directory using cmd prompt orapwd file=orapw'dbname' passsword=******
Re: Isqlplus connection string [message #456206 is a reply to message #456202] Sun, 16 May 2010 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 66516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sekar must have the SYSDBA privilege/role.
You should read the documentation:
Database Administrator's Guide
Chapter 1 Overview of Administering an Oracle Database
Section Database Administrator Authentication

Regards
Michel
Re: Isqlplus connection string [message #456228 is a reply to message #456206] Sun, 16 May 2010 03:48 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
No sekar doesnot have the sysdba privilages.I can login as sysdba even with a newly created user user only with create session privilage.Is my orapwd file used?
Re: Isqlplus connection string [message #456231 is a reply to message #456228] Sun, 16 May 2010 05:11 Go to previous messageGo to next message
Michel Cadot
Messages: 66516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read the provided link and come back if you then don't understand something.

Regards
Michel
Re: Isqlplus connection string [message #456243 is a reply to message #456231] Sun, 16 May 2010 08:58 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I read it and understood that when i login as os user with dba i doesnot ask for password.

I created another os user and logged in into that.I created a user in DB and tried to login tat user as sysdba
conn sys as sysdba

password:******

create user wer identified by wer
grant create session to wer
granted
exit


conn wer as sysdba
password:*****(The password i specified in orapwd file)
insufficient privilage



What i8s this.Can i login as sysdba as some user who doesnt have sysdba privilage by giving the password specified in orapwd file..
Re: Isqlplus connection string [message #456244 is a reply to message #456243] Sun, 16 May 2010 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 26588
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#i1006740
Re: Isqlplus connection string [message #456245 is a reply to message #456243] Sun, 16 May 2010 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 66516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does "i8s" mean?

Please reread the link and the section about password file, you have NOT understand.

Regards
Michel

[Updated on: Sun, 16 May 2010 09:28]

Report message to a moderator

Re: Isqlplus connection string [message #456247 is a reply to message #456245] Sun, 16 May 2010 10:55 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thats a typo
sriram Smile
Re: Isqlplus connection string [message #456251 is a reply to message #456247] Sun, 16 May 2010 13:03 Go to previous message
Michel Cadot
Messages: 66516
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
That's the problem when it is not your native language, you can't know if it is a typo (and try to find for what) or if it is a shortcut for something. Smile

Regards
Michel
Previous Topic: Display output in sql
Next Topic: How to Login isqlplus
Goto Forum:
  


Current Time: Thu Aug 22 17:20:44 CDT 2019