Re: First time DB install !Help! -- I'm so new it's sickening

"Andrew Falanga" <ccodewarrior_at_mailandnews.com> wrote in message news:3D134163.50508_at_mailandnews.com...
> Hi,
>
> The deal is simple. Aside from the fact that I knew the name,
> until this week I knew nothing of Oracle. This week, at my bosses
> behest I installed Oracle for the first time in my life. (My boss by
> the way, does know quite a bit about Oracle.)
>
> I'm installing the 9i release 2 database (I hope I said that right,
> I know it's 9.2.0 or something like that) on to a Red Hat Linux box.
> Here's the deal. After reading the installation guide. Well, ok, I
> didn't exactly read all 252 pages of it, but I read the through the
> requirements, adjusted my shared memory settings, IP settings and so
> forth as stated in the manual (and setup the scripts to adjust those
> settings on bootup), I installed Oracle.
>
> The install appears to be fine. However, I'm to a point where I'm
> installing the Oracle Management Server, and it's asking me for a
> username/password combination as well as service. I didn't set up
> (chose to defer until later) the Oracle Net Server. In this senario,
> the install program says to input service as <host>:<port>:<sid>. I've
> done this, and that's fine. However, I can't figure out what
> username/password to use.
>
> I tried the oracle user combination, but that didn't work. Said it
> was invalid. Just prior to getting to this window I had to give
> passwords to two users called SYS and SYSTEM. I've tried both of them,
> but it doesn't like them either. When I use the SYSTEM account I get
> invalid username/password. When I use SYS, it says that SYS should be
> specified as sysdba or sysoper. I then try sysdba or sysoper to no
> avail either.
>
> Is there a built in account that Oracle is expecting for this
> purpose? What is it? Does anyone have any ideas? By the way, I've
> tried to find the answer in the Installation Guide, but haven't found it
> yet.
>
> Thanks for any help,

I think knut has given you the answer you require, which is that you have to create a database user to own the OMS repositories database objects. This most certainly can be done by issuing the following when connected to sqlplus.

create user <name> identified by <password> default tablespace users
temporary tablespace temp;

grant connect,resource to <name>;

However , at least on windows platforms, there is an assistant that you can run which will create the user and the repository for you. It will require connection information (I use the system account) in order to do this. I suspect the assistant also runs on linux. You may already be running this.

I would create a tnsnames alias (using the net manager app) for the database and prove that you can connect using sqlplus and the alias first of all. then and only then would i run the configuration of the management server.

as for the users you encountered SYS is the owner of the data dictionary and (effectively) the great god of any oracle database. You should never connect as sys unless absolutely necessary. SYSTEM is the built in account for database administration type activities and is ideal for creating other accounts etc.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************