除非 DBA，否则无法连接 oracle
我刚刚创建了一个新用户，它确实创建了会话，但每次我尝试连接 PLSQL Developer 时，我都会收到 ORA-00604、ORA-01722 和 ORA-06512
但是，如果我授予 DBA 访问权限，我可以毫无问题地登录。
提示？ 我没有任何连接触发器。
I just created a new user, it DOES have create session, but everytime i try to connect on PLSQL Developer I get ORA-00604, ORA-01722 and ORA-06512
However, if i grant DBA access, i can log on with no problems.
Hints?
I don't have any connection trigger.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
ORA-01722 是 INVALID_NUMBER
也许 PL/SQL 开发人员正在尝试在连接上执行某些操作。
如果您绝对确定不存在连接触发器（并查找数据库一级），则为该模式创建一个启用跟踪的触发器。然后在跟踪文件中查找 1722 错误并查看它尝试执行的语句。
ORA-01722 is INVALID_NUMBER
Maybe PL/SQL developer is trying to execute something on connection.
If you are absolutely doubly sure that there isn't a connection trigger (and look for a database level one), then create one for that schema that enables a trace. Then look in the trace file for the 1722 error and see what statement it is trying to execute.
ORA-01722 指示某些代码抛出 INVALID_NUMBER 异常。
以 DBA 身份连接并查看 DBA_TRIGGERS。是否有 AFTER LOGON 触发器？如果是这样，请查看触发器主体中的代码。是否有任何东西正在执行 TO_NUMBER() 转换；请记住考虑隐式转换（将非数字值插入数字列等）。
普通用户会因 LOGON 触发器中的错误而受阻，但 DBA 可以免费使用。否则，谁能够连接到数据库并解决问题？
ORA-01722 indicates some code is hurling an INVALID_NUMBER exception.
Connect as a DBA and have a look in DBA_TRIGGERS. Is there an AFTER LOGON trigger? If so, look at the code in the trigger body. Is there anything which is doing a TO_NUMBER() conversion; remember to consider implicit conversion (inserting a non-numeric value into a numeric column, etc).
Regular users are stymied by errors in LOGON triggers but DBAs get a free pass. Otherwise, who would be able to connect to the database and fix the problem?
ORA-00604：如果您运行的是 11g，请检查此链接。 11g 显然有几个问题可能会导致意外弹出 ORA-00604 错误。
分享并享受。
ORA-00604 : If you're running 11g check this link. There are apparently several issues with 11g that can cause ORA-00604 errors to pop up unexpectedly.
Share and enjoy.