Skip to main content

Oracle Extended RAC Database Failed during auto startup.

 The following Error was encountered when we tried starting up the database manually:

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 4.8694E+11 bytes

Fixed Size                 37521640 bytes

Variable Size            5.5298E+10 bytes

Database Buffers         4.3111E+11 bytes

Redo Buffers              499347456 bytes

Database mounted.

Database opened.         " was non-numeric

Usage: { EXIT | QUIT }e [ SUCCESS | FAILURE | WARNING | n |

       <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ]

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.18.0.0.0

 

 

[oradbp@dbnode13 ~]$ srvctl start instance -i testdb11 -d testdb

PRCR-1013 : Failed to start resource ora.testdb.db

PRCR-1064 : Failed to start resource ora.testdb.db on node dbnode13

CRS-2680: Clean of 'ora.testdb.db' on 'dbnode13' failed

CRS-5802: Unable to start the agent prdbnodess

[oradbp@dbnode13 ~]$ cd /oracle/products/db

[oradbp@dbnode13 db]$ ls

 

Working node Dir permissions:

 

[oradbp@occ13 occ13]$ ls -ld /oracle/products/gi_base

drwxrwxr-x. 7 oragrid root 83 Apr 16 16:04 /oracle/products/gi_base

[oradbp@occ13 occ13]$

 

Non Working node dir permissions:

[root@dbnode13 ~]# ls -ld /oracle/products/gi_base

drwxrwx---. 7 oragrid root 83 Apr 22 10:45 /oracle/products/gi_base

[root@dbnode13 ~]# chmod -R 775 /oracle/products/gi_base

[root@dbnode13 ~]#

 

Solution and conclusion:

Make sure the permissions are changed on non working directory to be same as node where cluster startup is working fine.

Thanks for reading.

regards,

ZAHEER

Comments

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment...

Installation of Oracle Applications R12.1.1 on Linux and vmware

The below article is step by step procedure to Install oracle E-Business suite R12.1.1 on Oracle Enterprise Linux 5.6 (32-bit) using vmware server 2 on windows 7 64 bit. This is a single node Installation. (All services will be hosting on same machine 0 db, conc, web, forms etc) I have Installed it on a virtual machine with 4gb ram, 120 GB of local disk space and 1 core cpu. - Requires 80 GB of free space for fresh installation (excluding stage area) - Requires 100+ GB of free space for vision installation (excl. stage) I will split this configuration in 5 steps: 1) create and configure virtual machine 2) Install linux operating system 3) create stage Area 4) Perform all operating system per-requisites 5) Install oracle E-business suite R12.1.1 create and configure virtual machine: >> Login to vmware Server console >> click on add virtual machine >> Here i have selected iso image for OS Installation, you can select local cd drive if u want. >> Now the virtual m...