Sample Header Ad - 728x90

SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)

0 votes
1 answer
1075 views
How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"? I've tried many methods as following to show you what I did right now: Oracle client connect to Oracle Server data: enter image description here SSMS connect to Oracle Server data: enter image description here enter image description here enter image description here More testing information I also use "SQLPLUS" to check *tnsnames.ora* the file is okay or not but the answer is as following 1. sqlplus SYS/Oradoc_db1@DBNAME as SYSDBA <-- is okay 2. sqlplus SYS/Oradoc_db1@DBNAME <-- Error enter image description here enter image description here
Asked by Willie Cheng (271 rep)
Apr 30, 2020, 11:36 AM
Last activity: May 5, 2020, 06:53 AM