安装完oracle，用PL/sql登陆不进去，报ora-12514的错误。
解决办法：
1. 打开<OracleHome>/network/admin/listener.ora文件，找到：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
加上 (SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)
(SID_NAME = ORCL)
)
后完整文件内容：
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_2)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
保存，重启监听即可
分享到：
相关推荐
(GLOBAL_DBNAME = WDS) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = WDS) ) ) 编辑 tnsnames.ora 文件，添加以下内容： # TNSNAMES.ORA Network Configuration File: 通过以上步骤，我们可以成功配置...
(ORACLE_HOME = D:\oracle\ora92) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = name.domain) (ORACLE_HOME = D:\oracle\ora92) (SID_NAME = name) ) (SID_DESC = (GLOBAL_DBNAME = OEMREP) ...
(ORACLE_HOME = D:\Oracle19c\db_home) (SID_NAME = ORCL) ) (SID_DESC= (SID_NAME = dg4odbc) (ORACLE_HOME = D:\Oracle19c\db_home) (PROGRAM = dg4odbc) ) 四、配置 tnsnames 连接描述符 1. 在 Oracle ...
(GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\oracle\product\10.2.0\db_1) (SID_NAME = ORCL) ) ``` 2. **调整`PROGRAM`的位置：** - 如果确实需要使用`PROGRAM = extproc`，建议将其放在所有`SID_DESC`的...
在SID_LIST中，我们需要添加一个SID_DESC节，用于指定数据库实例的名称、Oracle_HOME路径和其他配置信息。例如： ``` (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = F:\app\Administrator\...
- **SID_DESC**：每个SID_DESC项代表一个服务的描述信息。 - **SID_NAME**：指定实例的服务名。 - **GLOBAL_DBNAME**：全局数据库名，用于标识数据库实例。 - **ORACLE_HOME**：指定Oracle安装路径。 - **...
(GLOBAL_DBNAME = standby) (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1) (SID_NAME = standby3) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = dg2) (ORACLE_HOME = D:\...
(GLOBAL_DBNAME = test9) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = test9) ) (SID_DESC = (SID_NAME = pubs) (ORACLE_HOME = d:\Oracle\Ora92) (PROGRAM = tg4msql) ) (SID_DESC = (SID_NAME = ...
(ORACLE_HOME = /u01/app/oracle/product/12.2.0/db_1) (SID_NAME = ortest) ) ) ``` - TNS 配置： ```bash ORCL_PRI = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.43....
- `SID_DESC`：描述单个服务实例的信息，包括实例名称、Oracle安装路径以及实例程序名等。 #### 三、配置命令 - **启动监听器**：`$ lsnrctl start` - **停止监听器**：`$ lsnrctl stop` - **查看监听器状态**：`...
oracle WALLET 与SSL 配置oracle的ssl连接 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora10g.unimassystem.com... (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = ora10g) ) )
在Linux环境下配置Oracle数据库时，有时我们需要在同一台服务器上安装多个Oracle实例，并通过一个监听器进行管理。这种配置可以提高资源利用率并简化网络管理。本文将详细介绍如何在Linux下为两个Oracle实例配置一个...
(GLOBAL_DBNAME = test9) (ORACLE_HOME = d:\oracle\ora92) (SID_NAME = test9) ) (SID_DESC= (SID_NAME=pubs) (ORACLE_HOME=d:\Oracle\Ora92) (PROGRAM=tg4msql) ) (SID_DESC= (SID_NAME=northwind) ...
(ORACLE_HOME=D:\oracle\product\10.2.0\db_1) (PROGRAM=extproc) ) (SID_DESC= (SID_NAME=ET2000) (ORACLE_HOME=D:\oracle\product\10.2.0\db_1) (PROGRAM=hsodbc) ) (SID_DESC= (SID_NAME=OFSS2000) ...
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc1)(ORACLE_HOME = /u01/app/oracle/product/8.1.7)(PROGRAM = extproc)) (SID_DESC = (GLOBAL_DBNAME = cams)(ORACLE_HOME = /u01/app/oracle/...
(GLOBAL_DBNAME=rmdb) (ORACLE_HOME=E:\oracle\ora92) (SID_NAME=rmdb) ) ) ``` - **重启监听器**: 为了使配置生效，需要重启`oracleoraclehome9itnslistener`服务。 **4. 配置tnsname.ora文件** - **文件...
(GLOBAL_DBNAME = demo1) #demo1为Oracle实例名 (ORACLE_HOME = /oracle/app/product/10.1.0/db_1) (SID_NAME = demo1) )) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY...