idle sqlplus> startup nomount pfile='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initvihcdbd8x.ora'; ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 10 05:36:54 2025 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected. idle sqlplus> startup ; ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 [oracle@rac02 dbs]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Mon Mar 10 05:43:36 2025 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-01089: immediate shutdown or close in progress - no operations are permitted ************************************************************************************************************************************************************** Before this try below Cannot login to the Database after Changing $ORACLE_HOME Directory Permission ( ORA-01012 ) (Doc ID 2497191.1) Try below !!!!!!!!!!!!!!!! https://anuj-singh.blogspot.com/2013/12/how-to-use-prelim-option-in-sqlplus.html echo $ORACLE_SID vihcdbd8x [oracle@ibrac02 dbs]$ echo $ORACLE_HOME /u01/app/oracle/product/12.2.0/dbhome_1 [oracle@rac02 dbs]$ [oracle@rac02 dbs]$ sqlplus -prelim SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 10 05:48:28 2025 Copyright (c) 1982, 2016, Oracle. All rights reserved. Enter user-name: / as sysdba idle sqlplus> shutdown abort ; ORACLE instance shut down. idle sqlplus> pwd /u01/app/oracle/product/12.2.0/dbhome_1 idle sqlplus> startup nomount pfile='initvihcdbd8x.ora' ORACLE instance started. Total System Global Area 2.2750E+10 bytes Fixed Size 19421832 bytes Variable Size 3355444600 bytes Database Buffers 1.9327E+10 bytes Redo Buffers 47685632 bytes idle sqlplus>
Search This Blog
Total Pageviews
Monday, 10 March 2025
ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0
Subscribe to:
Posts (Atom)
Oracle DBA
anuj blog Archive
- ► 2011 (362)