oradbuser.sql file re-run

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member204746]

try this:

stop sap if is sis started (even partially (yellow or green) with SAPMMC

then:

sqlplus "/ as sysdba"

shutdown immediate;

startup

exit;

lsnrctl stop

lsnrctl lstart

when this is done, try starting SAP again with SAPMMC.

[Former Member]

Hi Eric,

the actual SAP software i don't think has not been installed yet. At the moment I am creating the database tablesspaces that SAP needs but it is not connecting to the db. I ran sqlplus while oracle was running and issued a simple select command to get list of tables but it is giving error message 01219.

ORA-01219: database not open: queries allowed on fixed tables/views only

Cause: A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.

Action: Re-phrase the query to include only fixed objects, or open the database.

R3trans is release 4.6D and so is the SAP kernel (SAP 4.6C with 4.6D kernel)

[Former Member]

Hi Mani,

First shut down the db from sql then start it open and try.

sqlplus /nolog

conn /as sysdba;

shutdown immediate;

startup open;

Regards

[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 ....

[Former Member]

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

[Former Member]

Hi Mani,

Please check the following things.

Check whether listener service is running or not?

If yes check the tnsnames.ora in oracle_home/network/admin and check whether the entries are relevant or not.

Regards,

Payal

[Former Member]

thanks,

I will check that. lsn is running and so is the db. I have found this if it helps clarify a few things. it seems i might need some sort of link called dbsl?

ERROR 2007-10-12 08:28:11 DBDBSLTESTCONNECT_IND_ORA SyDbslConnect:100

Cannot connect to DB. rc = 256

ERROR 2007-10-12 08:28:11 DBDBSLTESTCONNECT_IND_ORA InternalInstallationDo:0

RC code form SyChildFuncWait = 255 .

ERROR 2007-10-12 08:28:11 DBDBSLTESTCONNECT_IND_ORA InternalInstallationDo:0

ERROR connect to DB via DBSL.

Message was edited by:

Mani

[Former Member]

Hi,

This reveals the following possible causes of error:

1. Use of the incorrect tnsnames.ora or sqlnet.ora

2. Incorrect or missing entries in tnsnames.ora or sqlnet.ora

3. Incorrect DBSWPATH for tp

4. Incorrect or missing DBCONFPATH for tp

5. NT: Incorrect OCI-DLLs

6. Remote connection: Incorrect entry in DBCON

7. Database passwords with "@" in the name

Check for the entries in tns.ora file.

Refer Note 443867 - ORA-12154 Collective SAP note.

Do you have access to service.sap.com/notes? Else i will paste the note here.

Regards

[Former Member]

hi,

I had a look at it last time but the results were a bit too broad and I did not want to apply an OSS note i was not sure of but this is only my second install, first one took 2 weeks.

the contents of tnsnames.ora is

1. TNSNAMES.ORA Network Configuration File: /oracle/<SID>/817_32/network/admin/tnsnames.ora

2. Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

I had a look at another tnsnames.ora file on another system and it is different with the SID name in it and oracle domain <SID>.world. I suppose i could copy this over and change it but i don't want it to upset other parts of oracle config.

[Former Member]

Hi Mani,

Am not asking you to apply oss note. I just wanted you to refer to the sap notes.

The TNS file should contain entry as under. Try it.

A sample entry for the alias C11 and default domain WORLD could be like the following, for example:

C11.WORLD =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = c11host) (PORT = 1527)

)

)

(CONNECT_DATA =

(SID = PRD)

)

)

Regards

[Former Member]

Hi,

Yes,the SID name in tnsname.ora file mgt be wrong .Please check once.

As you know in SAP the SAP SID and DB SID both are same.

Regards,

Ramarao.A

[Former Member]

Hi,

Given you points for the help given. I have copied over these files from another install and tnsping works fine now after the lsnrctl is stopped and started again but it seems its still trying to connect to the oracle database but this time its error code 1033. Oracle code description is

ORA-01033: ORACLE initialization or shutdown in progress

Cause: An attempt was made to log on while Oracle is being started up or shutdown.

Action: Wait a few minutes. Then retry the operation

I have re-tried but it still not working. error message are same as message 4 posted but error code replaced with 1033

[Former Member]

Hi Mani,

Thanks,

Pl dont be disheartened.Everything needs to be cleared up step by step and it definitely takes time.Pl hv patience.

Now pl check Note 655240 - Composite SAP note: ORA-01033

It says:

The following causes are possible:

1. The database actually is in a start or stop phase

2. Incorrect Net8 configuration

3. Standby database: BRARCHIVE call without "-m"

4. Badly synchronized startup scripts

5. Incorrect environment and registry settings

Check these.

Check for the environmental variable dbs_ora_tnsname .

Regards

[former_member204746]

ora-01033 happens on slow machines and/or if Oracle start the DB automatically which should not be done in SAP.

[Former Member]

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

[Former Member]

Hi Mani,

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

Regards,

Payal