Results 1 to 3 of 3

Thread: ora-01092

  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: ora-01092

    I have oracle 8i installed in my machine.i have created 3 users in my database.i.e.,3 logins.
    there was no problems,but today when i opened my sql plus it shows an error named "ora-1092: oracle instance terminated disconnection forced"
    i am not using the database at present but the tester of my application is accessing my database from his machine.

    whats the problem.can anybody pls help me.the testing process is stopped now bcos of this problem.


    venkatesh.k.

  2. #2
    Join Date
    Sep 2002
    Posts
    8

    Red face

    Yoy first check that Oracle service is properly created with Oradim utility.

    Also check that environment variable "oracle_sid" is set to oracle instance (sid) name.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    There will be entry in the db alert log giving you the name of the trace file which was generated from this error. Go to the db server BDUMP directory, check the alert file for more clues.

    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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