Install Oracle Form 10g

By ukmodak | August 11th 2022 04:49:59 PM | viewed 192 times

At first Install oracle database

Install oracle jdk 6

Download oracle 10g developer suite and rename folder as dev_10g

Must Login windows as administrator

To set vertual memory go to environment variable ->top setting->advance->change->uncheck automatically manage-> check custom->16000 to 32000->set->ok->ok

To set windows compatible go to dev_10g folder->disk1->setup.exe->rightclick->properties->compatibility->select windows pack->next->complete pack->name:DevSuiteHome,path as d:/DevSuiteHome

To sove warning go to app/oracle_19c and rename networking folder

To set instance user:ias_admin pass:ias_admin1 if want

delete ORACLE_HOME from environment variavle

set up TNS_ADMIN='D:\DevSuiteHome_1\newwork\admin' instead of app/oracle_19c/network/admin from environment variavle

UPDATE PATH AS 'D:\DevSuiteHome_1\bin from environment variavle and reset path order or oracle as follows:

D:\DevSuiteHome_1\bin
D:\DevSuiteHome_1\jre\1.4.2\bin\client
D:\DevSuiteHome_1\jdk\jre\bin\clienty
D:\DevSuiteHome_1\jdk\jre\bin\classic
D:\DevSuiteHome_1\jdk\jre\bin
D:\DevSuiteHome_1\jlib
D:\DevSuiteHome_1\jre\1.4.2\bin
D:\app\oracle_19c_home\bin

note: to run database command double click on sqlplus.exe from the location:app/oracle_19c/bin  and run sqlplus 

tutorial link:Form 10g tns setup also follow as bellow

go to D:\DevSuiteHome_1\newwork\admin and rename tnsnames.ora as tnsnames_back.ora

 c>sqlplus                                               
 c>user-name:sys as sysdba                                
 c>password:sys 
 sql>show user; 
 sql>alter pluggable database all open; 
 sql>COLUMN name FORMAT a20; 
 sql>SELECT name, con_id FROM v$pdbs;  // to get component id of pluggable database
 sql>SELECT name as "Service_name" from v$active_services WHERE con_id =3;  //  to get service name of pluggable database component id

go to start -> oracle devepment suit -> net configuration assistent-> local net configuration option check ->add service name ->add tcl-> test login with username and pass->next ->next->finis. then automatically create tnsnames.ora 
 

if appear ora-12154:tns:could not resolve the identifier specifier means tns setup error then add the following code on both forn and database

sqlnet.ora =>

#SQLET.AUTHENTICATION_SERVICES = (NTS)
sqlnet.allowed_logon_version_server=8  
sqlnet.allowed_logon_version_client=10
names.directory_path =(ldap,tnsnames,ezconnect,onames,hostname)
go to toad and connect container as sys and alter passwors as follows: =>

alter user xxxxx identified by xxxxx;

go to start/oracle developement suite - devSuite ->start OC4J start -> more ->location ->start OC4J start->send to desktop and Forms Builder->send to desktop and Forms Compiler->send to desktop

go to desktop ->double click on OC4j

go to desktop ->double click on form builder if appear form then ok

Install safari 5.1.0 browser

from oracle form builder ->edit->preference -> runtime ->click on create default server url and copy(http://SDI-Uzzal:8889/forms/frmservlet) and save the url

from oracle form builder ->edit->preference -> runtime ->set default browser url as:C:\Program Files (x86)\Safari\Safari.exe and click on ok

browse the url:http://SDI-Uzzal:8889/forms/frmservlet from safary then oracle form will show

to check connection go to oracle form builder->connect then enter the following info

user:hongbao
pass:hongbao
sid:commonpdbs

if connect then ok

if appear ora-12154:tns:could not resolve the identifier specifier means tns setup error

After connect at the time of running form if occur login windows then run the following command

cmd>sqlplus 
cms>conn sys as sysdba
pass:sys
sql> show parameter cas
sql>alter system set sec_case_sensitive_logon=false;

to show compile form goto D:\DevSuiteHome_1\jinit\jinit.exe and double on exe

to show large form goto D:\DevSuiteHome_1\forms\server\formweb.cfg and set with and height value

bONEandALL
Visitor

Total : 19490

Today :25

Today Visit Country :

  • United States
  • Germany
  • United Kingdom
  • India
  • Switzerland
  • Singapore
  • The Netherlands