DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sql Login

  1. #1
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    sql Login

    When I am logging from my windows based pc from sql> to a database on a Unix machine using the below given commands I am getting the below given error. The password I used is correct

    SQL> set time on
    12:30:25 SQL> connect sys/sysau19@utl1
    Connected.
    12:30:42 SQL> connect sys/sysau19@utl1 as sysdba
    ERROR:
    ORA-01017: invalid username/password; logon denied
    Warning: You are no longer connected to ORACLE.
    12:31:07 SQL> connect
    12:31:16 Enter user-name: sys@utl1 as sysdba
    Enter password: *******
    Connected.
    12:31:30 SQL> show user
    USER is "SYS"
    12:31:32 SQL>

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    What is the version of your Oracle server? For pre Oracle 9i, check the internal's password.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  3. #3
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    sql login

    Oracle Server is 8.0.5.2.2 and sql version is 8.1.7
    There is no password for internal since this is an operating system
    authentication. As can be seen from the output it is connecting when I give user name separately

  4. #4
    Join Date
    Dec 2001
    Location
    Hyderabad
    Posts
    17

    use quotes!

    Put the username pass etc in between quotes "" and you should be connected!!
    CHEERS!
    Venu G. (OCP 8i & 9i)

Posting Permissions

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


Click Here to Expand Forum to Full Width