Oracle Database/ERP/Cloud/RAC/Misc Solutions

Create Listener in Silent Mode To create a listener in silent mode, please follow the below steps: $ netca -silent -responseFile /u01/app/oracle/product/12.1.0.2/db_1/assistants/netca/netca.rsp Parsing command line arguments:     Parameter "silent" = true     Parameter "responsefile" = /u01/app/oracle/product/12.1.0.2/db_1/assistants/netca/netca.rsp Done parsing command line arguments. Oracle Net Services Configuration: Profile configuration complete. Oracle Net Listener Startup:     Running Listener Control:       /u01/app/oracle/product/12.1.0.2/db_1/bin/lsnrctl start LISTENER     Listener Control complete.     Listener started successfully. Listener configuration complete. Oracle Net Services configuration successful. The exit code is 0

Create Database in Silent Mode After the Oracle Home is relinked, we have to create the Database using dbca However there are some issues with the Graphics Display or there is no graphics terminal available. In this case, we plan to create the database using silent mode. 1. Set up the Environment variables. ORACLE_HOME PATH mkdir -p /u01/app/oracle/oradata 2. Use DBCA to create the database dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCLDEV.channels.com.sa -sid ORCLDEV -sysPassword sys -systemPassword oracle123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 Copying database files 1% complete 3% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the ...

To turn off RAC $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk rac_off rm -f /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxp12.so cp /u01/app/oracle/product/12.1.0.2/db_1/lib//libskgxpg.so /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxp12.so rm -f /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxn2.so cp /u01/app/oracle/product/12.1.0.2/db_1/lib//libskgxns.so \       /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxn2.so /usr/bin/ar d /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/libknlopt.a kcsm.o /usr/bin/ar cr /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/ksnkcs.o # Relink Oracle $ make -f  ins_rdbms.mk  ioracle chmod 755 /u01/app/oracle/product/12.1.0.2/db_1/bin  - Linking Oracle rm -f /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/oracle /u01/app/oracle/product/12.1.0.2/db_1/bin/orald  -o /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/oracle -m64 -z...