Form 6i With Oracle 1. Database Link SOLVED. Everything was working fine with 1. Forms 6i, the Forms Oracle Financials on our unix server would not compile, the Forms 6i Designer tool would crash, and existing compiled forms. After testing different scenarios and configuring both Source and Destination databases differently, I changed out the Synonyms that pointed across the DB Link to use Views instead ie. Drop Synonym Table. Database Schema Design Tool. Name. On. Remote. DB 2 Create or Replace View as Select from Table. Resistance Fall Of Man Pc Game. Name. On. Remote. DBDBLinnk. Then re compiled all my local views that used these tablenames as well as any stored packages, procedures, and or functions. My assumption is that Forms 6i can now resolve object specification because the metadata about the objects attributes are now stored locally in my Source Db. Upon doing this, I was able to. Use the Forms Designer Tool completely. Compile the Form on the Application Server referencing objects over database link, and. Q Oracle DataBase. Oracle DataBaseA B. Have the Application recognize and run the form wo error ie. Oracle Runtime. However, there was a hiccup between my Source and Destination databases because my Destination db had password case sensitivity turned on, and due to some limitations with our application, I cannot turn that on in my Source db. I have had success in both of the following scenarios Scenario 1 DBLink TypePrivate FIXED User Password Case Sensitivity Turned Off in both Source and Destination Db seccasesensitivelogon set to FALSE Scenario 2 DBLink TypePrivate CONNECTED User Password Case Sensitivity Turned Off in both Source and Destination Db seccasesensitivelogon set to FALSE I would think that case sensitivity turned ON in both DBs would also work, but thatll be something you need to test yourself. Setting an Oracle Environment variable ORACLEHOME. Hello,When I check my blog hit counter statistics, my blog is being hit and searched by the blog users with the word Oracle Home, but, looks like they are not finding the required information on Oracle Home Environment variable. So, I wanted to explain about ORACLEHOME in my simple terms which is helpful for novice. What is ORACLEHOME used forThe ORACLEHOME is an environment variable which is used to set and define the path of Oracle Home server Directory. The ORACLEHOME directory will have the sub directories, binaries, executables, programs, scripts, etc. Oracle Database. This directory can be used by any user who wants to use the particular database. If the ORACLEHOME variable is defined as an environment variable, then during the installation process, the Oracle Home Path will be set to the directory defined as default. If the variable is not defined, then the Oracle will take its own default location. The ORACLEHOME variable does not have to be preset as an environment variable, it can be set during the installation process. Basically The ORACLEHOME variable is in the following ORACLEBASE directory ORACLEHOMEORACLEBASEproduct1. How to send personalized email to clients registered in my portal www. Database Oracle 8i automatically and we. Sabdar Syed I have been working in the IT sector since 2002. Presently Im working as a Senior Oracle Database Administrator for HP hewlett packard in. Author Oracle DBA and Apps DBA bloghttpswww. IDSERP,5126. 1MegaRAID SAS 92668i BroadcomMegaRAID SAS 92668i Support the internal connectivity and bandwidth needs of applications like databases and digital media. Udit, If theres no remote database that you can connect to and you want to practice Oracle then you will have to install Oracle RDBMS Server on your local machinePC. What is ORACLEBASE used forThe ORACLEBASE is also an environment variable to define the baseroot level directory where you will have the Oracle Database directory tree ORACLEHOME defined under the ORACLEBASE directory. Basically, The ORACLEBASE directory is a higher level directory, than ORACLEHOME, that you can use to install the various Oracle Software Products and the same Oracle base directory can be used for more than one installation. Note If you did not set the ORACLEBASE environment variable before starting OUI, the Oracle home directory is created in an appusernamedirectory on the first existing and writable directory from u. UNIX and Linux systems, or on the disk drive with the most available space for Windows systems. If u. 01 through u. UNIX or Linux system, then the default location is userhomedirectoryappusername. SUMMARY Over 7 years of experience as an Oracle Applications R1211i E Business Suite Techno Functional consultant, with expertise in Oracle Financials modules GL. Hallo Tom, We use Oracle 8. AIX server. We have a database with the character set US7ASCII. I know it can present ASCIICode from 0 to 127. How to check if ORACLEHOME is set already On UnixLinux Systems Basically, before or after the Oracle Database is installed, the oracle user profile, the environment variable file, is prepared where all the required environment variables for Oracle are set. Install Oracle 8I On Windows 2008' title='Install Oracle 8I On Windows 2008' />ORACLEBASE, ORACLEHOME, ORACLESID,PATH, LDLIBRARYPATH, NLSLANG, etc. The user profile file can be. Bash Shell. profile Bourne Shell or Korn shell. C Shell. Note This user profile file will be under users home directory i. HOME. bashprofile. To check specific environment variable set echo ORACLEHOMETo check all the environment variables set env. On Windows Systems To check specific environment variable set C set ORACLEHOMEORC echo ORACLEHOMETo check all the environment variables set C set. Or. C env. Other way, to check the ORACLEHOME, is as follows. Start Run Regedit enter HKEYLOCALMACHINE SOFTWARE ORACLEi. My ComputerHKEYLOCALMACHINESOFTWAREORACLEHow to check using sqlplus command To find the ORACLEHOME path in Oracle Database. How to set the ORACLEHOME environment variableOn UnixLinux Systems Define the ORACLEHOME value in the user profile file i. ORACLEHOMEORACLEBASEproduct1. ORACLEHOMESource the user profile as follows Bash shell. Bourne shell or Korn shell. C shell source. If no profile file is set with environment variables, then physically also be set as follows Bourne, Bash, or Korn shell ORACLEBASEoracleapp export ORACLEBASE ORACLEHOMEORACLEBASEproduct1. ORACLEHOMEC Shell setenv ORACLEBASE oracleapp setenv ORACLEHOME oracleappproduct1. On Windows Systems My Computer Properties Advanced Environment Variables System Variables NewEditDelete to set the variablesAfter setting the environment variables as above, open a fresh CMD tool and check whether they set properly or not. Do not try on already opened CMD tool to make sure the variables set or not. Another way to physically set the variables as follow at the DOS prompt C set ORACLEHOMEC oracleappproduct1. C echo ORACLEHOMENote I would suggest to refer the Oracle Documentation on Installation where these environment variables are discussed and explained with the enough information. Regards,Sabdar Syed.