| How to connect to sqlplus [message #275428] |
Sat, 20 October 2007 00:39  |
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 #275438 is a reply to message #275428] |
Sat, 20 October 2007 01:38  |
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 |
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 |
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 |
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 #275499 is a reply to message #275428] |
Sat, 20 October 2007 21:08 |
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 |
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 #275526 is a reply to message #275512] |
Sun, 21 October 2007 01:38 |
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 #282425 is a reply to message #275526] |
Wed, 21 November 2007 23:54 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
