Getting "Invalid Option for Alter Session" - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Getting "Invalid Option for Alter Session"

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Let me ask you one question, were you able to login to your orcl instance using sys and system as the user names through sqlplus. On such case your database is in a good shape. You don't have to worry much about the database ...

    What is the gurentee that blowing every thing off and starting things from the scratch would solve your problem.

    When you say that you tried to connect as system, what was you using, sqlplus/OEM?

    Comming back to square one, do you have the OEM repository configured on any oracle instace?

    Could you be more clear where you get the failure? I also need to know your working OS(es)? i.e. what is the OS the server is on and what is the OS the OEM is on and etc ...


    Looking forward to hear from you ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Aug 2001
    Location
    Virginia
    Posts
    8

    Back to this

    Hi Sam,

    Sorry to take so long... I have been working on another project and I will have to get back to this after Tuesday. Thanks for your help. right now I have blown away the DB and created a new one (It's a test machine) and haven't gotten as far as I was... so I will be back with the results on Tuesday timeframe. Thanks again, Cadence
    Cadence
    Chaos is the Reality with which we Live

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