Skip to main content
Database Administrators

Return to Question

added 27 characters in body
Source Link
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)

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"?

I've tried many methods as following stepsto 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

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

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"?

I've tried many methods as following steps:
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

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

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

deleted 92 characters in body
Source Link
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12

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 the Oracle server database. with "SYSDBA"?

PSI've tried many methods as following steps:

  1. How to set roles to "SYSDBA"
  2. Oracle client version 11.2 / Oracle server 12C <-- is it okay or not for environment
  3. Please do me a favor to give me any slight clue, thanks.

Oracle
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

By the way I also use "SQLPLUS" to check tnsnames.ora file is okay or not but the answer is as following

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

enter image description here

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 database.

PS:

  1. How to set roles to "SYSDBA"
  2. Oracle client version 11.2 / Oracle server 12C <-- is it okay or not for environment
  3. 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

By the way I also use "SQLPLUS" to check tnsnames.ora 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

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"?

I've tried many methods as following steps:
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

Post Undeleted by Willie Cheng
Post Deleted by Willie Cheng
added 300 characters in body
Source Link
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12

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 database.

PS:

  1. How to set roles to "SYSDBA"
  2. Oracle client version 11.2 / Oracle server 12C <-- is it okay or not for environment
  3. 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

By the way I also use "SQLPLUS" to check tnsnames.ora 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

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 database.

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

By the way I also use "SQLPLUS" to check tnsnames.ora 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

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 database.

PS:

  1. How to set roles to "SYSDBA"
  2. Oracle client version 11.2 / Oracle server 12C <-- is it okay or not for environment
  3. 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

By the way I also use "SQLPLUS" to check tnsnames.ora 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
added 300 characters in body
Source Link
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12
added 9 characters in body
Source Link
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12
Source Link
Willie Cheng
Willie Cheng
  • 271
  • 1
  • 3
  • 12