| Installation /use of sqlplus with oracle 10g [message #16252] |
Thu, 18 November 2004 17:56  |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
I am a complete newbie at this. I downloaded oracle 10g and installed it. Now I dont know how to start using sql plus. I have received a script from a friend of mine that turns on services that oracle needs. I have being doing some reading on the net and certain environment variables need to be set?? I am so lost as to even start doing something in SQL please any help, link anything will help. (yes I am taking a course on it)
thanks for your time and patience
Maria
|
|
|
|
| Re: Installation /use of sqlplus with oracle 10g [message #16253 is a reply to message #16252] |
Thu, 18 November 2004 18:23  |
 |
Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
I am using 9i, but I imagine 10g is still similar. Are you using Windows? Hopefully, you installed the database server and not just the client.
If there is a SQL*Plus icon on your desktop, then click on that. If you don't have a SQL*Plus icon, then click on Start in the lower left-hand corner of your screen, then All Programs, then Oracle, then Application Development, then SQL*Plus. If you can't find that either, then search your system for the file sqlplusw.exe and start that file.
Either of the three methods above should get you to a logon screen that asks for a username, password, and host string. Hopefully, during installation, you were prompted for passwords for users like system and you remember or wrote down those passwords. Oracle usually also installs a user scott with password tiger. So, try entering scott in the user name box and tiger in the password box. You should be able to leave the host string box blank and have it go to the default database. Then click OK.
That should get you to the SQL> prompt. From there you can execute SQL commands and use edit to invoke the editor and create scripts and store them in .sql files, so you can run them.
Please let us know if you are able to accomplish all of the above and get to the SQL prompt.
|
|
|
|
| Re: Installation /use of sqlplus with oracle 10g [message #16254 is a reply to message #16252] |
Thu, 18 November 2004 19:09 |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
Well Iam running windows xp. All the services are running, I am even starting sqlplus as sqlplus /nolog and now I get the error of not connected
I followed the advice above, the symptoms sounds like I am forgetting to set something up
Please Help
Thanks for your time
Maria
|
|
|
|
|
|
| Re: Installation /use of sqlplus with oracle 10g [message #16258 is a reply to message #16256] |
Thu, 18 November 2004 19:41 |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
Microsoft Windows XP [[Version 5.1.2600]]
(C) Copyright 1985-2001 Microsoft Corp.
C:Documents and SettingsMaria>sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on Fri Nov 19 01:47:50 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> create NEW_TABLE(
2 maria CHAR(230)
3 )
4 ;
SP2-0640: Not connected
SQL> exit
C:Documents and SettingsMaria>sqlplus
SQL*Plus: Release 10.1.0.2.0 - Production on Fri Nov 19 01:48:43 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter user-name: scott
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
|
|
|
|
|
|
| Re: Installation /use of sqlplus with oracle 10g [message #16280 is a reply to message #16272] |
Fri, 19 November 2004 17:35 |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
I have fixed the installation problem. It was so simple. At the moment of installation I was not creating a Database so of course it wouldnt let me in by any means. I told you i was a newbie at this with no experience whatsoever. But thanks for your help and your time and your patience , specially to Barbara
Maria
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
