Can't log to instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Can't log to instance

  1. #1
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82

    Question

    Well, I've shut down my database and now I can't start it again.

    I can't even connect to instance. I'm trying to do this

    c:\>sqlplus /nolog
    sql>connect internal/oracle

    Then I get error ORA-01017 invalid username/password ; logon denied

    If I try to connect as connect sys/password as sysdba
    or like connect sys/password@mydb as sysdba
    or like connect sys/password@mydb

    then I get error ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect string

    I've erased password file and recreated it again but I get the same results

    P.S. OS is WIN NT and Oracle 8.1.7

    Thank you

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    what do you have in your tnsnames.ora file ??

  3. #3
    Join Date
    Aug 2001
    Posts
    390
    try this:

    1. use SVRMGRL
    2. set your environment to the instance you want to log into
    3. CONNECT/INTERNAL
    4. if CONNECT/INTERNAL is not working which mean that your password has changed.
    5. If your password is changed and you don't know the password, change the password file at ORACLE_HOME\database\pwd.ora. what you need to do here is delete the old password and recreate the new one using ORADIM

    let us know if you still have problem

  4. #4
    Join Date
    Aug 2001
    Posts
    267
    Or else simply if you are in dba group .. Just use connect internal , It will connect you .. Ned not use password or connect string ..
    Raghu

  5. #5
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    if his prompt is :
    c:\>
    I really doubt he could be in any group since he's using NT

  6. #6
    Join Date
    Aug 2001
    Posts
    267
    I don't think so ..

    In NT we must have ora_dba group . Programs/admin tools/user manger under that you can see ora_dba group . If he had logged to nT using any account under ora_dba group,he can be connected to oracle without any password or connect string ..Usually I won't use any password or connect string .. Just connect internal ,if prompted for password just return . Now on 9i release just connect sys as sysdba ..
    Raghu

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587

    Cool

    Aljaz,
    Not trying to go off tangents follow these steps meticulously,

    1. In configuration box(my computer) /services, you must have oraclestart and oraclestart start , if not start them.

    2. start your TNSLSNR80 from services or thru cmd.exe prompt lsnrctl8x , then check status first ,if not started promt start.

    3. Test your connection to the database , thry net8 utility.
    create it if you didn't create it. Depending on how you created the instance(i prefer to use dbassistent , then custom creation helps you create you internal account...), but anyways keep all your passwords and test the connection here...
    modify your lsnr.ora, tnsnames.ora files if required.

    4. Tip:also check the registry, i prefer to have it clean from previous installations...

    5. Let us know here if this worked.

    Cheers!!!!!

    Tarun
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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