Unanswered: 8i Personal Edition Questions (New User)
I am a new user of Oracle8i and have a few questions on the setup. I picked a typical installation and everything seems to have installed fine. Using SQL*Plus I created a new user and gave it all of the roles and priveledges for the sample databases set up for users scott and demo. I verified the privileges and roles through the 8i Navigator. However, when I log in with my newly created user, I can not access the sample db tables.
I log in using the GUI that has user, pass, and connection string. I thought maybe I needed to use ORCL as the connection string, but then I get an error.
In addition to this problem, I can not get my listener or TSN set up properly for Net8. I left everything on defaults, and when I go to test it it fails. I am trying to run it on a computer that is not connected to the internet, but which I set up a local network.
I read through most of the documentation on the disk to try and solve these problems, but couldn't find any "working" answers. Perhaps someone here can help.
Try connecting with username/password, don't specify the database name. For a default personal Oracle installation this should work.
(I think the ORCL name is not in your tnsnames.ora, that's why it won't work)
For you to see the tables, do you specify OWNER.TABLENAME ?
If scott owns table EMP, as another user you must do select * from scott.emp
(Or create a synonym CREATE SYNONYM EMP for SCOTT.EMP)
I created public synonyms for all of the tables. At first, the synonyms for scott were not working...then I realized that I used STEVE.Tablename to create the synonyms!?! I think I'm going to get a book on Net8 configuration because I can't seem to get the listener to work no matter what I try. Can anyone recommend a good book, or tell me how they set up a local listener on their computer?