Re: Problem with 8i Client Installation

From: Beserko <beserkobob_at_yahoo.ca>
Date: Mon, 30 Dec 2002 23:15:29 -0500
Message-ID: <pan.2002.12.31.04.15.28.699884.4144@yahoo.ca>

It seems this tutorial
http://www.e-gineer.com/instructions/install-oracle9i-on-linux.phtml helped alot. The instructions to add the metadata screwed up a little, but in the end, this was the result :

SQL> ORACLE instance started.

Total System Global Area 97587500 bytes

Fixed Size                   450860 bytes
Variable Size              62914560 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes

Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Release 9.2.0.1.0 - Production JServer Release 9.2.0.1.0 - Production

Database "db1" warm started.

After that, something went wrong when I tried to create an user :

Database "db1" warm started.
[oracle_at_Rodan oracle]$ sqlplus /nolog <<!
> connect / as sysdba
> create user myuser identified by password;
> grant create session,create any table to myuser;
> grant unlimited tablespace to myuser;
> !

Of course, I didn't use "myuser" and "password".

SQL*Plus: Release 9.2.0.1.0 - Production on Lu Dec 30 23:08:10 2002

SQL> Connected.
SQL> create user myuser identified by password

*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace SYSTEM

SQL> grant create session,create any table to myuser

ERROR at line 1:
ORA-01917: user or role 'myuser' does not exist

What can I do ?

Thanks,

On Mon, 30 Dec 2002 08:29:29 -0500, JAE wrote:

> I try to install 8i Client Oracle on Win XP (Pentium 4) but the
> installer does not begin when double-clicking on it.
>
> Any idea
>
> I heard that there is a patch for installer on P4 but where can i found
> it
>
> Thank you for your answer
Received on Mon Dec 30 2002 - 22:15:29 CST

Re: Problem with 8i Client Installation - almost done !