Install Oracle Xe (10G) on Linux 64

Oracle Application Express - web application development tool (antigamente conhecido como Oracle HTML-DB)
Post Reply
rafasnn
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 26
Joined: Thu, 26 Feb 2009 4:00 pm
Location: São Paulo - SP

Personal,

I installed Oracle Xe correctly in Ubuntu 64, only when I restart the server I have to run the command below for Oracle Rotate, would anyone know a way to automate this?

Select all

digite sqlplus no terminal 
EXEC DBMS_XDB.SETHTTPPORT(SUA PORTA WEB);   
http://(SEU_IP )/apex.
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

I'vê never done it, but I think you could create a Trigger After Startup and put that DBMS to run.
http://www.psoug.org/reference/system_trigger.html
Something like this:

Select all

CREATE OR REPLACE TRIGGER "SYS"."EXECUTA_DBMS" AFTER STARTUP ON DATABASE 
BEGIN 
  DBMS_XDB.SETHTTPPORT(SUA PORTA WEB); 
END; 
/
Does this solve?
rafasnn
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 26
Joined: Thu, 26 Feb 2009 4:00 pm
Location: São Paulo - SP

DR_GORI,

So I really wanted to find the failure, setup process or something, I made a script to solve such on the server, but I really wanted to understand where the fault is.
rafasnn
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 26
Joined: Thu, 26 Feb 2009 4:00 pm
Location: São Paulo - SP

up
rafasnn
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 26
Joined: Thu, 26 Feb 2009 4:00 pm
Location: São Paulo - SP

Solution:

Select all

EXEC DBMS_XDB.SETHTTPPORT(SUA PORTA WEB); 
COMMIT; 
Solved!
rafasnn
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 26
Joined: Thu, 26 Feb 2009 4:00 pm
Location: São Paulo - SP

Solution:

Select all

EXEC DBMS_XDB.SETHTTPPORT(SUA PORTA WEB); 
COMMIT;
Resolved!
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 7 guests