ORA-01722: invalid number


Issue :


ORA-01722: invalid number

Cause:


I. Attempt has been made to insert a character value in integer datatype column


SQL> create table mytest ( one integer , two varchar2(10));

Table created.

CRS-4123 CRS-4124 CRS-4000


Issue:   cluster start command "crsctl start crs"  fails to start crs services

CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-4124: Oracle High Availability Services startup failed
CRS-4000: Command Start failed, or completed with errors


Cause:

Recent changes to cluster hosts ...

CLSRSC-218: Failed to install the OHASD startup script CLSRSC-317: Failed to register Oracle OHASD service

Problem:

During Standalone 12c oracle grid installation it has been observed that root.sh is failing on SUSE Linux 11 due to errors CLSRSC-218 & CLSRSC-317

$ /rdbms/app/12.1.0.2/grid/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= ora11g
    ORACLE_HOME=  /rdbms/app/12.1.0.2/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /rdbms/app/12.1.0.2/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'ora11g', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node testlab2 successfully pinned.
2015/09/14 12:11:01 CLSRSC-218: Failed to install the OHASD startup script (error: 25)

2015/09/14 12:11:01 CLSRSC-317: Failed to register Oracle OHASD service

Work Life Balance




                                                       
                Saiket , a computer engineer aged just less than 30 staying with his family including his wife Renuka , son Ansh in rented house in a City. Nearby to his house his parents as well as in-laws were staying. Having parents nearby was good source of support when Ansh was born and growing. Saiket was working for an IT firm over 5 yrs which is considered amongst the top industries.


ORA-15018: diskgroup cannot be created

Errrors:



SQL> create diskgroup DG03 external redundancy disk '/dev/abc' attribute 'compatible.asm'='11.2';

create diskgroup DG03 external redundancy disk '/dev/abc' attribute 'compatible.asm'='11.2'

*



ORA-15018: diskgroup cannot be created

ORA-15031: disk specification '/dev/abc' matches no disks

ORA-15025: could not open disk "/dev/abc"

ORA-15056: additional error message

Linux-x86_64 Error: 13: Permission denied

Cause: Permission of the raw device path as root