ORA-12514:TNS:listener does not currently know of service requested in connect descriptor Ora-12514
时间: 2023-10-14 12:04:37 浏览: 75
ORA-12514 is an error that occurs when the Oracle listener is not able to find the requested service in the connect descriptor provided. This error typically indicates that the service name or SID specified in the connection string is incorrect or not known by the listener.
To resolve this issue, you can try the following steps:
1. Verify the service name or SID: Double-check the service name or SID specified in the connect descriptor. Make sure it matches the service name or SID defined in the Oracle database.
2. Check listener status: Ensure that the Oracle listener is running and listening for incoming connections. You can use the following command to check the listener status:
```
lsnrctl status
```
If the listener is not running, start it using the following command:
```
lsnrctl start
```
3. Register the service: If the service name or SID is correct, but still not known by the listener, you can try registering the service manually with the following command:
```
lsnrctl services
```
This command will reload the listener configuration and make it aware of any new services.
4. Check network connectivity: Ensure that there is no network issue between the client and the Oracle server. Check if you can ping the server from the client machine and vice versa.
If none of these steps resolve the ORA-12514 error, it might be helpful to provide more information about your specific setup, such as the version of Oracle Database, operating system, and how you are connecting to the database.
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)