Created database failed due to bashrc settings
(Doc ID 2578629.1)
Last updated on DECEMBER 02, 2022
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A to N/AInformation in this document applies to any platform.
Symptoms
Problem Summary
---------------------------------------------------
Failed to create new database
Problem Description
---------------------------------------------------
Trying to create a new 18c database, reusing an existing oracle home :
After about 2 mins, the console shows this log:
Aug 8, 2019 8:21:30 AM UTC Activity Submitted
Aug 8, 2019 8:21:30 AM UTC Activity Started
Aug 8, 2019 8:21:30 AM UTC Creating Oracle Database Service [dupcdb]...
Aug 8, 2019 8:23:32 AM UTC Failed to configure Oracle Database Server...[
SCRIPT execution errors in [xx.xxx.xxx.xxx]: Argument "bind:" isn't numeric
in numeric lt (<) at /var/opt/oracle/perl_lib/DBAAS/rac.pm line 2298.
Argument "bind:" isn't numeric in numeric lt (<) at
/var/opt/oracle/perl_lib/DBAAS/rac.pm line 2298. ERROR: OCDE createdb
pre-reqs failed, please check logs INFO: Total time taken by ocde is 95
seconds #### Completed OCDE with errors, please check logs #### INFO :
ocde_time_format is 2019/08/08 08:21:32 Use of uninitialized value $gh in
concatenation (.) or string at /var/opt/oracle/perl_lib/DBAAS/logger.pm line
631. Use of uninitialized value $gh in concatenation (.) or string at
/var/opt/oracle/perl_lib/DBAAS/logger.pm line 662. find:
'/tmp/REMOTE_LOGS/REMOTE_NODES/node4vm01/dupcdb': No such file or
directory Use of uninitialized value $gh in concatenation (.) or string at
/var/opt/oracle/perl_lib/DBAAS/logger.pm line 662. ]
Aug 8, 2019 8:23:32 AM UTC Initiating Database Service Termination...
Aug 8, 2019 8:23:33 AM UTC Removing Database Service records ...
Aug 8, 2019 8:23:33 AM UTC Preparing the scripts to remove Database Service
Aug 8, 2019 8:23:34 AM UTC delete.db.service.precheck.skip.delete.backup
Aug 8, 2019 8:23:34 AM UTC Executing Database Service removal scripts
Aug 8, 2019 8:24:35 AM UTC Database Service record removal complete...
Aug 8, 2019 8:24:35 AM UTC Activity Ended
File : ocde.log
------------------
2019-08-08 08:23:06.664390 - INFO: rac _is_local_listener_up check passed
2019-08-08 08:23:06.667006 - INFO : Executing cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' on node node1vm01
2019-08-08 08:23:06.667259 - Output from cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' run on localhost is:
2019-08-08 08:23:06.671595 - /dev/xvdh 1135204408 48056172 1029460172 5% /u02
2019-08-08 08:23:06.671737 - cmd took 0.00407195091247559 seconds
2019-08-08 08:23:06.671884 - INFO : Executing cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' on node node2vm01
2019-08-08 08:23:06.672086 - Output from cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' run on node2vm01 is:
2019-08-08 08:23:06.750170 - /home/oracle/.bashrc: line 4: bind: warning: line editing not enabled <<==========================
/home/oracle/.bashrc: line 5: bind: warning: line editing not enabled
/dev/xvdh 1135204408 39949780 1037566564 4% /u02
2019-08-08 08:23:06.750329 - cmd took 0.077855110168457 seconds
2019-08-08 08:23:06.750529 - INFO : Executing cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' on node exaobal303vm01
2019-08-08 08:23:06.750724 - Output from cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' run on exaobal303vm01 is:
2019-08-08 08:23:06.826327 - /home/oracle/.bashrc: line 4: bind: warning: line editing not enabled
/home/oracle/.bashrc: line 5: bind: warning: line editing not enabled
/dev/xvdh 1135204408 38062548 1039453796 4% /u02
2019-08-08 08:23:06.826468 - cmd took 0.0753679275512695 seconds
2019-08-08 08:23:06.826634 - INFO : Executing cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' on node node4vm01
2019-08-08 08:23:06.826826 - Output from cmd df -kP /u02 | egrep -vi '^ *$|Mounted on' run on node4vm01 is:
2019-08-08 08:23:06.901908 - /home/oracle/.bashrc: line 4: bind: warning: line editing not enabled
/home/oracle/.bashrc: line 5: bind: warning: line editing not enabled
/dev/xvdh 1135204408 38406552 1039109792 4% /u02
2019-08-08 08:23:06.902052 - cmd took 0.0748560428619385 seconds
2019-08-08 08:23:06.902487 - INFO: rac /u02 free space : 0
2019-08-08 08:23:06.902909 -
ERROR: rac _is_oh_space_available /u02 free space is less than 10gb. <<==========================
at /var/opt/oracle/perl_lib/DBAAS/rac.pm line 2009
rac::_is_oh_space_available('rac=HASH(0x36dee48)', 'no') called at /var/opt/oracle/perl_lib/DBAAS/rac.pm line 1169
rac::check_db_prereqs('rac=HASH(0x36dee48)', 'HASH(0x36decb0)') called at /var/opt/oracle/ocde/ocde line 2503
main::do_prereq('HASH(0x3649290)', 'logger=HASH(0x364c200)') called at /var/opt/oracle/ocde/ocde line 809
eval {...} called at /var/opt/oracle/ocde/ocde line 775
2019-08-08 08:23:06.903555 - WARNING: corereg: get: No value found for key wallet_loc
2019-08-08 08:23:06.904433 - INFO: corereg: set: Set ocde_status to prereqs_fail
2019-08-08 08:23:06.904547 - ERROR: OCDE createdb pre-reqs failed, please check logs
2019-08-08 08:23:06.904764 - ERROR: OCDE createdb pre-reqs failed, please check logs
\\\
No Space Issue - around 900 GB free space available
No issue in script - /var/opt/oracle/perl_lib/DBAAS/rac.pm
Changes
global bashrc modified
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |