Blogs on Oracle DBA / Temenos T24 - Deepak Kumar

Download Oracle database software. You can download Oracle database software from the link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ·          You will need an OTN account to download this software. (It’s a free signup) ·          You can create an account with the link https://login.oracle.com/mysso/signon.jsp ·          You can use this software free for personal educational purpose. ·          You can only download current release (which is 12c) and the previous release (which is 11g) ·          If you require older version you will need Oracle Support account (which is paid account). Note : You can download various other software from Oracle free for educational purpose.

·       *    In a server if there is a listener running, then an Oracle database can dynamically register it in the listener to provide its service. ·        *  This dynamic registration is automatic if the listener is running in the Oracle default listening port 1521 ·        *   Incase if you want to allow dynamic database registration only to certain databases in the server. You need to run the listener in non-default port. (For example: 1522 or 1530 etc) ·        *   To allow dynamic registration of database services in the listener with non-default port we need to modify few parameters in database level. No changes needed in listener.ora file. Below are the parameters o    In case if the listener and database are in same server change the parameter LOCAL_LISTENER For example: Alter system set local_listener=”orclnew” scope=both; Where listener2 should be r...