SQL & PL/SQL

Dear Sirs:
I have try to create a database linke with remote sys account on my db .
But those was were failed , could you help me to find out what problems is .
thank you very much .


Those are my testings :

1.I create database link with 'public' , but no 'as sysdba'
-----------------
SQL> create public database link rm_sys1 connect to sys identified by "sys" USING '96';

Database link created


SQL> select object_name , status from dba_objects where object_name LIKE 'RM_SYS1%';

OBJECT_NAME STATUS
-------------------------------------------------------------------------------- -------
RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM VALID

SQL> SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM ;

SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-02063: 在 line 之前, 自 RM_SYS1

=================================================
=================================================

2.I create database link with 'public' and 'as sysdba'


SQL> drop public database link RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM;

Database link dropped

SQL> create public database link rm_sys1 connect to sys identified by "sys as sysdba" USING '96';

Database link created

SQL> select object_name , status from dba_objects where object_name LIKE 'RM_SYS1%';

OBJECT_NAME STATUS
-------------------------------------------------------------------------------- -------
RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM VALID

SQL> SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM ;

SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM

ORA-01017: invalid username/password; logon denied
ORA-02063: 在 line 之前, 自 RM_SYS1


=================================================
=================================================
3.after item (2) ,I create database link without 'as sysdba'

SQL> drop public database link RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM;

Database link dropped

SQL> create database link rm_sys1 connect to sys identified by "sys as sysdba" USING '96';

Database link created

SQL> select object_name , status from dba_objects where object_name LIKE 'RM_SYS1%';

OBJECT_NAME STATUS
-------------------------------------------------------------------------------- -------
RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM VALID

SQL> SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM;

SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM

ORA-01017: invalid username/password; logon denied
ORA-02063: 在 line 之前, 自 RM_SYS1


==============================================================
4.I create database link without 'public' and 'as sysdba'

SQL> drop database link RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM;

Database link dropped

SQL> create database link rm_sys1 connect to sys identified by "sys" USING '96';

Database link created

SQL> select object_name , status from dba_objects where object_name LIKE 'RM_SYS1%';

OBJECT_NAME STATUS
-------------------------------------------------------------------------------- -------
RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM VALID

SQL> SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM;

SELECT COUNT(*) FROM DBA_OBJECTS@RM_SYS1.REGRESS.RDBMS.DEV.US.ORACLE.COM

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
ORA-02063: 在 line 之前, 自 RM_SYS1


================
thank you again