-
找到tnsnames.ora文件,位置:D:\app\orcl\product\12.2.0\dbhome_1\network\admin
-
复制出数据库的描述,只需要加粗部分
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3.删掉回车换行,加上 用户名/密码(数据库描述) as sysdba as sysdba可以不写
admin/123456@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = orcl))) as sysdba