Skip to main content
Database Administrators

Return to Revisions

1 of 6
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12

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

I do have a serious problem with SSMS 18.4(MSSQL) and Oracle Server(12 C), How could I use "Linked Server" from SSMS IDE to connect Oracle server.

PS:

  1. How to set roles "SYSDBA"
  2. Please do me a favor to give me any slight clue, thanks.

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

Willie Cheng
  • 271
  • 1
  • 3
  • 12