Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Install Oracle 11gR2 on HP-UX

shiva_oracleJul 9 2013 — edited Jul 14 2013

Hi all,

Oracle Database Version :11gR2 single instance

OS: HP-Ux B.11.31 ia64

Connectivity to OS :Throught Telnet

I need to Install Oracle 11gR2 on HP-UX B.11.31 i164  through telnet.

I copied oracle software to /tmp location.

set kernal parametes as mentioned in http://docs.oracle.com/cd/B28359_01/install.111/b32329.pdf

created user oracle , groups dba, oinstall.

created mount point /u01/app/oracle and required directories

what are the environment vairables i need to set,

what is the best strategry for directory layout to install oracle (for archive logs, FRA etc)

Can i install graphically using telnet in hp-ux

Please guide me through the step by step process of installing oracle through telnet

Thanks

Comments

fac586

Marko Goricki wrote:

is there a way to generate URL for calling APEX page with checksum at the end of the link if URL is generated outside of APEX?

If I call function like this one outside of APEX, checksum is not generated:

  1. createorreplacefunctionf_get_apex_url
  2. returnvarchar2
  3. is
  4. begin
  5. returnapex_util.prepare_url(p_url=>'f?p=100:1:0::::P1_ITEM:1'
  6. ,p_checksum_type=>'PUBLIC_BOOKMARK');
  7. end;
  8. /

I've noticed that by populating global variable (g_curr_flow_security_group_id) in wwv_flow_security function works fine:create or replace function f_get_apex_u

  1. createorreplacefunctionf_get_apex_url
  2. returnvarchar2
  3. is
  4. begin
  5. apex_050100.WWV_FLOW_SECURITY.G_CURR_FLOW_SECURITY_GROUP_ID:=1830663391033130;
  6. returnapex_util.prepare_url(p_url=>'f?p=100:1:0::::P1_ITEM:1'
  7. ,p_checksum_type=>'PUBLIC_BOOKMARK');
  8. end;
  9. /

But, I don't like the fact that this function depends on current APEX version.

There are documented, version-independent API methods for setting the security group ID:

Marko Goricki

Hi fac586,

thanks for quick answer.

I've tried to use set_security_group_id and as far as I know it sets wwv_flow_security.g_security_group_id global variable and not g_curr_flow_security_group_id which apparently is important for generating checksum.

I forgot to note that I've tested this on APEX 5.1.3.00.05.

Br,

Marko

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 11 2013
Added on Jul 9 2013
6 comments
1,244 views