Skip to Content
avatar image
Former Member

Oracle DB is up and runninge, but SAP cannot access (Oracle Error 1034)

Hi all

I am runninge SAP 4.6B on HP UX 11.23 with an 9.2.0 Oracle DB

I did a system copy to migrate an SAP instance to another server.

After everthing is migrated, I can startup the DB in sqlplus. I can even let BRCONNECT run and the check, stats ans stats cascade.

But when trying to start SAP, it fails: startdb.log says R3trans check finished with return code: 12

R3trans -d, tells me:

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 1034 65105 0.085041

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

Has anybody any Idea about what is wrong?

Any ideas are welcome!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2010 at 06:44 AM

    Hi All

    Thanks for your help so far!

    But it did not help as the problem is completely different as I supposed:

    I found out (more per accident as per intention) that after the "copy" of the SAP instance to the new server, somehow DB settings are still pointing back to the server the SAP instance came from.

    And because I completely shut down the SAP instance on the origin server, there was no connection to the DB possible!

    Sounds logic!

    So, when I log in as SIDadm, it tries to access to origin server DB instead of the DB on the new server.... 😔

    New question is: Where did I forget to adapt some setting-file to the new server name??? What I adapted is:

    - dbenv & sapenv profiles in /usr/sap

    - the links to these profiles in /oracle/SID

    - startsap, stopsap scripts

    - DEFAULT.PFL & START-Profile of SAP instance

    - redone all necessary links on OS level (ln -s .... )

    - updated listener.ora (actually copied the entries of the old server.. might this be the problem? But I do not recognize any server dependant entries...): (ADDRESS=(PROTOCOL=IPC)(KEY=SID.world)) (ADDRESS=(PROTOCOL=IPC)(KEY=SID)) & (SID_DESC =(SDU = 4096)(SID_NAME = SCH)(ORACLE_HOME = /oracle/SID/920_64)(PRESPAWN_MAX = 10))

    What did I forget or do wrong?

    By the way: The migration was done via backup of the SAP directory with fbackup and playback of this backup with frecover on the new server.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      @Varadharajan M:

      I did not know about R3load....

      Situation is: I habe two SAP servers (both HP UX): Server s01 and s03. My SAP landscape spreads over these two servers. I want to move all SAP instances from s01 to s03, so that in the end all instances run on s03.

      And as I do not want to install SAP & Oracle using all these installation CDs & DVDs, Setup tools and Updates, I decidedt to do a migration on filesystem level.

      Might be that R3load is a alternative to using fbackup / frecover. But I do not know it.

      By the way: Productive SAP instance is already running on s03, so I will not touch that! 😉

  • avatar image
    Former Member
    Aug 13, 2010 at 08:47 AM

    Hi,

    Check your environemt variables, are they all correct ?? and pointing to where they should be.

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2010 at 06:01 AM

    Hi.

    DB is running, SAP cannot access it. So it seems to be a connection problem.

    Oracle client software is ok? Listener is running? Network setting (nslookup) also ok?

    Environment <sidadm> (already mentioned by other colleagues)

    regards, Martin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2010 at 12:59 PM

    Check the following notes:

    SAP Note 403004 - Database connect using R3trans fails

    SAP Note 400241 - Problems with ops$ or sapr3 connect to Oracle

    SAP Note 361641 - Creating OPS$ users on UNIX

    Hope this helps.

    Thanks,

    Naveed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2010 at 06:03 PM

    Hi,

    What type of migration is that? Is it homogenous or heterogenous ? Make sure that u have carried out the post migration activities.

    1. Changing the SID in the control file (If ths SID is different)

    2. Deleting and recreating the OPS$user

    By the way, can you execute R3trans -x and post the trans log ?

    Regards,

    Varadharajan M

    Add comment
    10|10000 characters needed characters exceeded