2 Replies Latest reply: Feb 21, 2012 6:48 AM by Bialy RSS

    [AIX 5.3 TL12] sys user "select program from v$session" show  question mark

    User354266
      Oracle 9i
      After upgrade from AIX v5.2 to AIX v5.3 TL12 ,
      the "select program from v$session" show question mask

      original AIX 5.2 ==>"select program from v$session" , OK
      migration AIX 5.3 ML04==>"select program from v$session" , OK
      migration AIX 5.3 ML12==>"select program from v$session" , NG

      for example :
      ######################################
      on AIX 5.3 ML04 , SQL>"select program from v$session"
      PROGRAM
      --------------------------------------------------
      oracle@testdb (PMON)
      oracle@testdb (DBW0)
      sqlplus@testdb (TNS V1-V3)+

      ########################################
      on AIX 5.3 ML12 , SQL>"select program from v$session"
      PROGRAM
      --------------------------------------------------
      oracle@testdb (PMON)
      oracle@testdb (DBW0)
      *?*@testdb (TNS V1-V3)

      any one have advise if this is cause by upgrade to AIX v5.3 TL12 ?
      any solution to show NO question mask like " *?* @testdb (TNS V1-V3) " ?