Re: create user in solaris

On Fri, 22 Oct 1999 21:25:41 +0200, Gabor Friedrich <gabor_at_internetaddress.com> wrote:

>i have an installed oracle server on a solaris-system. up to this time
>i has worked with an oracle-server on nt-systems. now i must create an
>database on the solaris. the connect between with the enterprise
>manager from the nt-system to the solaris machine i have not become to
>work.
>is there any idee to get this connection. i use an tcp network, and i
>can ping the computers.
>
>second how can i create an user on the solaris-oracle (i hav'nt any
>graphicly programs found, also i must use the command-line tools.)
>
>i get an error thats says that an tablespace user_data is not exist..
>
>the command:"CREATE USER "GABOR" IDENTIFIED BY "gabor" DEFAULT
>TABLESPACE "USER_DATA" TEMPORARY TABLESPACE "TEMPORARY_DATA" PROFILE
>DEFAULT ACCOUNT UNLOCK;
>GRANT "CONNECT" TO "GABOR";
>GRANT "DBA" TO "GABOR";
>GRANT "RESOURCE" TO "GABOR";
>GRANT UNLIMITED TABLESPACE TO "GABOR";
>ALTER USER "GABOR" DEFAULT ROLE ALL;"
>
>where is the error or how can i list the available tablespaces ??
>please help me..
>
>mfg Gabor

select tablespace_name
from dba_tablespaces;

What are the problems you are having with OEM? OEM is a bit NT-centric, but It should work! Is the Oracle Intelligent Agent working at the Solaris side. Are there two processes with dbsnmp.exe running on that server?
You could try to delete all .q files in $ORACLE_HOME/network/agent. Officially the agent should configure itself and those files can block it from doing that.

Hth,
Sybrand Bakker, Oracle DBA

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Oct 22 1999 - 14:47:34 CDT