PUBS Database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mmidcap
    #1

    PUBS Database


    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 promptsqlplus 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
    Tags: None
    • michael ngong
      #2
      Re: PUBS Database

      mmidcap <member40221@db forums.comwrote in message news:<3386814.1 063904500@dbfor ums.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 promptsqlplus 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

        Comment

        • G M
          #3
          Re: PUBS Database

          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@db forums.comwrote in message news:<3386814.1 063904500@dbfor ums.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 promptsqlplus 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...

            Comment

            Previous template Next
            Working...