|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
April 19th, 2004, 05:28 AM
|
|||
|
|||
|
How to get the service name in sqlplus
I have database there I can log in on the server and use the sqlplus to administrate the database (eg I got the database name and the password). The problem is that I want to administrate it from TOra and then I need the service name. How do I get hold of the service name through a sql-query (or something else)?
Cheers, Tomas Fält
|
|
#2
April 19th, 2004, 05:44 AM
|
||||
|
||||
|
Please clarify, you can logon to an Oracle server with SQLPlus, so you input 3 parameters, (Username, Password, Host string) use them in TOra.
If your problem is that TOra is on your machine and the SQLPlus you are using is on the database server, you need to add an entry in the tnsnames.ora on your machine, copying from the one on the server.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
April 19th, 2004, 06:43 AM
|
|||
|
|||
|
No, I logon only with the database name and password (on the database server there I've logon as root) using sqlplus. But I don't have the service name which I need if I going to add the database to my tnsnames.ora. So the question is how do get hold of service name on the database server.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > How to get the service name in sqlplus |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
