| Isqlplus connection string [message #456189] |
Sat, 15 May 2010 15:46  |
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 #456193 is a reply to message #456192] |
Sat, 15 May 2010 16:28  |
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 #456195 is a reply to message #456194] |
Sat, 15 May 2010 16:38 |
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 #456198 is a reply to message #456197] |
Sat, 15 May 2010 17:00 |
 |
BlackSwan
Messages: 26766
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 |
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 #456202 is a reply to message #456201] |
Sat, 15 May 2010 17:40 |
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 #456228 is a reply to message #456206] |
Sun, 16 May 2010 03:48 |
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 #456243 is a reply to message #456231] |
Sun, 16 May 2010 08:58 |
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..
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
