Error printing success messages whith tomcat and apex listener - ORDS, SODA & JSON in the Database

Hello everybody
when I submit button to validate something in my apex application using tomcat 6 and apex listener, I have the following
print success message checksum content error: : 00ABFFFF8E57CDD55EE2BF095633CA51
someone can help me please!!! 

What is your APEX version?
regards 

I have:
. apex 3.2.1
.apex_listener.0.10.110.10.57
.apache-tomcat-6.0.26
.jdk-6u18-windows-i586 

I get the same error when I try to confirm a password change for example:
erreur de contenu de total de contrôle de message de succès d'impression : : 5E9CBC38B885960093BCF5023F681B8F
although everything works perfectly from the Embedded PL/SQL Gateway
I run my test on
- Database 10g Express Edition
- apex_listener.0.10.110.10.57
- apache-tomcat-6.0.26 (correctly configured)
- jdk-6u18-windows-i586
regards 

hi,
Have you change authorization scheme for that page ?
Regards,
Kartik 

Hi Kartik,
What do you mean under "change authorization scheme" ? I just change the password as I do without problem with the Embedded PL/SQL Gateway
Best regards,
Frédéric 

hi,
Can you tell me, in Duplicate Submission section of page what is the selection in Allow duplicate page submissions
Regards,
Kartik 

Hi,
We have the same issue and it seems the error only pops up when some "strange" characters are part of the message (in French: é and è for example). Replacing these characters is a temporary workaround, but can not be the final solution for a multi-language Apex application.
It feels like a bug.
thierry 

Easy solution : use é etc substitutions, it will work !

Related

Glassfish and Listener error : HTTP Status 500 - System Unavailable.

Hello,
I 've some problem. When i'm working in workspace and develope my application everything fine, but when i try to run it , i have this :
HTTP Status 500 - System Unavailable. Please try again later.
type Status report
messageSystem Unavailable. Please try again later.
descriptionThe server encountered an internal error (System Unavailable. Please try again later.) that prevented it from fulfilling this request.
Oracle GlassFish Server 3.1
After refreshing, page work fine , but every actions in application have this problem. Well, users can't work normaly with my application.
Please help me with this problem.
I use Oracle 10g , Apex 4.0 , Glassfish 3.1, redhat 5
Sorry for my bad english.
Egor Karmanov.
Edited by: 843328 on 07.06.2011 1:58 
Hello Egor,
seems your Listener can't open a new session. Can you provide the stack trace from the applications (or perhaps global GlassFish) log file and your Listener settings? The most relevant parameters are written into the logfile as well when the application starts up.
-Udo 
Hello Udo , thanks for your answer.
Glassfish log is available by this link :
http://turbobit.net/d1snwandd9a0.html
- Egor Karmanov
Edited by: 843328 on 07.06.2011 3:06
Edited by: 843328 on 07.06.2011 3:08 
Hello Egor,
<ol><li>I see one error that seems to occur often on your server:
ORA-20867: ORA-12705: invalid or unknown NLS parameter value specified
ORA-02063: preceding line from WWW
ORA-06512: at "SYS.DBMS_SESSION", line 153
ORA-06512: at "APEX_040000.WWV_FLOW_LANG", line 387
ORA-06512: at "APEX_040000.WWV_FLOW", line 9328
ORA-06512: at "APEX_040000.F", line 267
ORA-06512: at "APEX_040000.F", line 294
ORA-06512: at line 2Probably you have some unsupported language or characterset configured for your application or APEX instance as default, which is not taken when you login to your application builder.
</li>
<li>What I see from your log as well: You still use APEX Listener version : 1.1.0.60.10.38, I'd recommend to update to the current 1.1.2 release.
</li>
<li>I see some other errors and warnings in your log, e.g.
WARNING|oracle-glassfish3.1|org.apache.catalina.connector.Request|_ThreadID=20;_ThreadName=Thread-1;|PWC4011: Unable to set request character encoding to UTF-8 from context /apex, because request parameters have already been read, or ServletRequest.getReader() has already been calledand
SEVERE|oracle-glassfish3.1|org.apache.tomcat.util.digester.Digester|_ThreadID=10;_ThreadName=Thread-1;|Digester.getParser:
javax.xml.parsers.ParserConfigurationException: The XDK supports only namespace-aware parsers.
[...]The warning can easily be ignored. I'd recommend to disable it to make keep your log file smaller and clear. See the [url http://wiki.glassfish.java.net/Wiki.jsp?page=FaqWebAppUnableToSetRequestCharEncoding]GlassFish FAQ for that warning.
The severe error is more interesting. There seems to be a problem concerning the XML parser, probably due to a library conflict. There was a thread on a similar issue concerning Tomcat ({thread:id=2174509}), but possibly such things can happen on GlassFish as well, especially when you have installed some global libraries. As you can see in the Tomcat-Thread, removing xmlparserv2-11.2.0.jar from +\apex\WEB-INF\lib+ solved the problem there.
</li>
</ol>
I hope these points help you to solve your problem. If not, can you post some additional information about your NLS/LC settings in GlassFish/Java/APEX environments?
-Udo 
Hello Udo
Thanks a lot for you help!!
I'm newbie in Apex. Where i can see my NLS/LC settings ?
I'm upgrade listener to 1.1.2 ,remove xmlparserv2-11.2.0.jar, but problem doesn't gone ((
Sorry for my bad english.
Egor Karmanov. 
Hello Egor,
don't worry too much about your English - mine isn't perfect either, but as long as you are understood, everything is fine. ;)
Back to your problem:
Where i can see my NLS/LC settings ?First, you could display the current locale setting by executing
localeand review additional settings with
env | grep -E "LC|NLS"If you didn't change anything regarding NLS parameters, your GlassFish will still be configured with UTF-8, so there would be no need to check.
You can set additional parameters in your application or globally for you APEX installation. But if you changed or configured anything there, you'd probably know where to look for it. ;)
-Udo

APEX Listener - Browse File Issue

Hi guys,
I have a strange Issue on new Apex Listener and APEX4:
My arch is: Oracle 11g - APEX4 - Apex Listener - Oracle Glassfish 3.1
When i try to upload a file with a "Browse File" item, I can do this only if the local path of my file is less than 80 char, this problem appear only on IE, on FF all work right!
For Example, using IE, if i try to upload a file located on my pc in "C:\Documents and Settings\MYUSERNAMEDIRECTORYMYUSERNAMEDIRECTORY\Documenti\Immagini\Immagine.JPG" (note the full path lenght is more than 80 chars ), the system don't upload my file.
Using FF, the same file is uploaded correctly.
If I try to upload a file located in "C:\immagine.JPG" (note the full path length is less than 80chars ) , using FF or IE, everything work correctly.
I found another user with the same problem on APEX Forum, this is the link -> Re: APEX Listener Feedback - File Upload Issue
but I didn't found any solution or workaround.....
Is this a bug?Is it a problem only with new Apex Listener? or this issue is only with Apex Listener with GlassFish ?
I test it without Apex Listener and this problem don't appear!
Best Regards,
Emilio 
I have the SAME problem......................any solution? 
Hi guys,
no solution but a comment on testing. I work with oracle 11g, apex 3.2, I.)mod plslq Gateway IIa) Tomcat IIb)OC4j & APEX Listener
FF an IE comparision:
1. mod pl/sql Gateway + long filename/path
FF works fine, IE works fine
2. mod pl/sql Gateway + short filename/path
FF works fine, IE works fine
3. OC4j & APEX Listener + long filename/path
FF dont works, IE dont works
4. OC4j & APEX Listener + short filename/path
FF dont works, IE dont works
ps
for Tomcat same results with file Browse, but there is no support for issues, so OC4j is doing the same.
Any help welcome, thanks
Thomas 
I confirm, I have the same problem. 
Is there any information in the log files?
-kris 
Kris,
In my testing - No "web server" events are generated.
Is there a particular log you are intersetd in?
Using the listenerAdmin - With all logging and Errors on...
Errors - None
Logging
A bunch of this...
08/05/10 16:00:11 Procedure apex_util.get_blob_file FOUND Args 11 DBTime 42 ms ProcessingTime 84 ms
I am very willing to work with you on this subject.
-- Tim St. Hilaire 
Regarding Testing - I will echo Thomas's findings.
The now released version of Apex Listener - the uploads don't work with LONG or SHORT path names when using IE.
The previous "Early Adopter" version did work with "short" paths when using IE. The released version (apex_listener.1.10.179.10.43) seems to have an issue with IE in general. (testing with IE8 currently)
--Tim                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
Kris,
Some data for you - Hopefully it helps.
When files are being uploaded via IE through the listener, they are coming in with FULL PATHS from their source.
Example from the DEBUG log on a simple application that allows image uploads.
<pre>
IE8 – Upload with Listener : 0.28: ...Session State: Saved Item "P1_IMAGE" New Value="F1346299084/C:\TJSH\danger_512.gif"
IE8 – Upload with mod_plsql : 0.29: ...Session State: Saved Item "P1_IMAGE" New Value="F16253/danger_512.gif"
FF – Upload with Listener : 0.12: ...Session State: Save Item "P1_IMAGE" newValue="F158067855/danger_512.gif" "escape_on_input="N"
FF – Upload with mod_plsql : 0.23: ...Session State: Save Item "P1_IMAGE" newValue="F10898/danger_512.gif" "escape_on_input="N"
</pre>
This shows that IE uploads - through the listener include the c:\ path to the file.
Once upon a time - this was an issue with the standard APEX upload in the APEX builder (like application imports and static files) - this is no longer the case - Images and files can be uploaded through the APEX builder just fine.
Now seeing that file uploads work in the builder - uploads of static files - file names still INCLUDE the full path, but the process works as expected.
I would guess the conflict is in the field code / built in within APEX that is not liking the extra characters.
In my example - the P1_IMAGE field is defined using Source Type of Database Column: IMAGE:MIMETYPE:FILENAME:UPDATED_ON::inline:Download Me
I wanted to share this observation in the hope that it will help expedite a possible solution.
--Tim St.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
Here's what I'm thinking and checking on...
wwv_flow_file_objects$.filename is a varchar2(400). This is where the limit is getting hit. mod_plsql must have mangled the name down to fit in that. I'm not. I'm checking still....
-kris 
Problem Solved in new Listener version (1.0.2)
thank you!

Anoying connection leak on imported JSC1 project

Hi.
After more than a year I'm requested to do some maintenance in a simple JSC 1 application.
I succesfully import the project in JSC 2 and after one minor change (just an execute() in rowset which feeds a combobox) I can run the application. After a few navigations between the firts page, which has a record list based on rowset, and the edit pagem the application gives me an error telling the following:
Datos de la excepci�n: javax.servlet.ServletException
javax.faces.FacesException: java.sql.SQLException: Error al asignar una conexi�n. Causa: La conexi�n no se pudo asignar porque: [sunm][Oracle JDBC Driver][Oracle]ORA-12519 The listener could not find any available service handlers that are appropriate for the client connection. One possible cause for this error is that the server was not configured for the specified server type (shared/dedicated).
I found that by default the rowsets have HOLD_CURSOR_OVER_COMMIT and they havent auto commit enabled. I thoug that setting CLOSE_CURSOR_AT_COMMIT and enabling autocommit the problem should go away but thas wasnt the case.
�Has some one has this problem?
I'm using JSC 2 with lates updated applied, Oracle XE, Sun's JDBC driver, my development machine is Toshiba Laptop PIV 3.GHZ HT with 1.2 GB RAM. 
�Someone? 
Well, since it seems that nobody has this problem, I will need JSC1 but I couldn find the installation disk.
Where can I download JSC 1?
Regards. 
FWIW, afterRenderResponse() isnt called in firts invocation (no restore view) of my main page and this method is never called in the edit page.
I try forcing the call using TImer (a work arround gived to me by John Baker in late 2004) I force the methiod call but calling close() in rowset methods doesnt release connections.
Regards.

Encoding EAS_ADMIN.HBRPLUGINDATA.OLAPPASSWORD

Hi all,
We are trying to simulate a connection to planning using SQL. Our goal is to be able to launch HBR rules without connecting to planning first...
We now know that when we insert a row in the table EAS_ADMIN.HBRPLIGINDATA for our application, we can launch a rule without connecting first.
The problem is : the OLAPPASSWORD columns contains the password of the connected user but it is encoded.
The number of character of the encoded string is 4 times the length of the real password and every 2 characters, there is a "AA" string" but we just cannot manage to find how it is encoded.
We need this to set a variable in our script that will stands for the password and then be encoded to be inserted in the HBRPLUGINDATA table.
Does any of you have already done this ?
Thx for your help.
Example of strings :
Password : "Hyp" (good password don't you think :-) )
OLAPPASSWORD column value : "AACHAABFAAEJ" 
Details of the Planning application that the Business Rule is to be run against cannot be found in the HBRPluginData table. This is required in order for Planning to connect to the Business Rule (HBR) repository.
It is by design that when the EAS server starts up the plugin data table is empty. There is also a background thread that runs periodically in EAS that will clean up any entries that are obsolete. Obsolete entries in the table are those that have been inactive for more than twice the value defined for the property PLUGIN_DATA_REFRESH_RATE. This property is defined in the HBRServer.properties file.
Logging into each Planning application needed for the execution of the business rules in the sequence will Help.
Some of hbrserver.properties :
HBR.maxconn
- The maximum number of database connections that can be open for Business Rules.
HBR.timeout
- The timeout in milliseconds for Inactive sessions on Business Rules.
HBR.embedded_timeout
- The Server timeout setting in minutes for inactive connections to the server.
HBR.css_refresh
- Automatic Synchronization setting between HBR and Shared Services.
PLUGIN_DATA_REFRESH_RATE
- There is a background thread that runs in Essbase Administration Services (EAS) that will clean up the HBR connection entries that are obsolete. Obsolete entries in the tables are those that are there for longer than twice the value defined for the property PLUGIN_DATA_REFRESH_RATE. Set in milliseconds.
MYOLAP_ENABLED
- Determines whether HBR should launch against Essbase (Planning Web, EAS) or against embedded OLAP (Offline). Planning has a feature called 'Offline Planning' which installs a smaller version of Essbase called MyAnalytics. This setting determines whether to use the Essbase server or MyAnalytics. If set to False it will use Essbase.
HBR_CACHE_REFRESHRATE
- The caching refresh rate in milliseconds for Business Rules. It is used in conjunction with the #HBR_CACHE=disabled setting. 
Thank you for answering.
We don't need ton access HBR informations, we are to develop some scripts that will make it possible to run HBR rules during the night when our users ask. But before our script can begin to run the known HBR rule à 02 AM, we want to write a line in the HBRPLUGINDATA table to emulate one's connection in order for the rule to run successfully.
I hope it is clearer with this informations ?
I found a script in the Planning installation directory called PasswordEncryption.sh but the result is not correct. I'm looking for the same script in the essabse directory but I think we don't have all the directories of essabse installation on our server...
Does someone have a script called PasswordEncryption.sh somewhere here <HYPERION_HOME>\products\Essbase\eas\console\bin ?
Thx ! 
Can you not just insert the admin user name and encoded password?
Cheers
John
http://john-goodwin.blogspot.com/ 
That's what I want to do !
The problem is, how can I encode the password... 
Have a look at your planning datasources in the planning system database - HSPSYS_DATASOURCE will using the ESS_PASSWORD encoded password work?
Or maybe you could put a trigger on the EAS table and capture what records are being inserted and then see the encoded password.
Cheers
John
http://john-goodwin.blogspot.com/ 
Thanks again for your help.
I can see the password when I connect to planning as I look in the HBRPLUGINDATA table.
But this is on our developpement server. On the "production" server, I won't know any password. Someone will have to write once when installing, that's why I want to be able to make a script that will encode the password.
Can someone look (windows or unix) if there is a script called PasswordEncryption (.bat or .sh) here : <HYPERION_HOME>\products\Essbase\eas\console\bin ?
Otherwise, I'll have to install a new Essbase somewhere to see if this script (that is referenced in the HY P E R ION BUS I N E S S RUL E S
ADMINI S TR A TOR ’ S G U I D E ) is there ?
Many thanks !
Edited by: user7932427 on 2 avr. 2012 02:34 
Did you see if you could use the encrypted password from the HSPSYS_DATASOURCE table.
The encryption is different than the ones used for the utilities and what you are doing is not supported so I doubt there is a utility to produce the encrypted password you are after.
Cheers
John
http://john-goodwin.blogspot.com/ 
Yes, I can see the password in the HSPSYS_DATASOURCE table but... it's not the same encryption as in the HBRPLUGINDATA table for the same user. I think this is the planning password ou a "planning" encryption of the password. The one I'm looking for is EAS' one.
The password I find in this table (HSPSYS_DATASOURCE) can be generated with a shell script installed with planning (in planning directory here : <HYPERION_HOME>\products\Planning\bin ?) that is called PasswordEncryption.sh (same name as the one I should find in the EAS directory).
Looking at the API doc, there is two different encryption class : one for planning (com.hyperion.planning.utils.HspPasswordEncryptionUtility) and one for essbase (com.essbase.eas.utils.Encryption)
So, same question as before, can anyone see if there is a PasswordEncryption.sh here : <HYPERION_HOME>\products\Essbase\eas\console\bin ?
Edited by: user7932427 on 2 avr. 2012 04:34 
I've been trying using the com.essbase.eas.utils.Encryption class but the result is not what i'm looking for. There must be another encryption used for passwords. 
by the way, it seems that the HBR Admin guide tells tu use the script I'm looking for when one want tu use "-p" option to specify a password file in the CmdLnLauncher command !

Getting ORA-06508 in APEX Listener Configuration

Hi,
I'm trying to configure the Apex Listener. After entering all required fields and clicking on "Apply" I'm getting the error messages listed below. This happens when trying both Basic and TNS Connection types.
ORA-06508: PL/SQL: could not find program unit being called
Unable to run page sentry in application 4500.
Thanks in advance for your help.
Edited by: user3654649 on Jun 14, 2011 11:32 AM
Edited by: user3654649 on Jun 14, 2011 11:33 AM 
Hi,
it seems the APEX Listener can connect to your database, so the error must be somewhere in your APEX configuration.
Could you please provide some additional information on your setup, e.g.
- Which database user did you configure your APEX Listener to use? Usually you would choose APEX_PUBLIC_USER.
- Which database version are you using?
- Which APEX version does your database have?
- Did you use some other web server before using APEX Listener? (Embedded PL/SQL Gateway or Oracle HTTP Server)
-Udo 
Hi,
Thanks for your answer.
The database user that I'm truing to configure the listener to use is APEX_PUBLIC_USER. the database version is 10.2.0.4. The APEX version is 4.0.2.00.07 and for this database I did not use Embedded PL/SQL Gateway or Oracle HTTP Server.
thanks. 
So, everything up to now seems to be correct. Now, second line questions:
- Did you encounter any problem in your APEX installation?
- Could you check if there is any invalid object in your APEX schema? (run apexvalidate.sql from your APEX installation package connected to that instance as sys)
- Which JEE container do you use?
- Did you deploy the images for APEX yet? And did you deploy it to the context you've configured as images prefix during your APEX installation?
-Udo 
I did not encounter errors in the APEX installation. I don't have any invalid objects in apex_040000 or flows_files schemas (I did select * from dba_objects where owner='APEX_040000' and status='INVALID').
I ran the apexvalidate.sql procedure and now when doing "select * from dba_registry;" I see APEX status as INVALID - however there are no invalid objects in apex_040000 or flows_files schemas.
When doing the installation I followed the Application Express installation guide Release 4 - specifically "Scenario 1: Downloading from OTN and Configuring the Oracle Application Express
Listener" and I ran the installation script as "#apexins APEXTBS APEXTBS TEMP /i/"
The images directory is under apex (apex/images) while apex is the root directory of the installation.
Is there anything that I should have done differently with the /i/ ? Should it be the physical location for the images (something like /oradata/apex/images) ? Another thing - I just noticed that APEX_040000 and FLOWS_FILES are both locked - can this have to do anything with the error I'm getting ?
Waht does it mean "configured as images prefix " ? Is there anything that should be done that is not listed in the installation guide ? Regarding the "JEE container " I don't know.
thanks. 
One more thing - When doing the configuration it prompts me to enter the images directory and to this I reply with the exact physical location.
Enter the path to the directory containing the APEX static resources
Example: /Users/myuser/apex/images
or press Enter to skip:
thanks. 
Hello Sue,
I ran the apexvalidate.sql procedure and now when doing "select * from dba_registry;" I see APEX status as INVALID - however there are no invalid objects in apex_040000 or flows_files schemas.I'm sorry, I forgot to mention that you have to add some parameters to the apexvalidate-Call. In the APEX 4.0.x-case, this would be
#apexvalidate.sql x x APEX_040000I guess this will either bring up errors or put the APEX entry in the dba_registry back to VALID.
In addition to checking for invalid objects and trying to recompile/... them in case there are hits, the validation routine also checks if all vital objects are really there. I'd expect some error should have been raised if you didn't call the procedure as noted above.
I ran the installation script as "#apexins APEXTBS APEXTBS TEMP /i/"That's correct. Are the tablespace APEXTBS and TEMP present and below their size limit?
Is there anything that I should have done differently with the /i/ ?No, that's the default value and fits perfectly in most cases.
Another thing - I just noticed that APEX_040000 and FLOWS_FILES are both locked - can this have to do anything with the error I'm getting ?No, that's the way it should be. These two schemas should never be active database users. When using APEX Listener, you use APEX_PUBLIC_USER to connect to the database.
Waht does it mean "configured as images prefix " ?+/i/+ is the images prefix in your case. As I see in your following post, you are running APEX Listener in standalone mode, so you don't have to care - it has unchangeable contexts +/apex/+ and +/i/+ which fits to your APEX installation.
To explain my question:
You can deploy the APEX Listener to a "full blown" application server (which I referred to as JEE-Container) instead of running in standalone mode.
In that case you have to provide a context containing your images that fits to that prefix.
- When doing the configuration it prompts me to enter the images directory and to this I reply with the exact physical location.That's where the context +/i/+ is mapped to in standalone mode. Everything's correct here as well.
So, after all, everything looks great. If there really hasn't been any error during the installation and the validation routine doesn't throw any error as well, I'd try a clean uninstall (drop FLOWS_FILES, APEX_040000 and APEX_PUBLIC_USER) and rerun the installation routine.
If that doesn't help, could you try to enable the EPG once just to check the APEX installation itself is fine? I really doubt this error is really related to the APEX Listener at the moment...
-Udo 
Hi Udo,
Thanks for your reply.
Running apexvalidate.sql with the suggested parameters did not produce any errors.
SYS#cwsrvsit> #apexvalidate.sql x x APEX_040000
Procedure created.
No errors.
SYS#cwsrvsit> SYS#cwsrvsit> SYS#cwsrvsit>
However the status is still invalid :
SYS#cwsrvsit> select comp_id,comp_name,status from dba_registry where comp_id='APEX';
COMP_ID COMP_NAME STATUS
------------------------------ ----------------------------------- ----------
APEX Oracle Application Express INVALID
Should I try a new installation ? Is it possible that something in the Java insrtallation is wrong ?
thanks again,
Sue 
Hi Sue,
I'm sorry, I just didn't have my APEX troubleshooting notes at hand when posting the previous comments. Now I found them I see I missed some other steps to restart the validation, but I tested the following to work on my testing environment:
set define '^'
set concat on
set concat .
set verify off
#apexvalidate x x APEX_040000
exec validate_apex;Result:
SQL> exec validate_apex
...Database user "SYS", database schema "APEX_040000", user# "46" 23:39:36
...Compiled 0 out of 2721 objects considered, 0 failed compilation 23:39:36
...234 packages
...227 package bodies
...426 tables
...12 functions
...19 procedures
...3 sequences
...439 triggers
...1177 indexes
...176 views
...0 libraries
...4 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 23:39:36
...Completed key object existence check 23:39:36
...Setting DBMS Registry 23:39:36
...Setting DBMS Registry Complete 23:39:36
...Exiting validate 23:39:36
PL/SQL procedure successfully completed.At the end of that block you see that the dbms_registry is set according to the result. So if your query
select comp_id,comp_name,status from dba_registry where comp_id='APEX';still returns "INVALID", I'd recommend to redo the installation.
Is it possible that something in the Java insrtallation is wrong ?I don't think so, as your APEX Listener is able to connect to the database, but the database is not able to produce the APEX workspace login page.
Sorry once more for not providing the correct troubleshooting script at once.
-Udo 
Hi Udo,
Thanks for your reply - it was very helpful. I dropped the AOPEX environment and did a reinstall - now I'm able to do the listener configuration without issues. My next question is - is there a way to do it in the background ? When doing it as "java [options] -jar apex.war" it depends on my session being connected. If I'm doing a CTRL+C the listener goes down. Is there a way to do the configuration in the background and keep it up and running ?
thanks again,
Sue 
Hi Sue,
When doing it as "java [options] -jar apex.war" it depends on my session being connected. If I'm doing a CTRL+C the listener goes down. Is there a way to do the configuration in the background and keep it up and running ?That's actually two different problems of the APEX Listener in standalone mode: One concerning the configuration to be persistent and one to let the APEX Listener run in background.
You can solve both problems by using a "full blown" application server to deploy the APEX Listener. But you can also do this in standalone mode.
Lets start with easier one - the configuration:
The APEX Listener stores its configuration in the "apex.home". By default, this is located in your TEMP-directory. So, depending on your environment, it might be gone after you logged out. You can configure the "apex.home" as a startup parameter and let it point to some directory that is persistent. You could just configure your APEX Listener once, shut it down, and copy the apex-directory to that directory and you'll never have to configure it again.
java -Dapex.home=<Path_to_your_non-temporary_directory> -jar apex.warThe second one might be a little more difficult, depending on your operating system.
If you use a Windows system, you'll find a solution description in the following message: {message:id=9606494}
On Linux systems, a simple solution might be to use a "screen" session. That doesn't really start the APEX Listener as system service, but lives as long as the screen session lives in the background and you can easily do this with a less privleged user. For a neat solution that even start/stop cleanly with your OS, I need to know which one you run your APEX Listener.
-Udo 
Hi Udo,
Thank you very much for your help - it worked.
After doing :
java -Dapex.home=/orabackup_iris2/export/apex_listener/home -jar apex.war and answereing all the prompts,
I did CTRL+C to stop the listener and then I copied the content (cp -R) of /orabackup_iris2/export/apex_listener/home to /orabackup_iris2/export/apex_listener
and the I ran :
nohup java -Dapex.port=8080 -Dapex.home=/orabackup_iris2/export/apex_listener -Dapex.images=/orabackup_iris2/export/apex/images -jar /orabackup_iris2/export/apex_listener/apex.war &
If you can please go over the steps above and see if it makes sense - I hope it's not just pure luck...
thanks again,
Sue 
Hi Sue,
it's not just luck, it definetly works that way.
Just some final remarks:
- There's no need to change/copy the contents from +/orabackup_iris2/export/apex_listener/home+ to +/orabackup_iris2/export/apex_listener+ in your case, as the first directory doesn't seem to be a temporary one.
- I'd recommend to put the java-call including parameters into a shell script and call that instead.
- nohup works fine for on-demand background processes. As you probably know it's not providing a "system service"-like functionality.
- nohup creates a default file for console output of the job it started. I'd recommend to redirect it to a named file and append all output.
So, your final setup would look as follows
start_apex_listener.sh
#!/bin/sh
java -Dapex.port=8080 -Dapex.home=/orabackup_iris2/export/apex_listener -Dapex.images=/orabackup_iris2/export/apex/images -jar /orabackup_iris2/export/apex_listener/apex.warnohup call
nohup /orabackup_iris2/export/apex_listener/start_apex_listener.sh >> /orabackup_iris2/export/apex_listener/apex_listener.log 2>&1 &If your question is answered, please mark this thread and any helpful or correct answer post accordingly.
-Udo 
Udo,
Thank you very much for all your help - my question is definiteley answer
All the best,
Sue
Edited by: Sue on Jun 19, 2011 6:25 AM 
Hi Sue,
I'm glad I could help you.
If you don't mind, you can mark "helpful" and "correct" answers in this thread. Especially in longer threads, this makes it easier for other people to find relevant posts.
Thanks,
Udo

Categories

Resources