martes, 25 de enero de 2011

ERROR: Failed to open data source for user OGGUSER en Oracle Golden Gate Version 11.1.1.0.0

Cuando se este realizando labores de configuración con el producto OGG y recibes el error "ERROR: Failed to open data source for user OGGUSER", el mismo se debe a problemas con la clave - password- del usuario con el cuál deseas conectarte a la base de datos.

Ejemplo, con conexión a Oracle 10gR2 y Oracle 11gR2

[oracle@rac1 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x86, 32bit (optimized), Oracle 10 on Jul 28 2010 13:24:18
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac1.lab.com) 1> dblogin userid ogguser, password oracle

ERROR: Failed to open data source for user OGGUSER.

[oracle@rac1 ogg]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 25 16:35:28 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.

SQL> alter user ogguser identified by ogg;
User altered.
SQL>exit

Disconnected from Oracle Database 10g Release 10.2.0.1.0 - Production

[oracle@rac1 ogg]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x86, 32bit (optimized), Oracle 10 on Jul 28 2010 13:24:18
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (rac1.lab.com) 2> dblogin userid ogguser, password ogg

Successfully logged into database.

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac2 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x86, 32bit (optimized), Oracle 11 on Jul 28 2010 13:22:25

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

GGSCI (rac2.lab.com) 1> dblogin userid ogguser, password oracle
ERROR: Failed to open data source for user OGGUSER.

GGSCI (rac2.lab.com) 2> exit
[oracle@rac2 ogg]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 25 16:35:33 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter user ogguser identified by ogg;

User altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac2 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Linux, x86, 32bit (optimized), Oracle 11 on Jul 28 2010 13:22:25
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

GGSCI (rac2.lab.com) 2> dblogin userid ogguser, password ogg
Successfully logged into database.

No hay comentarios:

Publicar un comentario

Te agradezco tus comentarios. Te esperamos de vuelta.

Todos los Sábados a las 8:00PM

Optimismo para una vida Mejor

Optimismo para una vida Mejor
Noticias buenas que comentar