Oracle

Example of Creating a User in Oracle DB for WebLogic

Scott S NelsonLeave a comment

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);

Facebooktwitterredditlinkedinmail
© Scott S. Nelson

Just Like the Good Ole Days

Scott S NelsonLeave a comment

Back when 14.4k baud modems were fast, mice were beige, IBM made PCs, and new software versions were relased annually instead of weekly, software came with useful, intiutive manuals that included tutorials for everything you needed to get up and working.

Other than the ability to take the manual in its binder to the couch to flip through, dog ear and highlight, I was happy to discover a full set of training buried in the doc folder of the Oracle Database install (and many other of  their applications, though location may vary).

Even if you don’t have the full install, the 2 Day DBA and other really useful documents can be found online, too. The 10.2 version is located here:  http://www.oracle.com/pls/db102/portal.all_books.

Facebooktwitterredditlinkedinmail
© Scott S. Nelson