1) The 'DB_Admin_password' is the SDE user password
2) No.
3) In a "Remote Server" configuration, no ArcSDE service is created on the Oracle server.
The DBA can help you make sure that your client install is correct (it should be the same
release as the server [10.2.0.4, in this case]), that your tnsnames.ora is correct (via 'tnsping'),
and that you can successfully connect to the server via SQL*Plus after setting the LOCAL
environment variable (the dbinit.sde should have the same LOCAL [not ORACLE_SID] contents).
4) There certainly is a way to define which port to use -- the "-i <service>" parameter
of 'sdeservice'. You must edit the %SystemRoot%\system32\drivers\etc\services file
to map the mnemonic to a port number. It's not required that all hosts in your network
have the same services file, but it is a good idea. I typically run 15-20 different services
on my networks at home, office and client sites; it just takes a little effort to set up a
naming convention appropriate for the network, then copy/paste the 5151->???? entries
into the services file on each host.
30-sec connection timeouts are generally due to a bad hostname/port combination,
so you want to be sure your LOCAL is pointing to a correct tnsnames.ora entry.
It would probably be best to start an incident with Tech Support so they can walk you
through this configuration (it's tricky the first time, but by the third time you won't even
need the documentation).
- V