使用SSMA连接到Oracle [英] Connect to Oracle using SSMA

问题描述

希望可以为您提供帮助.我正在尝试使用SSMA for Oracle(v5.2.1259)连接到Oracle数据库.我曾尝试连接到远程数据库(Oracle 10g)和本地数据库数据库(Oracle 11g)，但都无法正常工作.

Hope you can help. I'm trying to connect to an Oracle database using SSMA for Oracle (v5.2.1259). I have tried connecting to the remote database (Oracle 10g) and to a local database database (Oracle 11g) but neither is working.

我理想地要做的是连接到远程数据库并迁移架构.我可以使用Oracle SQL Developer连接到远程数据库，但是当我尝试使用SSMA时不起作用

What I would ideally like to do is to connect to the remote database and migrate the schema over. I can connect to the remote database using Oracle SQL Developer but when I try with SSMA it doesn't work

在Oracle SQL Developer中，我使用的是用户名SYS，但我必须将Role设置为SYSDBA，这样我就可以很好地连接了.当我使用SSMA时，我使用的是以下设置:

In Oracle SQL Developer I am using Username SYS but I have to set the Role to SYSDBA and it lets me connect fine. When I'm using SSMA I am using the following settings:

Provide: Oracle Client Provider
Mode: Standard Mode
Servername: same IP address used in SQL Developer
Server Port: 1521 (same as SQL Developer)
Oracle SID: PROD (same as SQL Developer)
User name: SYS (same as SQL Developer)
Password: same as SQL Developer

但是当我尝试从SSMA连接时，出现错误消息:

But when I try to connect from SSMA I get the error:

Conection to Oracle failed
ORA-01017: invalid username/password; logon denied

我尝试设置数据库的本地副本以及与SSMA相同的服务器，再次可以与SQL Developer正常连接，但是当我尝试使用SSMA进行连接时，我会收到消息

I tried setting up a local copy of the database and the same server as SSMA, again I can connect fine with SQL Developer but when I try to connect using SSMA I get the message

Connection to Oracle failed.
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

我不知道如何使用SSMA进行连接以使SYS作为SYSDBA进行连接.

And I don't know how to connect using SSMA to have SYS connect as SYSDBA.

如果有人可以帮助，那就太好了.最好让我连接到远程服务器，但即使连接到本地服务器也可以.

If someone could help that would be great. Preferably to get me connected to the remote server but even connecting to the local one would do.

谢谢.

欢呼

亚历克斯

推荐答案

好吧，事实证明，我不允许使用SYS用户从远程计算机进行连接.我创建了一个新用户，并给用户dba特权，并且一切正常.

Ok it turns out I'm not allowed to use the SYS user to connect from a remote machine. I created a new user and gave the user dba privileges and it all worked great.

谢谢

亚历克斯

这篇关于使用SSMA连接到Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！