Re: PUBS Database

From: G M <zlmei_at_hotmail.com>
Date: 19 Sep 2003 12:31:20 -0700
Message-ID: <50a5e6b6.0309191131.58b6c42c_at_posting.google.com>


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

HTH. Guang

mmidcap <member40221_at_dbforums.com> wrote in message news:<3386814.1063904500_at_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_at_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_at_diogenes
>
>
>
>
>
> CREATE TABLE AUTHOR...
Received on Fri Sep 19 2003 - 21:31:20 CEST

Original text of this message