Comments on: APEX installation via the Oracle Protocol Server (listener) http://www.liberidu.com/blog/?p=122 About Oracle, XMLDB and other interests Tue, 31 Aug 2010 09:57:39 +0000 hourly 1 http://wordpress.org/?v=3.0.1 By: Part of the Puzzle: Oracle XMLDB NFS Functionality « AMIS Technology blog http://www.liberidu.com/blog/?p=122&cpage=1#comment-15404 Part of the Puzzle: Oracle XMLDB NFS Functionality « AMIS Technology blog Sat, 27 Feb 2010 21:14:15 +0000 http://www.liberidu.com/blog/?p=122#comment-15404 [...] the WebDAV definitions) like HTTP, FTP, Native Database Web Services (NDWS), PL/SQL Gateways like local APEX support, security, etc., [...] [...] the WebDAV definitions) like HTTP, FTP, Native Database Web Services (NDWS), PL/SQL Gateways like local APEX support, security, etc., [...]

]]> By: Marco Gralike http://www.liberidu.com/blog/?p=122&cpage=1#comment-8564 Marco Gralike Sat, 21 Jun 2008 10:05:38 +0000 http://www.liberidu.com/blog/?p=122#comment-8564 For me this is once again proof how important / how big an impact NLS settings can have. In this case it was easily fixed, although some times this can cause serious data corruption (seen a lot off those for instance in conjunction with something like “exp/imp”) or, “in the mild form”, only unnecessary CPU overhead. BTW this post was about APEX installation while making use of the local XMLDB Protocol Server and not as applied by you via Apache and the mod pl/sql. Be aware that also other daemons, like Apache, are dependable on environment settings like NLS_LANG setting. But I am glad you found the solution to your problem :-) For me this is once again proof how important / how big an impact NLS settings can have. In this case it was easily fixed, although some times this can cause serious data corruption (seen a lot off those for instance in conjunction with something like “exp/imp”) or, “in the mild form”, only unnecessary CPU overhead.

BTW this post was about APEX installation while making use of the local XMLDB Protocol Server and not as applied by you via Apache and the mod pl/sql. Be aware that also other daemons, like Apache, are dependable on environment settings like NLS_LANG setting.

But I am glad you found the solution to your problem

:-)

]]> By: Marco Gralike http://www.liberidu.com/blog/?p=122&cpage=1#comment-8563 Marco Gralike Sat, 21 Jun 2008 10:01:13 +0000 http://www.liberidu.com/blog/?p=122#comment-8563 <em>Ash replied via e-mail:</em> found the solution. When i turned on the PlsDebugEnable switch in the plsql.conf then I could see the error in more detail. Its to do with the NLS_LANG setting in the console that I was launching the opmnctl startall command. You have to set it to the same lang setting as in the dads.conf file . So I set mine to American_America... ( i.e export NLS_LANG=American_....) and then did opmnctl startall and all just works. Its all due to that. Ash replied via e-mail:

found the solution.

When i turned on the PlsDebugEnable switch in the plsql.conf then I could see the error in more detail.

Its to do with the NLS_LANG setting in the console that I was launching the opmnctl startall command.
You have to set it to the same lang setting as in the dads.conf file .
So I set mine to American_America… ( i.e export NLS_LANG=American_….) and then did opmnctl startall and all just works.

Its all due to that.

]]> By: Marco Gralike http://www.liberidu.com/blog/?p=122&cpage=1#comment-8537 Marco Gralike Fri, 20 Jun 2008 11:23:57 +0000 http://www.liberidu.com/blog/?p=122#comment-8537 You encountered a mayor problem. Have a look at http://ora-00604.ora-code.com. Have a look in the udump and bdump directories and check you "alert_$SID.log"-log database file. If needed contact Oracle support. You encountered a mayor problem. Have a look at http://ora-00604.ora-code.com. Have a look in the udump and bdump directories and check you “alert_$SID.log”-log database file.

If needed contact Oracle support.

]]> By: ash http://www.liberidu.com/blog/?p=122&cpage=1#comment-8536 ash Fri, 20 Jun 2008 11:06:41 +0000 http://www.liberidu.com/blog/?p=122#comment-8536 i installed Apex as above on Oracle 10g . However, when i restart the http server , i get ora-604 when i try and access the apex pages. Any one have any ideas how to resolve this and how to track down what causes it ? i installed Apex as above on Oracle 10g . However, when i restart the http server , i get ora-604 when i try and access the apex pages. Any one have any ideas how to resolve this and how to track down what causes it ?

]]> By: Marco Gralike http://www.liberidu.com/blog/?p=122&cpage=1#comment-320 Marco Gralike Wed, 04 Jul 2007 10:17:37 +0000 http://www.liberidu.com/blog/?p=122#comment-320 Reset of the admin password is easy via: SQL> conn / as sysdba Connected. SQL> @?/apex/apxxepwd.sql admin Session altered. ...changing password for ADMIN PL/SQL procedure successfully completed. Commit complete. Reset of the admin password is easy via:

SQL> conn / as sysdba
Connected.

SQL> @?/apex/apxxepwd.sql admin

Session altered.

…changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

]]> By: Marco Gralike http://www.liberidu.com/blog/?p=122&cpage=1#comment-313 Marco Gralike Mon, 02 Jul 2007 13:04:41 +0000 http://www.liberidu.com/blog/?p=122#comment-313 Read also: http://forums.oracle.com/forums/thread.jspa?threadID=486649&start=0&tstart=0 Read also: http://forums.oracle.com/forums/thread.jspa?threadID=486649&start=0&tstart=0

]]>