当前位置:网站首页>The ORACLE database connection exception after restart
The ORACLE database connection exception after restart
2022-08-08 02:35:00 【CSDN Q&A】
Phenomena and background of the problem
ORACLE database connection exception: ORA-12154:TNS:listener currently does not recognize the service requested in the connect descriptor

My solution ideas and tried methods
Using the ORACLE tool Net Configuration Assistant, after reconfiguring ""Local Net Service Name Configuration"", it can be used normally
Step 1: Reconfigure






After the first step is completed, even ORACLE will report an exception: ORA-12541: TNS: No listener, proceed to the next configuration immediately
Step 2: Reconfigure






After reconfiguration, sometimes you can connect, and sometimes you need to restart the database service to connect
Start database service command:
sqlplus / as sysdba
SQL>startup
ORACLE routine has been started.
Total System Global Area 5117050880 bytes
Fixed Size 8757424 bytes
Variable Size 1207963472 bytes
Database Buffers 3892314112 bytes
Redo Buffers 8015872 bytes
Database is loaded.
The database is already open.
My desired outcome
I don't know why the computer needs to be configured again after restarting, and I don't know if there is any omission during the installation process
边栏推荐
- 杭电多校6 1010. Planar graph
- In-depth Synchronized various usage methods
- SQL提问!求帮助,急!
- 【STM32】标准库-看门狗
- 【愚公系列】2022年08月 Go教学课程 032-结构体方法继承
- 任务调度框架 Quartz 一文读懂
- find prime problem
- R 语言设某电子元件的寿命X(年)服从λ=3的指数分布,求该电子元件寿命为两年的概率。
- Detailed QML ListView
- The conceptual framework of consciousness: does our consciousness arise from attentional schemas?
猜你喜欢
随机推荐
2 Param 注解的使用规范
陈强教授《机器学习及R应用》课程 第九章作业
Docker install Redis 6.2.6
陈强教授《机器学习及R应用》课程 第十章作业
【HDLBits 刷题 7】Circuits(3)Sequential Logic---Counters
Task Scheduling Framework Quartz Read the article
机器学习实操的七个步骤
Spark基础【RDD分区和并行度】
Solve the problem of word flashback when Endnote inserts references
The sock MySQL start failure caused by lock file
ORACLE数据库重启后连接异常
leetcode 30. 串联所有单词的子串
QML ListView详解
LED驱动程序进一步优化-分层-分离
Where to open a futures account with low fees and high returns
意识的概念框架:我们的意识从注意图式产生?
新手使用 go channel 需要注意的问题
Embedded Interview Questions
R 语言设某电子元件的寿命X(年)服从λ=3的指数分布,求该电子元件寿命为两年的概率。
find prime problem







