Re: sql+ help

Phil Thompson wrote:

> hello,
> i have a copy of oracle 8i. I only know how to use SQL+, as this is all I
> have ben taught at university so far.
> when i try to open sql+ on my (windows 98)PC it asks for a username,
> password and host string. everything i try doesnt let my open sql+. at no
> point have i setup a username, so is there a default that i don't know
> about? any help would be great.
> thanks
> Phil

We don't know how you set things up, so any advice could go wrong ... unless reset, the default username/password are SYS/CHANGE_ON_INSTALL, SYS/MANAGER and SCOTT/TIGER. Third piece of information is the database identifier - in a totally default install that might be ORCL.

(Recommendation: avoid SYS - that's the system owner and messing around there could break the database totally; SYSTEM is the main administrator useful for management and creating new users; SCOTT is the demo userid. While you are learning, stick with SCOTT.)

On Oracle's TechNet site (http://otn.oracle.com) you will find a number of useful things:

1. Access to all the documentation, by clicking on the 'Documentation' link. You are encouraged to review the Concepts manual as the information could help you formulate the questions and understand the responses in this group, even if your set up is significantly different.
2. Access to tutorials and demos, by clicking on 'Sample Code' link. The Oracle By Example section in Sample Code While they tend to be oriented towards Oracle9i, there is a lot useful information you should be able to leverage to 8i.