最近开发环境的oracle数据库经常ORA-12541: TNS:no listener error错误,让人很头疼。
LSNRCTL> tatus Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS:...refused Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)) start TNS-12541: TNS:no listener TNS-12560...TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/ora10g/product/10.2.0...LSNRCTL> status Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=oel.oracle.com)(PORT=1521)) TNS-12541: TNS...TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/ora10g/product/10.2.0
OracleServiceORCL服务 1.首先查看oracle12c监听服务是否启动 2. ping 本地id是否能ping通 3.检测配置监听是否有错误: 找到 Oracle 监听配置文件(listener.ora...)和TNS配置文件(tnsnames.ora) 我的安装路径是E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN LISTENER = (DESCRIPTION_LIST...192.168.1.139)(PORT = 1521)) ) ) 4.重新配置监听器Net Configuration Assistant 具体配置参考【oracle常见错误】oracle监听程序配置/“ORA...-12541: TNS: 无监听程序” - yxtic - 博客园 5.之后重启OracleServiceORCL服务 基本情况就以上几种 我也踩过一次坑 所以就记录下来了
Oracle启动监听报错,提示 连接中断 [oracle@localhost ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.1.0 - Production...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS...to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS.../listener.ora Log messages written to /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml Listening...Authentication SNMP OFF Listener Parameter File /opt/oracle/11g/network/admin/listener.ora
在 Linux下启动Oracle服务需要下面两步: 启动lsnrctl监听。 启动数据库实例。...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=wl1)(PORT=1521))) TNS-12541: TNS:no listener...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) TNS-12541: TNS:no listener TNS.../12.2.0/dbhome_1/network/admin/listener.ora Log messages written to /home/oracle/app/oracle/diag/tnslsnr...OFF Listener Parameter File /home/oracle/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
LSNRCTL for Linux...oracle@test ~]$ lsnrctl stop listener_demo92 LSNRCTL for Linux...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521))) TNS-12541...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) TNS-12541...配置listener.ora中ADMIN_RESTRICTIONS参数 参数作用: 当在listener.ora文件中设置了ADMIN_RESTRICTIONS参数后,在监听器运行时,
1.问题描述 在linux服务器centos7上新安装的oracle 19c,结果发现客户端怎么都连不上。...现在对这个问题进行修改: 2.修改listener.ora 文件 首先要修改listener.ora 文件。...3.修改tnsnames.ora 同理,tnsnames.ora文件也需要修改: # tnsnames.ora Network Configuration File: /opt/oracle/product...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.161.120)(PORT=1521))) TNS-12541: TNS:
杨大师(http://space.itpub.net/4227/viewspace-663069)介绍过TWO_TASK环境变量的作用,指出“在Unix和Linux环境下,可以设置TWO_TASK环境变量...bisal的监听: LSNRCTL> stop bisal 验证监听状态: [oracle@liu Desktop]$ tnsping bisal TNS Ping Utility for Linux...(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bisal))) TNS-12541...ERROR: ORA-12541: TNS:no listener Enter user-name: 打开监听,再用@bisal的方式连接bisal本地库: [oracle@liu Desktop...6、补充:tnsnames.ora文件默认采用的路径如下: $HOME(~)/.tnsnames.ora $TNS_ADMIN/tnsnames.ora /var/opt/oracle/tnsnames.ora
处理 1.登陆到oracle数据库服务器 [root@lzdk ~]# su - oracle 2.查看监听状态 [oracle@lzdk ~]$ lsnrctl status LSNRCTL for Linux...Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.91.116)(PORT=1521))) TNS-12541: TNS:no.../dbhome_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/lzdk/listener...ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter...user-name: 5.发现报错ORA-12514,尝试重启数据库 6.连接数据库 [oracle@lzdk ~]$ sqlplus /nolog SQL> connect / as sysdba
1、ORA-12560:TNS:协议适配器错误 OracleService服务没有启动 2、 ORA-12541:TNS:无监听程序 OracleTNSListener...服务没有启动 3、ORA-12514:TNS:监听程序当前无法识别连接描述符中请求的服务 一般出现在TNSListener刚刚启动之后。
owner='TEST' and job_name='LOAD_PEIPING' and rownum<10 1662118 02-MAR-16 02.00.00.512815 AM +08:00 ORA...-12541: TNS:no listener ORA-06512: at line 2 1661601 01-MAR-16 02.00.00.416300 AM +08:00 ORA-12541...: TNS:no listener 信息显示在最近两天JOB确实都执行了,但是抛出了ORA-12541的错误,相关联的一个错误是TNS的错误。...(HOST = 10.127.xxxxx)(PORT = 1529))) (CONNECT_DATA = (SERVICE_NAME = gcdb)(server=dedicated))) TNS-12541...: TNS:no listener ORA-06512: at line 2 明白了这一点之后,问题的分析就很顺畅了。
当我们更换ip地址时,会遇到这样的报错,这是由于ip地址改变引起的“ORA-12541:TNS:无监听程序”错误。...我们在WINDOWS.X64_193000_db_home\network\admin\tnsnames.ora中修改其中你改变了的IP地址图片完了之后重启Oracle监听服务。
2015-09-15 22:06:19.0 Log Transport ServicesErrorError 12541 received logging on to the standby 2015-...Error is 12541. 看样子是心跳的检测失败了,看来主库和备库之间的网络可能出现了延迟之类的问题,在最大性能模式下,这个还是能够接受的,当时就没有在意。...lsnrctl start listener LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 14-SEP-2015 23:27:38 Copyright...TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact Linux...通过这个案例可以看出,对于dg中的警告信息也不要掉以轻心,很可能一个不经意的ora错误其实已经在警示重大的问题,如果及时关注,就为我们保证数据的安全提供了最快的补救措施。
1中的spf_init.ora文件路径 STARTUP PFILE = /u01/oracle/dbs/spf_init.ora 参考连接: http://docs.oracle.com/cd/E11882...e25494/start.htm#CIHDFJGC SPFILE默认文件名和缺省位置 Platform SPFILE Default Name SPFILE Default Location UNIX and Linux...PFILE的缺省文件名和文件位置: 平台 Default Name 默认位置 UNIX、Linux initORACLE_SID.ora 例如,如数据库实例名为mynewdb,则PFILE文件名为:initmynewdb.ora...ORACLE_HOME/dbs Windows initORACLE_SID.ora ORACLE_HOME\database 注:实际测试发现,linux下默认PFILE文件名为init.ora.../create.htm#ADMIN12541
马上登录到服务器里查看监听状态,发现有TNS-12541 ,TNS-12560等错误 手动把监听服务启动,这时候服务状态上显示为已启动,但在CMD窗口执行lsnrctl status的时候依然返回错误信息...正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=john-PC)(PORT= TNS-12541: TNS: 无监听程序 TNS-12560: TNS:...三、解决方案步骤 **网上有个解决TNS-12535错误的案例,平台和版本都很类似,如下: 1、在 sqlnet.ora文件中 增加如下行: DIAG_ADR_ENABLED = OFF 2、在listener.ora
My listener.ora file is below and my OS is XP Pro 2002 Service Pack 2....-dw # listener.ora Network Configuration File: C:\oracle\10.1.0\Db_1\network\admin\listener.ora # Generated
/bin/bash dbstats=`ps -ef | grep ora_smon | grep -v grep | wc -l` dgstats=`ps -ef | grep ora_mrp | grep...和ora_mrp进程的监控,判断哪种场景下该关闭keepalived服务: 场景1:当不存在ora_smon进程时(数据库实例Crash); 场景2:存在ora_smon进程同时存在ora_mrp进程时...会报一个没有监听(ORA-12541: TNS:no listener)的错误。 那这里的环境,同样是VIP的设置,为何却可以通过VIP(192.168.1.131)连接呢?...# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora...-12541: TNS:no listener)。
ORA-01017: invalid username/password; logon denied解决办法 环境介绍:操作系统RHEL6.4 X64、数据库:ORACLE 11.2.0.4.0;在现有环境下手动创建数据库...oinstall 1544 Jul 11 19:07 hc_test11g.dat -rw-r–r– 1 oracle oinstall 950 Jul 8 10:29 inito11glen.ora.bak...-rw-r–r– 1 oracle oinstall 2851 May 15 2009 init.ora.org -rw-r–r– 1 oracle oinstall 578 Jul 8 18...:22 inittest11g.ora -rw-r—– 1 oracle oinstall 24 Jul 11 18:18 lkTEST11G -rw-r—– 1 oracle oinstall...:01 orapwdtest11g -rw-r—– 1 oracle oinstall 3584 Jul 8 17:29 orapwdtest11g.org #在此发现密码文件有问题,密码文件的在LINUX
ERROR: ORA-12541: TNS:no listener Enter user-name: #查看监听,确认的确只有scan ip和节点2的ip和vip被监听;节点1的vip的确是没有被监听...00:00:00 grep tns [root@jyrac2 ~]# su - grid [grid@jyrac2 ~]$ lsnrctl status LISTENER LSNRCTL for Linux...LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux...The command completed successfully [grid@jyrac2 ~]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux:...-------------------- Alias LISTENER_SCAN1 Version TNSLSNR for Linux
- test_dg Protection Mode: MaxPerformance Databases: test - Primary database Error: ORA...redo transport error for one or more databases stest1 - Physical standby database Warning: ORA...- test Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): test Error: ORA...Error 12541 received logging on to the standby Check whether the listener is up and running....FAL[client, USER]: Error 12541 connecting to test for fetching gap sequence Wed Nov 18 18:02:36 2015
领取专属 10元无门槛券
手把手带您无忧上云