Forum Stats

  • 3,875,261 Users
  • 2,266,901 Discussions
  • 7,912,129 Comments

Discussions

dblogin issue

pkakimeka
pkakimeka Member Posts: 6
edited Mar 22, 2011 3:24PM in GoldenGate
I am having trouble simply logging into my oracle 11g DB. I have tried multiple ways with the same error message:

ERROR: Failed to open data source for user GGATE.

Some of the ways I have tried were:

dblogin userid ggate, password <password>
dblogin userid [email protected]:[email protected]<SID>, password <password>
dblogin userid ggate
dblogin userid [email protected]<SID>, password <password>
dblogin userid [email protected]<SID>
dblogin sourcedb <dns>, userid [email protected]<SID>, password <password>
dblogin sourcedb <dns>, userid [email protected]<SID>

tnsping resolves my SID and I am able to log into my DB using sqlplus as ggate user.

I have 11g on Windows 64 bit machine, but I am using the 32 bit version of OGG because the 64 bit did not work.

Thanks in advance,

Edited by: 846133 on Mar 21, 2011 2:04 PM

Answers

  • stevencallan
    stevencallan Member Posts: 3,459
    Well, that is an immediate show stopper. GoldenGate has to match the architecture of the platform it is running on. See page 24 of the Oracle install guide.
    stevencallan
  • pkakimeka
    pkakimeka Member Posts: 6
    edited Mar 21, 2011 8:58PM
    Thanks Steven,

    So I downloaded the 64 bit version and executed ggsci. I got the following error:

    +"This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem."+

    I installed the version of visual c++ (2005 sp1) required with no success. This is the error I was getting earlier before I switched to the 32 bit version.

    Any suggestions? My guess is that this is a microsoft issue, but not sure.

    Edited by: 846133 on Mar 21, 2011 5:41 PM

    Edited by: 846133 on Mar 21, 2011 5:57 PM
  • stevencallan
    stevencallan Member Posts: 3,459
    So, obviously on Windows, but a few more details would help. 2003, 2008?
    stevencallan
  • pkakimeka
    pkakimeka Member Posts: 6
    Sure,

    OS:
    Microsoft Windows Server 2003 R2
    Standard x64 Edition
    Service Pack 2

    CPU:
    Intel(R) Xeon(R) CPU
    L5320 @ 1.86 GHz
    1.86 GHx, 7.75 GB of RAM
  • pkakimeka
    pkakimeka Member Posts: 6
    Figured it out.

    I had to download the specific visual c++ libraries. More specifically, vcredist_x64.exe from the following website:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=EB4EBE2D-33C0-4A47-9DD4-B9A6D7BD44DA

    Now my 64 bit version works, and I can successfully login to my oracle db.

    Thanks Steve
This discussion has been closed.