oracle sql developer-ora-12514 错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23501025/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
oracle sql developer- ora-12514 error
提问by user3498706
im using oracle sql developer to make my database, but now i stopped to work. it wrote this:
我使用oracle sql developer来制作我的数据库，但现在我停止工作了。它写道：
An error was encountered performing the requested operation:
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Vendor code 12514
执行请求的操作时遇到错误：
侦听器拒绝连接并出现以下错误：ORA-12514，TNS：侦听器当前不知道连接描述符中请求的服务
供应商代码 12514
i also tried to make new connection but it didnt help pls help me,i dont know what to do, i need this to do my homework
我也尝试建立新的连接，但它没有帮助请帮助我，我不知道该怎么做，我需要这个来做我的家庭作业
when i tried to change connection it wrote this:
当我尝试更改连接时，它写道：
An error was encountered performing the requested operation:
ORA-01031: insufficient privileges 01031. 00000 - "insufficient privileges" *Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login. *Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label. Vendor code 1031
执行请求的操作时遇到错误：
ORA-01031: 权限不足 01031. 00000 - “权限不足” *原因：试图在没有适当权限的情况下更改当前用户名或密码。如果在没有必要的操作系统权限的情况下尝试安装数据库，也会发生此错误。在 DBMS MAC 中配置 Trusted Oracle 时，如果在比当前登录名更高的标签上授予用户必要的权限，则可能会发生此错误。*操作：请求数据库管理员执行操作或授予所需的权限。对于受信任的 Oracle 用户，尽管授予了更高标签的适当权限，但仍收到此错误，要求数据库管理员重新授予适当标签的特权。供应商代码 1031
回答by FoggyDay
You're going to have to do some troubleshooting; Here are a couple of suggestions:
您将不得不进行一些故障排除；这里有一些建议：
回答by srinivas
The service name ,you are using should be in sid column and not in service name entry box. For example, the service name provided for you is overflow,you have to mention it in
您正在使用的服务名称应该在 sid 列中，而不是在服务名称输入框中。比如提供给你的服务名是overflow，你必须在
ex:10.171.1.24:1521:overflow
例如：10.171.1.24:1521:溢出
Sid : overflow Service : leave blank Test the connection
Sid：溢出服务：留空测试连接
回答by Nistha Pandey
Please check the services are running: OracleOraDb11g_home1TNSListener and OracleServiceORCL.
请检查服务是否正在运行：OracleOraDb11g_home1TNSListener 和 OracleServiceORCL。
