oracle ora code

ora code

1. ora-21561

   1. message: oid generation failed

   2. on macos sierra

   3. fixed

       $ hostname
       gree2
      
       $ cat /etc/hosts
       127.0.0.1 localhost gree2
      
       # these 2 must be match
      

tns test

1. tnsnames.ora

   1. file D:\app\Administrator\product\11.2.0\client_1\NETWORK\ADMIN\tnsnames.ora

       ORCL =
       (DESCRIPTION =
           (ADDRESS_LIST =
               (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
           )
           (CONNECT_DATA =
               (SERVICE_NAME = ORCL)
           )
       )
      

2. listener.ora

   1. file D:\app\Administrator\product\12.1.0\dbhome_1\network\admin\listener.ora

       # listener.ora Network Configuration File: D:\app\Administrator\product\12.1.0\dbhome_1\network\admin\listener.ora
       # Generated by Oracle configuration tools.
      
       SID_LIST_LISTENER =
         (SID_LIST =
       #    (SID_DESC =
       #      (SID_NAME = CLRExtProc)
       #      (ORACLE_HOME = D:\app\Administrator\product\12.1.0\dbhome_1)
       #      (PROGRAM = extproc)
       #      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll")
       #    )
           (SID_DESC =
             (GLOBAL_DBNAME = ORCL)
             (ORACLE_HOME = D:\app\Administrator\product\12.1.0\dbhome_1)
             (SID_NAME = ORCL)
           )
         )
      
       LISTENER =
         (DESCRIPTION_LIST =
           (DESCRIPTION =
             (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-UOICH30060A)(PORT = 1521))
           )
         )
      
       ADR_BASE_LISTENER = D:\app\Administrator\product\12.1.0\dbhome_1\log
      

3. sqlplus

   1. test conn

       $ sqlplus /nolog
       > conn scott/tigger as sysdba
      

4. tnsping

   1. test conn

       $ tnsping orcl