Re: create user in solaris

You didn't say what versions of the products you're using, but the new enterprise manager has its own tnsnames file which you must update in addition to the regular Oracle tnsnames.ora. You would be able to ping and tnsping your servers but not be able to connect through enterprise manager if you didn't update the OEM tnsnames file. I'm currently able to connect one client to databases ranging from 7.2 to 8.1.5 running on NT, Novell and Solaris servers. These connections work both through enterprise manager and directly (svrmgr or SQL*plus) so it can be done.

Van

PS you can also make things work even if you choose not to use a management server or run any intelligent agents.

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:3810be30.53605269_at_news.demon.nl...
> 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 - 19:17:53 CDT