Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 18, 2014 at 04:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2014 at 05:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2014 at 07:54 AM

    Dear All,

    I am closing the Thread.

    Cheers,

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2014 at 08:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded