Results 1 to 13 of 13
  1. #1
    Join Date
    Nov 2003
    Posts
    39

    Question Unanswered: connect sys/password@SID as sysdba doesn't work

    connect sys/password@SID as sysdba doesn't work ?
    ORA-01031 insufficient privs.. error
    same with system user account
    However
    connect sys/password as sysdba work .. without providing SID
    or just sqlplus "/as sysdba" also work

    history ,.....
    -I changed sys password using orapwd and then alter user command
    -remote_login_passwordfile exclusive


    Please help
    Thanks
    ydj

  2. #2
    Join Date
    Apr 2003
    Posts
    50
    Hi

    Change your password again with orapwd and try. you have followed the correct procedure. did you enabel remote_login_passwordfile exclusive?
    Thanks and Regards
    Ram

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    The @ command allows a user to schedule a task (OS command or batch script) that will run automatically at set times and intervals.

    1. Checked that the Task Scheduler service in the Services control
    panel of NT is logging on as a user that is part of the ORA_DBA or
    ORA_<SID>_DBA group.

    2. REMOTE_LOGIN_PASSWORDFILE is set to SHARED or EXCLUSIVE in
    the Oracle parameter file (init.ora).

    3. Verify that SQLNET.AUTHENTICATION_SERVICES=NTS is set in the
    SQLNET.ORA file


    The @ service logon account must be set in the "Scheduled Tasks" folder.

    If you're using Windows NT, do:

    1) Open up "My Computer"
    2) Open up "Scheduled Tasks"
    3) On the toolbar, click on "Advanced"
    4) Click on "AT Service Account"
    5) Choose "This Account:"
    6) Specify an NT account name and password that is part of the ORA_DBA or ORA_<SID>_DBA group


    If you're using Windows 2000, do:

    1) Open "Control Panel"
    2) Click on "Scheduled Tasks"
    3) On the toolbar, click on "Advanced"
    4) Click on "AT Service Account"
    5) Choose "This Account:"
    6) Specify a Windows 2000 account name and password that is part of the ORA_DBA or ORA_<SID>_DBA group

    The script should now run when called via the AT command.
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Posts
    39
    Thanks Sathish & RK
    it's solaris 2.9 OS and 9i db
    i tried same thing but no luck yet

    Has it anything to do with sqlnet.ora like in pre-8i?

  5. #5
    Join Date
    Oct 2003
    Posts
    12
    when you do xxx/yyy@zzz, it will look at your oracle networking portion. zzz should be defined in your network parameters. It is clear?

    If you have direct access to the physical machine, you should be able to say xxx/yyy as sysdba and it should work.

    @zzz is not a SID it's your networking parameter. Defined in:

    \oracle\oraXX\network\admin


    Check your tnsnames.ora, listener.ora and sqlnet.ora
    Last edited by Seraph; 11-20-03 at 13:49.

  6. #6
    Join Date
    Nov 2003
    Posts
    39
    listener/tnsnames are ok. here is the sample screen output.
    there is no sqlnet.ora...

    % tnsping LIVEDB
    TNS Ping Utility for Solaris: Version 9.2.0.3.0 - Production on 20-NOV-2003 10:19:25
    Copyright (c) 1997 Oracle Corporation. All rights reserved.
    Used parameter files:
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = liverpol)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = LIVEDB)))
    OK (10 msec)
    %
    % sqlplus system/password@LIVEDB

    SQL*Plus: Release 9.2.0.3.0 - Production on Thu Nov 20 10:14:43 2003
    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production
    SQL>
    SQL> connect sys/password1 as sysdba
    Connected.
    SQL> connect sys/password1@LIVEDB as sysdba
    ERROR:
    ORA-01031: insufficient privileges
    Warning: You are no longer connected to ORACLE.
    SQL> connect system/password@LIVEDB
    Connected.
    SQL> connect sys/password1@LIVEDB
    ERROR:
    ORA-28009: connection to sys should be as sysdba or sysoper
    Warning: You are no longer connected to ORACLE.
    SQL>
    SQL> connect some_user/some_user@LIVEDB
    Connected.
    SQL>

    thanks

  7. #7
    Join Date
    Nov 2003
    Posts
    39

    Talking

    it worked.
    i just restarted database after orapwd
    thanks

  8. #8
    Join Date
    Feb 2009
    Posts
    3

    Question problem with sys account

    Hi,

    I can log in SQL Plus with user: system and the password set for it. but with sys, i can't.
    if i connect in Sql Plus with system, then i disconnect with disconnect command, and then i write conn, it askes me for a username and password. ok, i enter sys as sysdba, and the password. the problem is that if i enter any password, it tells me that Connected. even if i enter a wrong password. so these are the problem, regarding to sys account. because like this, anyone can connect with sys account, and any password, and this should not be happen..
    more clearly, here: http://img179.imageshack.us/my.php?image=51412841.jpg
    i connected initially with system account, and the password for it. then disconnect, and then tried to connect with sys, and i specified a wrong password, rass. but even though this wrong password, it tells me Conected (Conectat is in romanian). this thing isn't clear for me. like this, anyone can log in with system account, specifying a wrong password, and dropping tables, etc.. and i should mention that i changed the password os sys and system account, to another ones..
    don't know why happens this in SQL Plus, and don't know exactly what to do..

    Thanks

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >don't know why happens this in SQL Plus,
    Oracle is using Operating System authentication & therefore ignores password
    >and don't know exactly what to do..
    Do Nothing. This is normal & expected behavior.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Feb 2009
    Posts
    3
    Quote Originally Posted by anacedent
    >don't know why happens this in SQL Plus,
    Oracle is using Operating System authentication & therefore ignores password
    >and don't know exactly what to do..
    Do Nothing. This is normal & expected behavior.
    ok, do nothing, but in this way, anyone can log in sql plus with sys account and any password, no matter it's correct or not. and he's gonna to drop tables, databases, etc.. so is it normal? where is the security? why people cannot log with sys account, just with the correct password? in Oracle Enterprise manager everything goes ok, sys, with the correct password, and as SYSDBA. it didn't work with other passwords.. but in sql plus yes, and i think it's a security problem..
    Oracle ignores password? then how can i connect with sys ans system, JUST IF i specify a password?

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >where is the security?
    In some/many/most locations, ordinary user do not have ability to log directly onto the DB server as the owner of the Oracle s/w.

    What Operating System (OS) name & version?
    What version of Oracle to 4 decimal places?
    What OS username are YOU using to invoke sqlplus?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Feb 2009
    Posts
    3
    Quote Originally Posted by anacedent
    >where is the security?
    In some/many/most locations, ordinary user do not have ability to log directly onto the DB server as the owner of the Oracle s/w.

    What Operating System (OS) name & version?
    What version of Oracle to 4 decimal places?
    What OS username are YOU using to invoke sqlplus?
    i have Oracle 10.2.0.1.0 Database
    I have Windows XP SP3 ver. 5.1.2600
    but the client doesn't have SQL Plus, so the client isn't able to log in with sys account?

  13. #13
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    WIN: Checklist for Resolving CONNECT AS SYSDBA Issues
    METALINK Doc ID: 114384.1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •