10g Database Link DBA_DB

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

10g Database Link DBA_DB_LINKS mystery

10g Database Link DBA_DB_LINKS mystery

2006-07-03 - By Sinardy Xing

Reply: 1 2 3

Hi guys,

Can you help me with this?

SQL> select open_mode from v$database;

OPEN_MODE
-- ---- --
READ WRITE

SQL> show user
USER is "SYS"
SQL> select table_name from dictionary where table_name like '%LINK%';

TABLE_NAME
-- ---- ---- ---- ---- ---- --
USER_DB_LINKS
ALL_DB_LINKS
DBA_DB_LINKS
V$DBLINK
GV$DBLINK

SQL> select count(*) from DBA_DB_LINKS;
select count(*) from DBA_DB_LINKS
*
ERROR at line 1:
ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist

SQL> grant dba to a identified by a;

Grant succeeded.

SQL> create database link db_link_a connect to a identified by a using
'CANADA';

Database link created.

SQL> select sysdate from dual@(protected);

SYSDATE
-- ------
03-JUL-06

SQL> select count(*) from dba_db_links;
select count(*) from dba_db_links
*
ERROR at line 1:
ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist

SQL> select count(*) from all_db_links;

COUNT(*)
-- ---- --
1

SQL> select banner from v$version;

BANNER
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Why I can't query my DBA_DB_LINKS?

--
regards,

Sinardy

<div> Hi guys,</div>
<div> </div>
<div>Can you help me with this?</div>
<div> </div>
<div>
SQL> select open_mode from v$database;
OPEN_MODE -- ---- -- READ WRITE
SQL> show user USER is "SYS" SQL> select table_name
from dictionary where table_name like '%LINK%';
TABLE_NAME -- ---- ---- ---- ---- ---- -- USER_DB_LINKS ALL_DB
_LINKS DBA_DB_LINKS V$DBLINK GV$DBLINK
SQL> select count(*) from DBA_DB_LINKS; select count(*) from DBA_DB
_LINKS            
          * ERROR at line 1: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
 SQL> grant dba to a identified by a;
Grant succeeded.
SQL> create database link db_link_a connect to a identified by a using
'CANADA';
 Database link created.
SQL> select sysdate from <a href="mailto:dual@(protected)">dual@(protected)<
/a>;
SYSDATE -- ------ 03-JUL-06
SQL> select count(*) from dba_db_links; select count(*) from dba_db
_links            
          * ERROR at line 1: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist
SQL> select count(*) from all_db_links;
  COUNT(*) -- ---- --        
  1
SQL> select banner from v$version;
BANNER -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL
Release 10.2.0.1.0 - Production CORE    10.2.0.1.0 &nbsp
;    Production
 TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version
10.2.0.1.0 - Production
Why I can't query my DBA_DB_LINKS?
-- regards, Sinardy </div>