Two handy plug-ins with the update URLs that work with OEPE:
SQL Explorer – http://eclipsesql.sourceforge.net/
Subversion for Eclipse – http://www.polarion.org/projects/subversive/download/1.1/update-site/ http://www.eclipse.org/subversive/downloads.php
One of those things I ran across recently that I always forget between projects so I thought I would share here:
1 Set the Oracle Home
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
2 SQL Plus – Idle Instance $ORACLE_HOME/bin/sqlplus /nolog
3 Connect as SYS User
connect sys/welcome1@xe as sysdba;
4 Create the WEBLOGIC_PORTAL
User CREATE USER WEBLOGIC_PORTAL IDENTIFIED BY WEBLOGIC1;
5 Grant Roles and Permissions
GRANT CONNECT, RESOURCE,DBA TO WEBLOGIC_PORTAL;
6 The WLS install seems to expect a table named SYSTABLES, so you will need to create it:
CREATE TABLE SYSTABLES (TEMP NUMBER);