Shulou(Shulou.com)06/01 Report--

1. Oracle 11g ORA-12514:TNS: the listener currently does not recognize the service requested in the connection descriptor

The database server crashed, and trying to restart the service and restarting the machine won't solve the problem.

Open the cmd window

C:\ Users\ hxt > sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wednesday December 5 11:39:54 2018Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle routine. The SQL > startupORACLE routine has been started. Total System Global Area 6797832192 bytesFixed Size 2188648 bytesVariable Size 3523218072 bytesDatabase Buffers 3254779904 bytesRedo Buffers 17645568 bytes database loaded. The database is already open.

2 、 Oracle 11g ORA-00119 ORA-00132

The error is as follows:

SQL > startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

Solution:

1),

SQL > create pfile from spfile='D:\ app\ hxt\ product\ 11.2.0\ dbhome_1\ database\ SPFILEORCL.ORA'

2). After the first step, find the init.ora file in the path D:\ app\ hxt\ product\ 11.2.0\ dbhome_1\ database, and change * .local _ listener='LISTENER_ORCL' to * .local _ listener=' (ADDRESS_LIST= (Address= (Protocol=tcp) (Host=localhost) (Port=1521)'

3),

SQL > create spfile from pfile='D:\ app\ hxt\ product\ 11.2.0\ dbhome_1\ database\ INITorcl.ORA'

Summary

The above is the whole content of this article. I hope the content of this article has a certain reference and learning value for everyone's study or work. Thank you for your support. If you want to know more about it, please see the relevant links below.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.