Errors and Solutions

1. ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory

Solutions -

SQL> show parameter local_listener;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=cor.carzonrent.com)(PORT=1526)(SID=TEST2))';

System altered.

SQL> alter system register;

System altered.

SQL> show parameter local_listener;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string      (ADDRESS=(PROTOCOL=TCP)(HOST=c

                                                 or.carzonrent.com)(PORT=1526)(

                                                 SID=TEST2))

2. ERROR.
ORA- 30036 : unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'
ORA- 06512 : at "APPS INSERT TABLE ", line 13
ORA-06512 : at line 9

Solutions -

SELECT dt.tablespace_name, dt.contents,

             ddf.file_name, ddf.bytes/1024/1024 size_MEG

        FROM dba_tablespaces dt,

             dba_data_files ddf

       WHERE dt.tablespace_name = ddf.tablespace_name

         AND dt.contents = 'UNDO';

        

alter tablespace APPS_UNDOTS1

add datafile '/data/cipl/cipldata/APPS_UNDOTS102072016.dbf' size 4096m autoextend on

3. ERROR

Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0.3/db_1/network/lib/ins_net_client.mk' while installing 10g database software

While installing oracle 10g software, It threw error as 

"Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0.3/db_1/network/lib/ins_net_client.mk' "


Solution: Check the software you are using. Probably you are using 64 bit OS software for 32 bit operating system.