Skip to main content

Posts

Showing posts from 2011

Oracle Enterprice Management Console

Hi - I got some useful tips regarding the management console. Speciall I used these commands when there was a requirement in changing my Server name. RECREATE EM REPOSITORY ====================== ################################################################################ # warning: 1. emca put database into quiesced mode, only DBA transaction # continues,the other waits, on production db there must be downtime # # 2. if some emca process fails, make a manual check and clean # - check OS processes,is java app running emca, RepManagerand,kill # # - is database in quiesced mode? # => SQL> select active_state from v$instance # => you can send # SQL> ALTER SYSTEM UNQUIESCED; # ################################################################################ emca help - see full syntax emctl stop dbconsole #To Drop emca -deconfig dbcontrol d...
Post a Comment
Read more

Tomcat fails to start due to Oracle XE blocking port 8080

Hi! I have ran across many instances that during Java development, that the engineers cannot startup their Tomcat server because the port 8080 is used by some other resource. It has been noticed that if Oracle XE was installed prior to tomcat, this has occurred. Possible Options to resolve 1) Change the connector port from 8080 to some other available port in Tomcat 2) Changing the Oracle APEX port from 8080 to some other. Method Please note that you may use either of these 2 options but only one option is required to resolve this issue. Most of the time it is very important to keep Tomcat port as 8080 so if that is the case you may use the 2 nd option. Option 1) Changing Tomcat Port go to "apache-tomcat-5.5.26\conf" inside tomcat installation folder. Edit "server.xml" file find Connector port="8080" you may change 8080 with some other available port number. Restart your tomcat. Option 2) Changing Oracle APEX port Logon to your XE database using sqlp...
Post a Comment
Read more