Home » Other » Client Tools » How to connect to sqlplus
How to connect to sqlplus [message #275428] Sat, 20 October 2007 00:39 Go to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
I have full installed 9i. How could I be able to connect locally?
My school ID is.
username:dd12
password:dd12
host string = prod10g
I tried with the information above but never worked. Help will be appreciated.
Re: How to connect to sqlplus [message #275433 is a reply to message #275428] Sat, 20 October 2007 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

but never worked

Do you think this is a useful information?
Of course, it does not work otherrwise you didn't post.

You need no host string for a local connection, just set your ORACLE_SID.

Regards
Michel
Re: How to connect to sqlplus [message #275438 is a reply to message #275428] Sat, 20 October 2007 01:38 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Quote:

username:dd12
password:dd12
host string = prod10g
I tried with the information above

Where did you try?
I guess it was TOAD; in that case you shall add entry in your TNSNAMES.ORA for PROD10G.
But, as I do not know, what was the error message, the cause may be different.

[Edit] Noticed the post title just now, but, according to the provided info, I would (last time here, I promise) guess, original poster uses sqlplusw, as it shows similar login screeen.
Then I would try it to run with /nolog option and try connect using CONNECT command.
Or use sqlplus (without W in the end) and set ORACLE_SID, as Michel recommended.

[Updated on: Sat, 20 October 2007 02:29]

Report message to a moderator

Re: How to connect to sqlplus [message #275443 is a reply to message #275428] Sat, 20 October 2007 02:27 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Did you create a user dd12, or did you just use the same ID as you did at school?
What error do you get? "but never worked" is not a very helpful description of what happened.
Re: How to connect to sqlplus [message #275496 is a reply to message #275443] Sat, 20 October 2007 20:32 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
Frank wrote on Sat, 20 October 2007 02:27

Did you create a user dd12, or did you just use the same ID as you did at school?
What error do you get? "but never worked" is not a very helpful description of what happened.

I used the same Id from school. Error is ora-12560 tsn protocol adapter error.
I used sql plus
Re: How to connect to sqlplus [message #275497 is a reply to message #275438] Sat, 20 October 2007 20:32 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
flyboy wrote on Sat, 20 October 2007 01:38

Quote:

username:dd12
password:dd12
host string = prod10g
I tried with the information above

Where did you try?
I guess it was TOAD; in that case you shall add entry in your TNSNAMES.ORA for PROD10G.
But, as I do not know, what was the error message, the cause may be different.

[Edit] Noticed the post title just now, but, according to the provided info, I would (last time here, I promise) guess, original poster uses sqlplusw, as it shows similar login screeen.
Then I would try it to run with /nolog option and try connect using CONNECT command.
Or use sqlplus (without W in the end) and set ORACLE_SID, as Michel recommended.


sqlplus as username?
where is oracle_sid?
Re: How to connect to sqlplus [message #275498 is a reply to message #275428] Sat, 20 October 2007 20:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have full installed 9i.
What Operating System name & version?
What did you call/name (SID?) the database when you installed it?

>sqlplus as username?
sqlplus is the client utilty that allows you to communicate with the database.
The sqlplus utility is invoked from the COMMAND (CMD)/DOS window.

>where is oracle_sid?
If you don't know the SID, then NOBODY here can help you.

Nobody here knows whether or not the database is even up, online & available.

If this is too difficult for you, perhaps you should stay with using Microsoft ACCESS.


Re: How to connect to sqlplus [message #275499 is a reply to message #275428] Sat, 20 October 2007 21:08 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
# TNSNAMES.ORA Network Configuration File: C:\OraHome1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

DYANG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dyang7385)(PORT = 123))
)
(CONNECT_DATA =
(SERVICE_NAME = dyang)
)
)

still cant connect.
Re: How to connect to sqlplus [message #275500 is a reply to message #275498] Sat, 20 October 2007 21:10 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
anacedent wrote on Sat, 20 October 2007 20:52

>I have full installed 9i.
What Operating System name & version?
What did you call/name (SID?) the database when you installed it?

>sqlplus as username?
sqlplus is the client utilty that allows you to communicate with the database.
The sqlplus utility is invoked from the COMMAND (CMD)/DOS window.

>where is oracle_sid?
If you don't know the SID, then NOBODY here can help you.

Nobody here knows whether or not the database is even up, online & available.

If this is too difficult for you, perhaps you should stay with using Microsoft ACCESS.



i used windows xp pro. SID was never prompt on the installation.
i just wanna create a database locally and work on it.



Re: How to connect to sqlplus [message #275501 is a reply to message #275428] Sat, 20 October 2007 21:12 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
im getting a protocol adatper error.
Re: How to connect to sqlplus [message #275503 is a reply to message #275428] Sat, 20 October 2007 22:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i used windows xp pro. SID was never prompt on the installation.
You provided the SID during the installation

>i just wanna create a database locally and work on it.
I just want 1 Million US Dollars so I can retire.
We don't always get what we want.

Format the disk,Install Windows & then READ & FOLLOW this manual
http://download.oracle.com/docs/html/A95493_01/toc.htm

I hope you realize that nobody can see what you are actually doing.

You are complaining about errors, but do NOT show us using CUT & PASTE exactly what you are doing to generate the transliterated errors.

SQL*Net is NOT required to access a database on the local server.

Since we don't know what YOU are doing, we can't not tell what you are doing wrong.

You're On Your OWN (YOYO)!
Re: How to connect to sqlplus [message #275505 is a reply to message #275503] Sat, 20 October 2007 22:27 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
i cant format the disk.
i cant believe nobody can help to just connect locally to my sqlplus to do my homework. looks like there is no professinals here.

[Updated on: Sat, 20 October 2007 22:29]

Report message to a moderator

Re: How to connect to sqlplus [message #275512 is a reply to message #275428] Sat, 20 October 2007 23:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you don't like the timeliness, completeness, or correctness of any response you are entitled to a full & complete refund.

You have NEVER said/told/showed anyone here the commands you are issuing or the actual & COMPLETE error response.

You are now paying the price for NOT reading & following this Fine Manual before you did the initial installation:
http://download.oracle.com/docs/html/A95493_01/toc.htm

[Updated on: Sat, 20 October 2007 23:42] by Moderator

Report message to a moderator

Re: How to connect to sqlplus [message #275526 is a reply to message #275512] Sun, 21 October 2007 01:38 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
You cannot simply use your school-credentials to logon to your local database.
First of all, you do not have a prod10g, your sid is dyang
Second: you have to create a dd12 user first, before you can login as dd12.

Make sure your listener service and the database-service are started
Then open a dosbox and type this:
sqlplus /nolog <enter>
connect sys/<the_sys_password_you_provided_when_you_installed_oracle> as sysdba
grant connect, resource to dd12 identified by dd12 default tablespace users temporary tablespace temp;
exit

sqlplus dd12/dd12


Copy and paste the outcome of that here. (Add [code] ... [/code] tags around that piece, that will keep the formatting and keep it readable)
Re: How to connect to sqlplus [message #275741 is a reply to message #275526] Mon, 22 October 2007 10:00 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
I FIXED IT.
INTALLED 10G AND EVERYTHING WENT SMOOTH. CANT BELIVE 10G IS TRULY MORE SIMPLE THAN 9I...

[Updated on: Mon, 22 October 2007 10:03]

Report message to a moderator

Re: How to connect to sqlplus [message #275787 is a reply to message #275741] Mon, 22 October 2007 12:48 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The error is not in the software, or its acclaimed ease of use...
Re: How to connect to sqlplus [message #282425 is a reply to message #275526] Wed, 21 November 2007 23:54 Go to previous messageGo to next message
gongxia649
Messages: 11
Registered: October 2007
Junior Member
Frank wrote on Sun, 21 October 2007 01:38

You cannot simply use your school-credentials to logon to your local database.
First of all, you do not have a prod10g, your sid is dyang
Second: you have to create a dd12 user first, before you can login as dd12.

Make sure your listener service and the database-service are started
Then open a dosbox and type this:
sqlplus /nolog <enter>
connect sys/<the_sys_password_you_provided_when_you_installed_oracle> as sysdba
grant connect, resource to dd12 identified by dd12 default tablespace users temporary tablespace temp;
exit

sqlplus dd12/dd12


Copy and paste the outcome of that here. (Add [code] ... [/code] tags around that piece, that will keep the formatting and keep it readable)



when i type in sqlplus /nolog it says invalid user /password
Re: How to connect to sqlplus [message #282427 is a reply to message #282425] Thu, 22 November 2007 00:01 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Show it. Show us a screenshot of your session.
You did open a dosbox, like I said, right? You did not enter sqlplus /nolog in sqlplus itself?
Re: How to connect to sqlplus [message #282439 is a reply to message #282427] Thu, 22 November 2007 00:20 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@gongxia649: have you been hibernated for the last month?

[Pretend this is a "No message body" message]
Previous Topic: how to format table display in oracle
Next Topic: Problem retrieving varchar2 columns, different tools
Goto Forum:
  


Current Time: Thu Mar 28 04:52:05 CDT 2024