 urgent... password problem for oracle 10g on linux [message #117049] |
Sun, 24 April 2005 00:47  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I am new at oracle 10g on linux o/s
My problem is that without giving password i can connect to my database as sysdba. I want that only one password for sysdba ... i can ceate password file but when i create password file then also my problem is not solved as i can connect to database as sysdba without giving password .. i dont know what to do ....help me please ..any one
========
Note :-
========
[1] I am working on oracle 10g on linux
[2] I am creating password file after shuting down my oracle 10g database.
[3]I was not able to find this paramete SQLNET.AUTHENTICATION_SERVICES. in my sqlnet.ora in oracle 10g
[4]Below is my files content of sqlnet.ora which is located at /home/oracle/product/10.1.0/Db/network/admin/sqlnet.ora
# sqlnet.ora Network Configuration File: /home/oracle/product/10.1.0/Db/network/
admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
From
Sunil
|
|
|
|
| Re: urgent... password problem for oracle 10g on linux [message #117075 is a reply to message #117049] |
Sun, 24 April 2005 10:21  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
For using password file authentication, try setting the initialization parameter REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE or SHARED
Also, do check the connect string you are giving. Right now, you must be giving
"connect / as sysdba". This uses OS authentication.
Try giving "connect sys as sysdba", then it will ask for the password.
Regds
Girish
|
|
|
|
| Re: urgent... password problem for oracle 10g on linux... mahesh frank martin [message #117121 is a reply to message #117075] |
Mon, 25 April 2005 05:02 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
thanks for your reply by the way ... my authentication is not os authentication on my database ...
i know in init.ora
REMOTE_LOGIN_PASSWORDFILE=NONE
Now to connect to DB
SQL > CONNECT / AS SYSDBA;
NONE : Password file not to be used for authentication
• If value is none , than you cant grant the sysdba to user
• If value is none , than user/dba will be authenticated by OS authentication
but girish my actual problem is that .... i m connecting to the database by
sql>connect sys as sysdba
password: <--- here i just press enter i m able to connect to the database
now tell me what shud i do ....
From :- sunil
|
|
|
|
|
|
| Re: urgent... password problem for oracle 10g on linux... mahesh frank martin [message #117172 is a reply to message #117144] |
Mon, 25 April 2005 10:23 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Is it so that i am on server on which database is present so i m able to connect without giving password ...?
sql>connect sys as sysdba
password: <--- i press enter without giving password and i m connected.
Girish i know i m not doing O/S authentication.. any way thanks for giving me your precious thought and time on my question i mean it .
i can set one password for sys on on win 2000 server for oracle 9i database.. by that only sys will be able to connect... i have doen this with help of mahesh ... but i am trying same thing on linux Red hat enterprise edition 3.0 and oracle 10g and not able to do....i m new to oracle 10g as well as linux...
From :- sunil
|
|
|
|
| Re: urgent... password problem for oracle 10g on linux... mahesh frank martin [message #117272 is a reply to message #117172] |
Tue, 26 April 2005 03:38 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi ,,
Every one, On server i can connect without giving password but from remote pc and pc which r on local network i m not able to connect as it is. I have to give password to connect as sysdba... so i think that as i am on server where database physically resides so i am able to connect without giving password....
I am Sorry for wasting your time on this issue .... i mean it ...
Any way thank you very much
from sunil
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
