Re: Management Server

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 24 Apr 2001 06:27:41 -0700
Message-ID: <3AE57F4D.52AE6A4@exesolutions.com>

I'm not sure what or how you installed OEM so I can't help you with that no having a specific ORA-##### error message. But Oracle is not SQL Server. What you are trying to find doesn't exist. If you want to learn Oracle learn Oracle. Don't try to make it into a Microsoft product because you will fail miserably. So also forget ODBC ... at least for awhile.

In Oracle the front-end tool is SQL*Plus. To start it you need a user-id, password, and the host string from the tnsnames.ora file which as you probably did a completely default install is "oracle."

Try logging in as (user-id) sys, password (change_on_install), host_name (oracle) and if that works immediately issue the following:

SELECT tablespace_name
FROM dba_tablespaces;

then create a schema owner for the DDL you want to run.

CREATE USER invent_a_user_name
IDENTIFIED BY invent_a_password
DEFAULT TABLE choose_a_name_from_the_above_query_but_not_system_or_rbs_or_temp

TEMPORARY tablespace temp
QUOTA UNLIMITED ON the_tablespace_name_chosen_above;

now log in as the new user:

CONNECT new_user_name/new_password_at_oracle

Run your DDL.

Definitely buy a good book on Oracle and read the read-me files and megabytes of help files installed on your hard disk.

I know this is going to be a painful experience for you having to do all this work. But there is a reason why Oracle is the best RDBMS on the market. And you need to learn it the way it is used.

Daniel A. Morgan

Kenneth Jensen wrote:

> I have never used Oracle before, but now I have installed the Oracle
> Enterprise version. When I try to use the console in the Enterprise Manager,
> I am asked for the name of the Management Server. I have tried the DB name,
> the domain name and the network name of the computer, but nothing is
> accepted.
>
> I just want to view the tables in some kind of console and to have an ODBC
> access to the DB so that I can create some DDL on the DB.
>
> /Kenneth
Received on Tue Apr 24 2001 - 08:27:41 CDT

Re: Management Server - What?