Lars Pind

internet software, coaching, and entrepreneurship

Lars Pind - internet software, coaching, and entrepreneurship
Check out Coach TV, my video blog on happiness and personal development for geeks.
← Sharing knowledge, sharing code Handy tool for installing OpenACS on Oracle →

Oracle Setup Statements

April 01, 2002 · 6 comments

Project name:
DB Password:
Oracle data path:

First, Connect

$ svrmgrl
$ connect internal

Alternatively:

$ sqlplus sys/<i>password</i>

Create Tablespace


Create User


Drop User


blog comments powered by Disqus

6 responses so far ↓

  • 1 Malte Sussdorff // Sep 24, 2002 at 07:57 PM

    Change in the tablespace create statement You might want to change to locally managed tablespaces and include a maxsize for Linux as well.

    create tablespace service_name datafile '/ora8/m02/oradata/ora8/service_name01.dbf' size 50m autoextend on next 640k maxsize 2147450880 extent management local uniform size 160K;

  • 2 Lars Pind // Sep 24, 2002 at 08:44 PM

    Done Thanks.

  • 3 Durgarao Sabbineni // Oct 28, 2002 at 08:51 AM

    how to Create the new database and new tablespace and new user? Please help me.

  • 4 Lars Pind // Oct 28, 2002 at 11:37 AM

    Have you tried the installation guide? http://openacs.org/doc/openacs-4/openacs.html

  • 5 Jeff Davis // Feb 20, 2003 at 02:18 PM

    dba_data_files A quick way to find out where oracle is putting its data files is to ask the server... 
    svrmgrl
connect internal
select * from dba_data_files;

  • 6 arief zj // Aug 13, 2003 at 01:15 PM

    Oracle 9i Is there a new oracle driver for oracle 9i ??