DBLOGIN ERROR: Failed to open data source for user OGG.
[oracle@ora10gr2 11.1]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 1 20:52:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> grant dba to ogg;
Grant succeeded.
SQL> conn ogg/ogg
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@ora10gr2 11.1]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> dblogin userid ogg,password ogg;
ERROR: Failed to open data source for user OGG.
GGSCI (ora10gr2) 2> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.
--解決方案
[oracle@ora10gr2 11.1]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.
GGSCI (ora10gr2) 2> DBLOGIN USERID ogg
Password:
Successfully logged into database.
GGSCI (ora10gr2) 3>
其實,在密碼後邊不加分號 ‘;’ 就可以
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 1 20:52:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> grant dba to ogg;
Grant succeeded.
SQL> conn ogg/ogg
Connected.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@ora10gr2 11.1]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> dblogin userid ogg,password ogg;
ERROR: Failed to open data source for user OGG.
GGSCI (ora10gr2) 2> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.
--解決方案
[oracle@ora10gr2 11.1]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x86, 32bit (optimized), Oracle 10g on Oct 4 2011 23:54:04
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora10gr2) 1> DBLOGIN USERID ogg,PASSWORD ogg;
ERROR: Failed to open data source for user OGG.
GGSCI (ora10gr2) 2> DBLOGIN USERID ogg
Password:
Successfully logged into database.
GGSCI (ora10gr2) 3>
其實,在密碼後邊不加分號 ‘;’ 就可以
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26143577/viewspace-752003/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [ERROR] Failed to open logErrorAI
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- maridb Error 'Operation DROP USER failed forErrorAI
- 解決 yum clean all Error rpmdb open failedErrorAI
- Viva:Open Java的Source (轉)Java
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- “no source“: Error: #5: cannot open source input file “C:\Users\xxx\AppData\Local\Temp\p4228: PermiErrorAPP
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- [Open Source] RabbitMQ 安裝與使用MQ
- [Open Source] 負載均衡之Nginx負載Nginx
- 使用JFrog Artifactory Open Source 搭建私服
- Top free and open source log management software
- A list of open source C++ librariesC++
- RAC User Equivalence Check FailedUIAI
- 【ERROR】OPatch failed with error code 73ErrorAI
- Failed to open service <OracleOraDb10g_home1TNSListener>, error 1060AIOracleError
- smplx 的 libGL error: MESA-LOADER: failed to open swrast 的解決方法ErrorAIAST
- Connection to host as user root failed.ERROR: NMO not setuid-root (Unix-only)AIErrorUI
- [Open Source] RabbitMQ 高可用叢集方案MQ
- OpenStack Open Source Cloud Needs To Pick Up The PaceCloud
- open failed: EBUSY (Device or resource busy)AIdev
- error: RPC failed; curl 18 transfer closed with outstanding read data remainingErrorRPCAIREM
- MYSQL SOURCE報錯 ERROR: ASCIIMySqlErrorASCII
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- ftp 報錯 550 Failed to open fileFTPAI
- AIX scp Failed to open devpkcs11AIdev
- [絕對原創] SAP Get User data by User ID
- OPatch failed with error code 73AIError
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- ttAdmin -Ramload Error TT0848: Recovery failed on 2 set(s) of data store filesErrorAI
- InfluxDB 2.x Open Source Time Series DatabaseUXDatabase
- Microsoft 釋出Rotor,一場Shared Source對Open Source的速度比賽 (轉)ROS
- Installation failed with message INSTALL_FAILED_USER_RESTRICTED錯誤AIREST
- Failed to load libGL.so error libGL.so: cannot open shared object file: No such file or directoryAIErrorObject
- Error: failed PB timebomb checkErrorAI
- SSRS頁面配置Postgresql data source的方法SQL
- Welcome to Open Source & Drupal Camp Shanghai 2008AI