The database can't go in the Oracle console

xiaoxiao2021-03-06  49

A few days ago, a database instance was successfully created, which can be started in SQLPLUS, but it is not possible in the management control tool. Today I tried to solve this problem, the result is still successful, the solution is as follows:

1. Modify the [OracleHome] /Network/admin/tnsnames.ora file, add a service name in it, do not write to Ctrl C and Ctrl V and then modify the relevant service name.

2, modify the [OracleHome] /Network/admin/listener.ora file, but also add a listening service name with the same method.

3, and then remove the database that is not successful before the console, select Add a database, and choose to add it from the TNSNames.ora file when adding, and select the database you just added.

4, select the added database, enter the username / password.

转载请注明原文地址:https://www.9cbs.com/read-116076.html

New Post(0)