This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes I installe oracle databse 11g. I want now to connect via sql PLUS but no success Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "I installe oracle databse 11g. I want now to connect via sql PLUS but no success" Watch "I installe oracle databse 11g. I want now to connect via sql PLUS but no success" New topic
Author

I installe oracle databse 11g. I want now to connect via sql PLUS but no success

gaspard douo
Greenhorn

Joined: Feb 12, 2014
Posts: 1
here is my TNSNAME.ORA
I wanted to connect like this: user: SYSTEM
password: oracle (this is a password I assigned for SYSTEM and SYS during instalation)
Host string: gaspal-8049e8e4 (Is this a real Host String to use ?)
But no success.

My database is started but I cannot connect. please help.


XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gaspal-8049e8e4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
sunil choudhary
Ranch Hand

Joined: Nov 10, 2000
Posts: 141

Did you try the following on the command prompt

sqlplus system/oracle@xe


whats the result you get back ?

"Learning is weightless, a treasure you can always carry easily." -Chinese Proverb
 
 
subject: I installe oracle databse 11g. I want now to connect via sql PLUS but no success
 
Similar Threads
Listener refused the connection with the following error: ORA-12505
Oracle Toplink Workbench - ORA-12505, TNS:listener error
Listener not being created
java.sql.SQLException
not able to connect with 10g