linux下命令行安装oracle 11g数据库报错解决

左手的ㄟ右手 2021-12-18 21:29 1051阅读 0赞

ORA-00205: error in identifying control file, check alert log for more info

SQL> show parameter control\_files;

NAME                               TYPE     VALUE

\------------------------------------ ----------- ------------------------------

control\_files                      string    /home/app/oracle/oradata/test/

control01.ctl, /home/app/oracl

e/fast\_recovery\_area/test/cont

rol02.ctl

[https://blog.csdn.net/u013082095/article/details/64442837][https_blog.csdn.net_u013082095_article_details_64442837]

[oracle 安装完成后遇到的问题（ORA-01507: database not mounted）][oracle _ORA-01507_ database not mounted]

[https://www.cnblogs.com/thg999/p/9981766.html][oracle _ORA-01507_ database not mounted]

解决数据库实例启动ORA-00205问题

[https://blog.csdn.net/u013082095/article/details/64442837][https_blog.csdn.net_u013082095_article_details_64442837]

1.数据库   Shutdown  时

ORA-01507: database not mounted

未编辑数据库

![2019070115572360.png][]

2.startup   时

ORA-00205: error in identifying control file, check alert log for more info

识别控制文件错误，请检查警报日志以获取更多信息

![20190701155752488.png][]

开始

1.ORA-00845: MEMORY\_TARGET not supported on this system：

[https://www.cnblogs.com/killkill/archive/2010/09/10/1823690.html][https_www.cnblogs.com_killkill_archive_2010_09_10_1823690.html]

2. ORA-00214: control file '/oradata/orcl/control02.ctl' version 884 inconsistent with file '/orad：

[https://blog.csdn.net/debimeng/article/details/79656458][https_blog.csdn.net_debimeng_article_details_79656458]

[https://blog.csdn.net/dba\_monkey/article/details/60962322][https_blog.csdn.net_dba_monkey_article_details_60962322]

3. ORA-00205错误解决：

[https://blog.51cto.com/xjsunjie/538818][https_blog.51cto.com_xjsunjie_538818]

4. ORA-32001:write to SPFILE requested but no SPFILE is in use：

[https://blog.csdn.net/songyundong1993/article/details/53307931][https_blog.csdn.net_songyundong1993_article_details_53307931]

5. ORA-01102: cannot mount database in EXCLUSIVE mode ：

[https://blog.csdn.net/linucle/article/details/8560548][https_blog.csdn.net_linucle_article_details_8560548]

6. ORA-01507: database not mounted：

[https://blog.csdn.net/qq\_27966627/article/details/51062822][https_blog.csdn.net_qq_27966627_article_details_51062822]

7. ORA-00210，ORA-00202，ORA-27086错误：

[http://www.mamicode.com/info-detail-1173983.html][http_www.mamicode.com_info-detail-1173983.html]

8.oracle11g报错 ORA-01078和LRM-00109 解决方法：

[https://blog.csdn.net/buffoon1900/article/details/51919869][https_blog.csdn.net_buffoon1900_article_details_51919869]

[https_blog.csdn.net_u013082095_article_details_64442837]: https://blog.csdn.net/u013082095/article/details/64442837
[oracle _ORA-01507_ database not mounted]: https://www.cnblogs.com/thg999/p/9981766.html
[2019070115572360.png]: /images/20211219/c4085a9ab22a47b78baf2a17da8efba1.png
[20190701155752488.png]: /images/20211219/b4a18e646fe5423ca77fccc2e7e0ff91.png
[https_www.cnblogs.com_killkill_archive_2010_09_10_1823690.html]: https://www.cnblogs.com/killkill/archive/2010/09/10/1823690.html
[https_blog.csdn.net_debimeng_article_details_79656458]: https://blog.csdn.net/debimeng/article/details/79656458
[https_blog.csdn.net_dba_monkey_article_details_60962322]: https://blog.csdn.net/dba_monkey/article/details/60962322
[https_blog.51cto.com_xjsunjie_538818]: https://blog.51cto.com/xjsunjie/538818
[https_blog.csdn.net_songyundong1993_article_details_53307931]: https://blog.csdn.net/songyundong1993/article/details/53307931
[https_blog.csdn.net_linucle_article_details_8560548]: https://blog.csdn.net/linucle/article/details/8560548
[https_blog.csdn.net_qq_27966627_article_details_51062822]: https://blog.csdn.net/qq_27966627/article/details/51062822
[http_www.mamicode.com_info-detail-1173983.html]: http://www.mamicode.com/info-detail-1173983.html
[https_blog.csdn.net_buffoon1900_article_details_51919869]: https://blog.csdn.net/buffoon1900/article/details/51919869