Re: how to do next?

From: Joel Sloan <jjs_at_c-me.com>
Date: Tue, 15 Dec 1998 20:38:04 GMT
Message-ID: <3676C910.1A3260E_at_c-me.com>

Sheng Juexin wrote:

> I have just installed a oracle8 on linux. I have never used oracle.
> I entered in " $sqlplus <cr> " , the system asks me enter user/passwd.
> But what kind user/passwd I must enter. I have try linux user account,
> but not work. I want to set a database so I can store and fetch data.
> How to do next? Ask for help.
> Thank you very much!

You will probably want to create a user account - assuming the user "dba" owns the oracle database

amber: /root
(ttyp2): bash: 1002 > su - dba

amber: /home/dba
(ttyp2): bash: 286 > svrmgrl

Oracle Server Manager Release 3.0.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation. All Rights Reserved.

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> select * from v$version;
BANNER

---

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
CORE Version 4.0.5.0.0 - Production
TNS for Linux: Version 8.0.5.0.0 - Production NLSRTL Version 3.3.2.0.0 - Production
5 rows selected.

SVRMGR> create user scott
     2> identified by tiger
     3> default tablespace users
     4> temporary tablespace temp;

Statement processed.
SVRMGR> exit
Server Manager complete.
amber: /home/dba
(ttyp2): bash: 286 >

You will find the Oracle literature (Oracle 8 DBA reference, etc) to be very helpful in these scenarios... Received on Tue Dec 15 1998 - 21:38:04 CET