PUBS Database

[mmidcap]

Hello,

I'm trying to install the PUBS database on my WIN2000, using SQL*PLUS
(Oracle8i), but I can't get it to work. I don't think I have everything
I need, but then I don't even know where to put the script file I have.
I've saved the script in almost every sub-directory of the oracle
directory, and the oracle directory itself. Then I'll run the following
from the cmd prompt> sqlplus pubs/pubs@diogenes. I receive the following
error "ORA-12154: TNS:could not resolve service name" Below is the first
part of the file (before it creates the Tables). What am I doing wrong?

Thank you in advance for you help.

Mindy

---script...

drop user pubs cascade;

create user pubs identified by pubs;

alter user pubs default tablespace users;

alter user pubs temporary tablespace temp;

grant dba to pubs;

connect pubs/pubs@diogenes

CREATE TABLE AUTHOR...
--
Posted via http://dbforums.com

[michael ngong]

mmidcap <me*********@dbforums.com> wrote in message news:<33****************@dbforums.com>...

Hello,

I'm trying to install the PUBS database on my WIN2000, using SQL*PLUS
(Oracle8i), but I can't get it to work. I don't think I have everything
I need, but then I don't even know where to put the script file I have.
I've saved the script in almost every sub-directory of the oracle
directory, and the oracle directory itself. Then I'll run the following
from the cmd prompt> sqlplus pubs/pubs@diogenes. I receive the following
error "ORA-12154: TNS:could not resolve service name" Below is the first
part of the file (before it creates the Tables). What am I doing wrong?

Thank you in advance for you help.

Mindy

---script...

drop user pubs cascade;

create user pubs identified by pubs;

alter user pubs default tablespace users;

alter user pubs temporary tablespace temp;

grant dba to pubs;

connect pubs/pubs@diogenes

CREATE TABLE AUTHOR...

Except I am missing something
You are trying to connect to diogenes not PUBS
Is PUBS created already ?

Michael Tubuo Ngong

[G M]

You need to start the listener (or called listener service on PC).
Also make sure your listener.ora file is configured.

HTH.

Guang
mmidcap <me*********@dbforums.com> wrote in message news:<33****************@dbforums.com>...

Hello,

I'm trying to install the PUBS database on my WIN2000, using SQL*PLUS
(Oracle8i), but I can't get it to work. I don't think I have everything
I need, but then I don't even know where to put the script file I have.
I've saved the script in almost every sub-directory of the oracle
directory, and the oracle directory itself. Then I'll run the following
from the cmd prompt> sqlplus pubs/pubs@diogenes. I receive the following
error "ORA-12154: TNS:could not resolve service name" Below is the first
part of the file (before it creates the Tables). What am I doing wrong?

Thank you in advance for you help.

Mindy

---script...

drop user pubs cascade;

create user pubs identified by pubs;

alter user pubs default tablespace users;

alter user pubs temporary tablespace temp;

grant dba to pubs;

connect pubs/pubs@diogenes

CREATE TABLE AUTHOR...