Skip to Content
avatar image
Former Member

schema passwords change

Dear all,

I am new to oracle ,actually i am facing the database startup issues , i am unable to login config toll as well.

My system is AS JAVA system ,how can we check the databse is connected or not

1) One option through Configtoll

2)sqlplus / as sysdba

while connecting sqlplus/ as sysdba which user will use oracel databse.

I want to chnage sapsr3db schem use password also .

Please suggest and guide me

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 26, 2013 at 03:13 PM

    Hi,

    You should be able to see the password in secure store on configtool. So, you can change the database password on the editor.

    >> while connecting sqlplus/ as sysdba which user will use oracel databse.

    The user is "SYS"

    >> I want to chnage sapsr3db schem use password also .

    brconnect -c -u / -f chpass -o SAPSR3DB -p <PASSWORD>

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      >> For example I will change password through below comand it will effect secure store as well

      brconnect -c -u / -f chpass -o SAPSR3DB -p <PASSWORD>(can i run this comand directly through comand prompt or i need to navigate any path)

      No. It will not affect the secure store. "brconnect" will just change user password on the database. Then, the password must be entered into the secure store in configtool. So, the application server will use the account to connect to the database.

      >> If i will change password in secure store then no need to change through brconnect option right.

      As I noted above, you need to enter the password in secure store, too.

      >> I am facing issue while connecting salplus / as sysdba its showing Ora-0031 insufficient privleges.

      This is another issue. You mean that you are facing with the ORA-01031: insufficient privileges with the "/as sysdba"? Is it Windows or Unix based system? On Unix based system, you need to logon to the OS with "ora<sid>" user and on Windows based system "<sid>adm" user, while executing the sqlplus.

      Best regards,

      Orkun Gedik

  • avatar image
    Former Member
    Feb 27, 2013 at 12:31 AM

    1)user brtools to change the SAPSR3DB password ,

    2)and also in secstore> configtool>"change the pass" add > save > apply

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      Hi Deepak,

      as per my undestand sys password is not able to conencte sqlplus .

      I ma thinking is their any other to chnage sys password excpet sqlcomand