Results 1 to 10 of 10
  1. #1
    Join Date
    Jul 2006
    Posts
    3

    Question Unanswered: Connect as normal does not work

    I have corrected a DB and can not connect as normal - I must connect as SYSDBA. How do I fix this?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > does not work
    My car does not work. Tell me how to fix it, please.
    Do you have any idea how many different ways Oracle can fail?
    A Gazillion!

    No OS or version.
    No Oracle version to 4 decimal places.
    No cut & paste of actual inputs & outputs (error messages).
    You're On Your Own (YOYO)!
    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.

  3. #3
    Join Date
    Jul 2006
    Posts
    3
    Please stay of this thread. Find one where jerks like you belong.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Regarding the fact that you are a new member on this Forum (at least, you registered recently), I guess you don't know Anacedent's charm (yet), but - in my opinion - his last few sentences could easily be part of the Sticky thread.

    What does it mean, "I have corrected a DB"? I've never heard of such a thing. What was wrong with it? What did you do?

    What was the connect string you used to connect to the database? How are we supposed to know what you actually typed if you don't tell us?

    If you upgraded the database version (if that's what you mean by corrected), which one are you on now? Previous versions (for example, Oracle 7, Oracle 8i) didn't require "AS SYSDBA" when connecting as SYS; you could connect using

    OS> sqlplus sys/sys_password@ora8

    Recent versions, on the other hand, do require "AS SYSDBA", so you'll need something like this:

    OS> sqlplus "sys/syspassword@ora10 as sysdba"

    Once again, if you don't provide more information, it is really hard to guess what might be wrong (or perhaps everything is fine, but you don't know that this is expected Oracle behaviour).

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > his last few sentences could easily be part of the Sticky thread.
    They are now.
    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.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Lovely

    Because, I double-checked before writing the post; and no, they weren't there eearlier today.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    I thought Anacedent was a she, but I guess it doesn't matter.
    The CHARM is there regardless.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    In my opinion, if Anacedent is a She, well, she suffers from PMS more often than just once in a month (more or less)

    Just kidding!

  9. #9
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Anacedent has a very short temper and doesn't handle fools will. However, [he/she] is very knowledgable and a real asset to the forum.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  10. #10
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Sorry, Bill, that's not acceptable. You must choose: he OR she. he/she is not valid

Posting Permissions

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