Loading of SQL client library orasql10.dll failed - check Oracle config.

[former_member10630]

Hi,

I have installed ORACLE 10G and in process of installing SAP now.

During SAP installation I am getting error which is pointing to ORACLE Configuration.

C:\usr\sap\ANB\SYS\exe\uc\NTI386>brconnect -u / -c -f crsyn -o SAPSR3

BR0801I BRCONNECT 7.00 (9)

BR0999E Loading of SQL client library orasql10.dll failed - please check Oracle

configuration

BR0310E Connect to database instance ANB failed

BR0280I BRCONNECT time stamp: 2009-05-28 10.12.16

BR0804I BRCONNECT terminated with errors

Do you have any idea why is this error occured? this error occur for any BR tool commands.

Just for your information my oracle setting looks like this :-

1) Set LOCAL=

2) Set ORACLE_HOME=C:\oracle\ANB\

3) Set ORACLE_SID=ANB

Set SAPDATA_HOME=C:\oracle\ANB\

4) Port number mentioned in listener.ora and tnsnames.ora is same(ex: 1521)

5) Listener service is on

6) Oracle parameters from Registry file HKEY_LOCAL_MACHINE->SOFTWARE->Oracle-> KeyANB101 is correct

7) Command "lsnrctl stat" is giving correct output

😎 I have logged in with my personal admin user but I have made sure my admin user id part of group ORA_DBA, ORA_<SID>_DBA, ORA_<SID>_OPER

😎 I am able to connect to Oracle via SQL

C:\usr\sap\ANB\SYS\exe\uc\NTI386>sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production on Thu May 28 10:19:20 2009

Copyright u00A9 1982, 2004, Oracle. All rights reserved.

Enter user-name: / as sysdba

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL>

Please let me know if their is anyway to resolve this BRCONNECT issue.

Thanks,

Regards,

Ankit Baphna

[Former Member · Accepted solution]

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> 

I dont think this version is supported. Check http://service.sap.com/pam and note sapnote #1137346

Secondly, try to shutdown first and then startup as your oracle is already started.

[former_member10630 · Accepted solution]

I will upgrade to 10.2

Closing this topic.

Thanks for your time and help.

Regards,

Ankit Baphna