Skip to Content
avatar image
Former Member

oradbuser.sql file re-run

Hi,

i need to force the SAP install to go through the file oradbuser.sql. I had a look at the logs and it seems it is trying to connect and is failing multiple times. Can anyone tell me which *_IND_ORA step in DATABASE.R3S reads this file so SAP users SAPR3 etc can be created in Oracle. At the moment nothing is created by looking at the contents of this file. alternative would be to manually execute each statement in it and substituting the variables but i find that is too risky.

Many thanks.

Mani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Oct 12, 2007 at 04:23 AM

    Hi Mani,

    Can you pls copy the log file created after running the script.

    Regards,

    Payal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2007 at 07:08 AM

    Hi MAni,

    Pl let us know what the error is to proceed further.

    However pl refer Note 573042 - Oracle Preload Actions.

    This may give you some hint.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2007 at 07:09 AM

    Hi Payal,Manas,

    here it is from the dev_dbsl file. it seems an error 12154 is always occuring when trying to connect to oracle.

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 6241 Got ORACLE_SID=<SID> from environment

    DbSl Trace: dbsloci.c 6745 Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

    DbSl Trace: dbsloci.c 5112 Logon as OPS$-user to get SAP<SID>'s password

    DbSl Trace: dbsloci.c 6538 Connecting as /@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 5158 Try to connect with default password

    DbSl Trace: dbsloci.c 6538 Connecting as SAP<SID>/<pwd>@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='SAP<SID>', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 6241 Got ORACLE_SID=<SID> from environment

    DbSl Trace: dbsloci.c 6745 Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

    DbSl Trace: dbsloci.c 5112 Logon as OPS$-user to get SAP<SID>'s password

    DbSl Trace: dbsloci.c 6538 Connecting as /@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 5158 Try to connect with default password

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 5158 Try to connect with default password

    DbSl Trace: dbsloci.c 6538 Connecting as SAP<SID>/<pwd>@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='SAP<SID>', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 6241 Got ORACLE_SID=<SID> from environment

    DbSl Trace: dbsloci.c 6745 Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

    DbSl Trace: dbsloci.c 5112 Logon as OPS$-user to get SAP<SID>'s password

    DbSl Trace: dbsloci.c 6538 Connecting as /@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    DbSl Trace: dbsloci.c 5158 Try to connect with default password

    DbSl Trace: dbsloci.c 6538 Connecting as SAP<SID>/<pwd>@<SID> on connection 0 ...

    DbSl Trace: dboci.c 2404 -->oci_logon(con_hdl=0, user='SAP<SID>', dbname='<SID>')

    DbSl Trace: dboci.c 2423 OCI-call 'olog' failed: rc = 12154

    DbSl Trace: dbsloci.c 6550 CONNECT failed with sql error '12154'

    thanks for your help.

    Mani

    Message was edited by:

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 12, 2007 at 02:43 PM

    Hi there all,

    I have gone through numerous OSS note so now I may have pin pointed a possible problem. R3trans -x gives an error 0012. possible causes are incorrectly configure OPS$-user as per 403004 note, incorrect set environment, or tnsnames.ora, listener.ora. I have a fair idea that it might be environment problem as lsnrctl works on user ora<SID>, but not in root, but although i shouldn't run R3SETUP in ora<sid> it gives the same error message as under root so i think either OPS$-user is not configure as in oradbusr.sql file or there is a problem with R3trans -x. logged in as <sid>adm and ran r3trans -x and trans.log shows similar message as mentioned above (sorry looks a bit messy :s ):

    4 ETW000 36 0.176583

    4 ETW000 [developertrace,0] Connecting as SAPTST/<pwd>@TST on connection 0 ...

    4 ETW000 35 0.176618

    4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPTST', dbname='TST')

    4 ETW000 33 0.176651

    4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1033

    4 ETW000 136250 0.312901

    4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '1033'

    4 ETW000 50 0.312951

    4 ETW000 [developertrace,0] Got ORACLE_SID=TST from environment

    4 ETW000 190 0.313141

    4 ETW000 [developertrace,0] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

    4 ETW000 38 0.313179

    4 ETW000 [developertrace,0] Logon as OPS$-user to get SAPTST's password

    4 ETW000 34 0.313213

    4 ETW000 [developertrace,0] Connecting as /@TST on connection 0 ...

    4 ETW000 32 0.313245

    4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='', dbname='TST')

    4 ETW000 33 0.313278

    4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1033

    4 ETW000 130026 0.443304

    4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '1033'

    4 ETW000 103 0.443407

    4 ETW000 [developertrace,0] Try to connect with default password

    4 ETW000 40 0.443447

    4 ETW000 [developertrace,0] Connecting as SAPTST/<pwd>@TST on connection 0 ...

    4 ETW000 36 0.443483

    4 ETW000 [developertrace,0] -->oci_logon(con_hdl=0, user='SAPTST', dbname='TST')

    4 ETW000 33 0.443516

    4 ETW000 [dboci.c ,0] *** ERROR => OCI-call 'olog' failed: rc = 1033

    4 ETW000 120395 0.563911

    4 ETW000 [dbsloci.,0] *** ERROR => CONNECT failed with sql error '1033'

    4 ETW000 50 0.563961

    4 ETW000 [dblink ,627] ***LOG BY2=>sql error 1033 performing CON

    4 ETW000 232 0.564193

    4 ETW000 [dblink ,627] ***LOG BY0=> 27 0.564220

    2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'TST'"

    Mani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      change the SAPTST password to sap.

      conn / as sysdba;

      alter user SAPTST identified as sap;

      and then logon. It should work.

      If you could logon to sqlplus, then there is no issue with the tnsname.ora ....

  • avatar image
    Former Member
    Oct 16, 2007 at 07:38 AM

    Hi All,

    Thanks for all your help, this problem seems to have been ironed out. There is a new issue that is not related to this thread so i will post a new thread. some minor issues were relating to the cntrl<SID>.dbf files being the same and minor issues with permissions on files. other issues were creating the users manually from oradbusers.sql and granting certain users rights.

    Will give you all points for all your advice. Handy advice for others in similar situation.

    Thanks once again.

    Mani

    Add comment
    10|10000 characters needed characters exceeded