Chetan Yadav | Oracle DBA & Cloud Trainer

ORA-12154 : "TNS:could not resolve  service name" Cause : oracle Net Services cannot locate the connect descriptor specified in the  tnsnames.ora configuration . >> verify the tnsnames.ora files exists and that accessible . >>verify that tnsnames.ora file in the location by the TNS_ADMIN environment variable. ORA-12198: "TNS: could not find  path to destination  " ORA-12203: "TNS: unable to connect the destination " >> verify that you have correctly enter the service name of the database that you  want to connect. >> verify that service name address ADDRESS parameter in the connect descriptor of your  tnsname.ora file are correct . >> verify that you tnsname.ora  file stored in the directory defined in the TNS_ADMIN environment Variable Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely...

sample tnsnames.ora --------------------------------------------------------------------------------------------------- # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\ network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORCL =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = xp)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = orcl)     )   ) EXTPROC_CONNECTION_DATA =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))     )     (CONNECT_DATA =       (SID = PLSExtProc)       (PRESENTATION = RO)     )   ) --------------------------------------------------------------------------------------------------- here my DB name is "ORCL" host is "XP" The tnsn...

Configuring Network settings on Oracle VM any mistake is there or u wanna give any suggestion so please write to me ............

Create tablespace SQL> create tablesapce tablesape_name         datafile 'datafilepath'         size 40m         autoextend on         next 32 m         extend management local; Create Temporary tablespce  SQL> create temporary tablesapce tablesape_name         datafile 'datafilepath'         size 40m         autoextend on         next 32 m         extend management local; (temporary tablespce can have only temp files not datafiles ) Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

What is the Maximum allowed length of Record group Column? Record group column names cannot exceed 30 characters. Which parameter can be used to set read level consistency across multiple queries? Read only What are the different types of Record Groups? Query Record Groups NonQuery Record Groups State Record Groups From which designation is it preferred to send the output to the printed?   Previewer What are difference between post   database   commit and post-form commit? Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions. What are the different display styles of   list items ? Pop_listText_listCombo box Whic...

What is the Maximum allowed length of Record group Column? Record group column names cannot exceed 30 characters. Which parameter can be used to set read level consistency across multiple queries? Read only What are the different types of Record Groups? Query Record Groups NonQuery Record Groups State Record Groups From which designation is it preferred to send the output to the printed?   Previewer What are difference between post   database   commit and post-form commit? Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions. What are the different display styles of   list items ? Pop_listText_listCombo box Which of the above...