Karan Rajpoot Oracle DBA Blog's

Step 1) You need to go to the ORACLE_HOME/bin location manually to run the DBCA utility Example: -   [oracle@prod bin]$ cd /u01/app/oracle/product/11.2.0/db_1/bin [oracle@prod bin]$ Step 2)  Now run dbca utility through below command Example: - ./dbca Click on below "Next" button to proceed further Step 3) Click on " Create a Database " tab to proceed further Step 4) Click on " General Purpose or Transaction Processing " tab because we are using for practice purpose but in real environment  choose options as per the requirement Step 5)  Put the name of Database which you need to create, in my case it is "orcl" Step 6) Check the "Configure Enterprise Manager" tab and "Automatic Maintenance Tasks" tab, but make sure your listener is up and running, otherwise, you need to uncheck  "Configure Enterprise Manager" tab to proceed further Step 7) Put all...

Error 1) [oracle@prod ~]$ dbca No protocol specified Error 2) [oracle@prod ~]$ netca Oracle Net Services Configuration: No protocol specified Error: null Check the trace file for details: /u01/app/oracle/cfgtoollogs/netca/trace_OraDb11g_home1-1901166PM3102.log Oracle Net Services configuration failed.  The exit code is 1 Solution Step 1) login as root user Step 2) run command xhost + this command allows you to use any graphical tool Example: - [root@prod Desktop]# xhost + access control disabled, clients can connect from any host Step 3) Now again run graphical tool utility command, that issue will get resolved now. [oracle@prod ~]$ dbca

                                STEPS TO CREATE a "MANUALLY  DATABASE " IN ORACLE Step 1)   Create a manual entry in /etc/oratab file for a database which needs to be built, in my case I am using "Karan" [oracle@prod ~]$ cat /etc/oratab # # This file is used by ORACLE utilities.  It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration Assistant while creating an ASM instance. # A colon, ':', is used as the field terminator.  A new line terminates # the entry.  Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: #   $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively.  The third filed indicates # to the dbstart utility that the datab...