You want to connect to a University Oracle DB? The DBA of that Oracle server has to create a user ID and password for you to connect with. Then you use the Net8 Easy Config utility to create a new service name in order to connect to that server. Make sure you select TCP/IP protocol.
Do you also need to connect to the Personal Oracle DB that you installed? If so, you can probably connect using SQL*Plus and the user SYSTEM and password MANAGER. Do not enter a host string. The user SYSTEM has DBA privileges so you can create users and grant them whatever privs you want. Create a user for you as well and grant it DBA privs:
create user myuserid identified by some_easy_password;
grant dba to myuserid;
>I've installed Oracle8i Personel Edition, but I can not get it to
>do any thing.
>I went into Net8 Assistant, to set the connection, it fails.
>I then tried Net8 Configuration Assistant, that's doen't work.
>I can not get into SQL, it want's a name and passwork, I tried
> Scott, Tiger, no luck.
>What I want to do is set it up so I can connect to the Universies
> Oracle DB, I have the Net Service Name, Host Name, SID, and Port
> number.
>I have changed everything so much, nothing is working, can anyone
>help.
>Thanks Amy
Mark McCasland
Midlothian, TX USA