Home » SQL & PL/SQL » SQL & PL/SQL » Newbie SQL Plus question
Newbie SQL Plus question [message #223834] Sun, 11 March 2007 23:37 Go to next message
peterv
Messages: 3
Registered: March 2007
Location: Boston, Massachusetts
Junior Member
I'm experienced with SQL, but I'm a newbie when it comes to Oracle and SQL Plus. Today I installed Oracle9i (I know it's an older version, but I have books for documentation for this version). I selected the individual user installation. It went quite smoothly, and I thought everthing was fine until I attempted to sign in to SQL plus to do some practice. It asked me for a user id, password and host string. For the username I used my Administrator (which is what I'm logged into Windows 2000 as), my W2K password, and my machine name PETERV3 for the host string. This was guesswork, as I have no idea what userid SQL Plus is looking for. During the install, I wasn't prompted to select a userid, or a password. I don't know what is meant by host string either. Can anyone help me out with this? At this point, I'm wondering if I need to remove and reinstall Oracle to see if I missed something in the install.
Re: Newbie SQL Plus question [message #223849 is a reply to message #223834] Mon, 12 March 2007 01:41 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Try something like this from a DOS-window:

sqlplus "/ as sysdba"

sqlplus will try to log you on as sys (as a sysdba).
From there you can create some user and/or schema's in which you can build your "application"

Remember you are now logged in as a "super database user" (sys). This means that you can do a lot. But you can also do a lot wrong since there is nothing that you can not do.
Re: Newbie SQL Plus question [message #223868 is a reply to message #223834] Mon, 12 March 2007 02:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
peterv wrote on Mon, 12 March 2007 05:37
I selected the individual user installation.

Could it be that you just installed the client (no database)?
How long did the installation take you (approx.)?

O, and welcome to the board of course! Smile

[Updated on: Mon, 12 March 2007 02:52]

Report message to a moderator

Re: Newbie SQL Plus question [message #224061 is a reply to message #223868] Mon, 12 March 2007 16:50 Go to previous messageGo to next message
peterv
Messages: 3
Registered: March 2007
Location: Boston, Massachusetts
Junior Member
I installed the client without the database, but that shouldn't prevent me from logging into sqlplus should it? I thought I could create a database from within sqlplus. The installation only took about an hour.
Re: Newbie SQL Plus question [message #224062 is a reply to message #223849] Mon, 12 March 2007 16:54 Go to previous messageGo to next message
peterv
Messages: 3
Registered: March 2007
Location: Boston, Massachusetts
Junior Member
I tried your idea about logging on as SYSDBA, but I don't have the password for that either. What I need to know is where does Oracle get the password? It never prompted me for one during the installation!
Here's the output from the attempted login:

C:\WINNT>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 12 17:52:43 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name: sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\WINNT>
Re: Newbie SQL Plus question [message #224069 is a reply to message #224061] Mon, 12 March 2007 18:01 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
peterv wrote on Mon, 12 March 2007 21:50
I installed the client without the database, but that shouldn't prevent me from logging into sqlplus should it? I thought I could create a database from within sqlplus.

The CREATE DATABASE command requires the RDBMS software to be installed.

Creating a database is a different thing to installing the database software. There is no INSTALL RDBMS SOFTWARE command in SQL*Plus.

[Updated on: Tue, 13 March 2007 02:54]

Report message to a moderator

Re: Newbie SQL Plus question [message #224107 is a reply to message #224069] Tue, 13 March 2007 02:05 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
If it's just for learning purposes, I would recommend to install the 10g Express version. It's free and it's easy to install (basically next, next, finish and you have a complete installation, including a database).

As for the documentation: it's all out on the internet, so I would bother too much about that.
Previous Topic: package query
Next Topic: DBMS_JOBS
Goto Forum:
  


Current Time: Sat Dec 03 08:17:48 CST 2016

Total time taken to generate the page: 0.26780 seconds