cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-12545: Connect failed because target host or object does not exist (urgent)

Former Member
0 Kudos

Dear experts,

Am new to basis

I have a issue with starting SAP after a homogeneous system copy. am getting error on brconnect/brtools to change sapsr3 user password. 

brconnect -u system/<passwd> -f chpass -o sapsr3 -p sap;

BR0801I BRCONNECT 7.20 (31)

BR0280I BRCONNECT time stamp: 2014-09-17 23.42.25

BR0301E SQL error -12545 at location db_connect-2, SQL statement:

'CONNECT system/*******'

ORA-12545: Connect failed because target host or object does not exist

BR0310E Connect to database instance <Sid> failed

BR0280I BRCONNECT time stamp: 2014-09-17 23.42.25

BR0804I BRCONNECT terminated with errors

I have my ORACLE_HOME, LD_LIBRARY_PATH , ORACLE_SID with appropriate values.

Created ops$ users and sapuser table.

kindly help me to fix this. Thanks in advance.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello Santha,

you can also try doing this operation with "brtools". It also updates some tables respectively.

under oraSID

1-brtools

2-Choose 8Additional Functions

3-Choose 4Change password of DB user

4-Fill the user whose password will be changed (3. blank)

Also please paste the last lines of alert.log of Oracle.

Regards,

Serhat

former_member189971
Participant
0 Kudos

Dear All,

I am closing the Thread.

Cheers,

Ram

former_member182657
Active Contributor
0 Kudos

Hi,

Please share the complete log and are you using SSFS or OPS$. Also try to set default password for the schema by executing command

SQL > alter user SAPSR3 identified by sap ;

Additionally follow SAP Note 400241.

Regards,

Gaurav

former_member182657
Active Contributor
0 Kudos

Hi,

Please check for the followings:

1.Make sure listener is running

2.Recheck entries under host file

3.Re check tnsnames.ora parameters

Share the result for tnsping

Regards,

Gaurav

Former Member
0 Kudos

Hi Gaurav,

Thanks for your quick reply.

I've verified 1.listner is running,

2.application server can resolve db server name/Ip correctly.

3.I've also changed server name to IP address of db server in tnsname.ora file


Here is my R3trans -d log:

4 ETW000  [     dev trc,00000]     time 2014-09-18 00:30:07, con=0 not connected, new transaction         40  0.150649

4 ETW000  [     dev trc,00000]  -->oci_execute_stmt(#3: con=0,stp=4272748,itr=1,off=0,bat=0)              53  0.150702

4 ETW000  [     dev trc,00000]  before OCIStmtExecute(svchp=425d258, errhp=425c2b8): [dur. 0,000s]        27  0.150729

4 ETW000  [     dev trc,00000]  after  OCIStmtExecute(rpc=0): [dur. 0,001s]                             1304  0.152033

4 ETW000  [     dev trc,00000]  <--oci_execute_stmt(rc=0, iters-errors = 1-0) [dur. 0,001s]               41  0.152074

4 ETW000  [     dev trc,00000]  Got SAPSR3's password from OPS$-user                                     285  0.152359

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...                                       18  0.152377

4 ETW000  [     dev trc,00000]  Rolling back transaction                                                  22  0.152399

4 ETW000  [     dev trc,00000]  Closing user session (con=0, svc=425d258, usr=428f5e0)                   652  0.153051

4 ETW000  [     dev trc,00000]  Disconnected (con=0) from ORACLE.                                       1478  0.154529

4 ETW000  [     dev trc,00000]  Connect as 'SAPSR3' with password from table SAPUSER                      33  0.154562

4 ETW000  [     dev trc,00000]  Connecting as SAPSR3/<pwd>@SBX on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])

4 ETW000                                                                                                  24  0.154586

4 ETW000  [     dev trc,00000]  Assigning username to user session: con=0, usrhp=428f5e0                  17  0.154603

4 ETW000  [     dev trc,00000]  Assigning password to user session: con=0, usrhp=428f5e0                  41  0.154644

4 ETW000  [     dev trc,00000]  Starting user session: OCISessionBegin(con=0, usr='SAPSR3', svc=425d258, srv=4260720, usr=428f5e0)

4 ETW000                                                                                                 300  0.154944

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR               50320  0.205264

4 ETW000  [     dev trc,00000]     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017:              384  0.205648

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied

4 ETW000                                                                                                  64  0.205712

4 ETW000  [    dbsloci.,00000]  *** ERROR => CONNECT failed with sql error '1017'                         87  0.205799

4 ETW000  [     dev trc,00000]     set_ocica() -> SQL error code 1017                                     39  0.205838

4 ETW000  [     dev trc,00000]  -->oci_get_errmsg (con=0, rc=1017)                                        30  0.205868

4 ETW000  [     dev trc,00000]     OCIErrorGet -> SQL error code: 1017                                   136  0.206004

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied

4 ETW000                                                                                                  38  0.206042

4 ETW000  [     dev trc,00000]     DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB                            37  0.206079

4 ETW000  [    dblink  ,00000]  ***LOG BY2=>sql error 1017   performing CON                               82  0.206161

4 ETW000  [    dblink  ,00000]  ***LOG BY0=>ORA-01017: invalid username/password; logon denied            30  0.206191

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=41=DBSL_CMD_RELINFO_GET)                        44  0.206235

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=14=DBSL_CMD_VERSION_GET)                        26  0.206261

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=50=DBSL_CMD_GET_PATCH_INFO)                     32  0.206293

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=13=DBSL_CMD_VENDOR_NAME_GET)                    99  0.206392

4 ETW000  [     dev trc,00000]  -->DbSlControl(con=-1,cmd=52=DBSL_CMD_GET_DBLIB_VERSION)                  86  0.206478

4 ETW000  [     dev trc,00000]                 -> 'OCI_112, 11.2.0.3.0, V1, default build'                39  0.206517

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

Also please conform OS_AUTHENT_PREFIX parameter to be set in initsid.ora file. it does have this entry

Thanks a lot.

former_member206552
Active Contributor
0 Kudos

Good Morning,

Is both parameters set ?

os_authent_prefix = ops$

remote_os_authent = true (if not using SSFS)

Former Member
0 Kudos

Hi Marius,

Parameters remote_os_authent = true, remote_login_passwordfile='exclusive' are set

Thanks a lot.

former_member206552
Active Contributor
0 Kudos

are you able to sqlplus sapsr3/sap ?

did you run this for both ORA and ADM user ?

CREATE USER "OPS$SBXADM"

IDENTIFIED EXTERNALLY

DEFAULT TABLESPACE "PSAPSR3USR"

TEMPORARY TABLESPACE "PSAPTEMP"

PROFILE "DEFAULT";

GRANT ANALYZE ANY TO "OPS$SBXADM";

GRANT SELECT ANY TABLE TO "OPS$SBXADM";

GRANT UNLIMITED TABLESPACE TO "OPS$SBXADM";

GRANT "SAPDBA" TO "OPS$SBXADM";

GRANT "CONNECT" TO "OPS$SBXADM";

GRANT "RESOURCE" TO "OPS$SBXADM";

ALTER USER "OPS$SBXADM" DEFAULT ROLE ALL;

DROP TABLE OPS$SBXADM.SAPUSER;

CREATE TABLE "OPS$SBXADM".SAPUSER

(USERID VARCHAR2(256), PASSWD VARCHAR2(256));

INSERT INTO "OPS$SBXADM".SAPUSER

VALUES ('SAPSR3','sap');

former_member189971
Participant
0 Kudos

Hi Burger,

Very very thanks

I Have already implemented the steps what you have provided earlier.  And it worked.

Thanks for your Prompt response...I Just shared the solution for actual issue.

Cheers,

Rama

Reagan
Advisor
Advisor
0 Kudos

4 ETW000  [     dev trc,00000]     ORA-01017: invalid username/password; logon denied

brconnect -u / -f chpass -o SAPSR3 -p sappas

Regards

RB