DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Alert 68: Oracle Security Update ... and its problems

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97

    Cool Alert 68: Oracle Security Update ... and its problems

    Hello,

    the OS is Linux Red Hat 8.0
    the DB is Oracle 9.2.0.5 (since yesterday)

    now I want to apply the Oracle security patch:

    -------------------------------------
    cd 3835964/files/Apache

    ./patch.csh -m sysobjects -p change_on_install -o /opt/oracle/product/92 -c test

    Error: DB connection failed using sys/*****@test

    -------------------------------------

    the connect with:
    oracle> sqlplus /nolog
    SQL> conn sys/******@test as sysdba
    is working.


    could you imagine what the reason is ?

    Christian
    Last edited by ckiltz; 01-12-2005 at 10:48 AM.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The reason is very obvious: in 9i and above it is no longer possible to connect as SYS without using "AS SYSDBA" option.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    ... now I try an another path ...

    I changed as "oracle" in the directory where the unziped patch is and started the following:

    oracle> pwd
    .../unziped/
    oracle> ll
    3835964

    oracle> opatch apply -report

    ... and got the following error:

    The patch directory area must be a number.

    Could any body help?

    Christian

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by ckiltz
    ... now I try an another path ...

    I changed as "oracle" in the directory where the unziped patch is and started the following:

    oracle> pwd
    .../unziped/
    oracle> ll
    3835964

    oracle> opatch apply -report

    ... and got the following error:

    The patch directory area must be a number.

    Could any body help?

    Christian
    why bother with that optach crap, is not 92060 available to you which has the security patch bundled in it
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by ckiltz
    ... now I try an another path ...

    I changed as "oracle" in the directory where the unziped patch is and started the following:

    oracle> pwd
    .../unziped/
    oracle> ll
    3835964

    oracle> opatch apply -report

    ... and got the following error:

    The patch directory area must be a number.

    Could any body help?

    Christian
    you have to cd into that directory

  6. #6
    Join Date
    Jul 2002
    Posts
    335
    Doesn't this opatch come with a readme?!??

  7. #7
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    Originally posted by stmontgo
    why bother with that optach crap, is not 92060 available to you which has the security patch bundled in it
    I searched for that patch number at meta link but I dit not found it... Is that the right number?

    christian

  8. #8
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    Originally posted by bazza
    Doesn't this opatch come with a readme?!??
    it comes but it does not help me in that case.

  9. #9
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    Originally posted by davey23uk
    you have to cd into that directory
    sorry, I was in that directory. the directory I "saw" was: 3835964

    christian

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by ckiltz
    sorry, I was in that directory. the directory I "saw" was: 3835964

    christian
    yes you have to cd into that directory as I said cd 3835964

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