| Host String,Username and Password Help (merged) [message #242906] |
Tue, 05 June 2007 08:11  |
g.s1223
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
|
I'm a beginer and i'm using oracle sql plus 8.0 at my home need to find out what is the username,password and host string for sql plus 8.0 from the tnsnames.ora (plz give me some hint as to what to look in the tnsnames.ora)as scott/tiger and system/manger are not working.If sql plus 8.0 is not supported would it be fine to download 9i or 10g and use that sql plus which comes along with it ?
|
|
|
|
| Re: What to enter in Username,Password,Host string in Sql Plus 8.0 [message #242911 is a reply to message #242906] |
Tue, 05 June 2007 08:54  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Well, you first have to identify what databases you have access to. That information can be found in in your TNSNAMES.ORA file.
An entry looks like this:
NT817 = (DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=_your_host_)(PORT=1522)))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=_a_service_name_))
)
I'd connect using the "NT817" entry. That is my host string. But, if you want to check, you can do a "TNSPING"
C:\>tnsping NT817
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2
007 15:49:32
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=....)(PORT=1522))) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=....)))
TNS-12545: Connect failed because target host or object does not exist
C:\>
C:\>tnsping other_database
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2
007 15:50:59
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp
.world) (PROTOCOL = TCP)(Host = <an_ip_address>)(Port = 1523))) (CONNECT_DATA = (SID
= <blah>)))
OK (140 msec)
I can access my other database. The next step would be to get a usename, but first things first. 
Do you have a local database, or do you connect to a server? SQL*Plus is just a command line tool.
MHE
|
|
|
|
| Re: What to enter in Username,Password,Host string in Sql Plus 8.0 [message #243725 is a reply to message #242911] |
Fri, 08 June 2007 11:57 |
g.s1223
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
I'ma little confused because the TNSNAMES.ORA is found in these places in my disk.Pls suggest as to which one should i look?I will then check for the host string as you suggested.
1. win32/SQLNET/8_0_6_0_0-1181195/install/NET80/CLIENT
2. win32/SQLNET/8_0_6_0_0-1181195/install/NET23/CLIENT
3. E:\orant\NET80\ADMIN
4. E:\orant\NET80\TNSAPI
5. E:\orant\NET80\ADMIN\SAMPLE
6. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET23\CLIENT
7. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET80\CLIENT
I downloaded 6.0 and extracted it in F:/ and i ran the setup and installed it in E:/orant.
|
|
|
|
| Re: Plz Help?What to enter in Username,Password,Host string in Sql Plus 8.0 [message #243746 is a reply to message #242906] |
Fri, 08 June 2007 13:58 |
g.s1223
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
the TNSNAMES.ORA has the following :
==========================================================
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)
=================================================
As suggested I checked in the command by using tnsping..
C:\tnsping\Beq-local.world (also Beq-local)
I got the following error:
'TNSPING'is not recognised as an internal or external command, operable program or batch file.
=> I also tried to enter the Beq-local.world and
Tcp-loopback.world as host string and tried scott/tiger and system/manager with it. but i'm getting the following error
ORA-12154 :TNS :could not resolve service name.
Some one Plz tell me how to proceed further
|
|
|
|
| Host String,Username and Password Help ? [message #243748 is a reply to message #242906] |
Fri, 08 June 2007 14:17 |
g.s1223
Messages: 17
Registered: May 2007
|
Junior Member |
|
|
I'm a beginer and i'm using oracle sql plus 8.0 at my home need to find out what is the username,password and host string for sql plus 8.0 from the tnsnames.ora (plz give me some hint as to what to look in the tnsnames.ora)as scott/tiger and system/manger are not working.If sql plus 8.0 is not supported would it be fine to download 9i or 10g and use that sql plus which comes along with it ?
==================================================================
The reply what I got
Well, you first have to identify what databases you have access to. That information can be found in in your TNSNAMES.ORA file.
An entry looks like this:
NT817 =
(DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=_your_host_)(PORT=1522)))
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=_a_service_name_))
)
I'd connect using the "NT817" entry. That is my host string. But, if you want to check, you can do a "TNSPING"
C:\>tnsping NT817
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2
007 15:49:32
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=....)(PORT=1522))) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=....)))
TNS-12545: Connect failed because target host or object does not exist
C:\>
Here, I have no access to the database.
C:\>tnsping other_database
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-JUN-2
007 15:50:59
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = tcp
.world) (PROTOCOL = TCP)(Host = <an_ip_address>)(Port = 1523))) (CONNECT_DATA = (SID
= <blah>)))
OK (140 msec)
I can access my other database. The next step would be to get a usename, but first things first. Wink
Do you have a local database, or do you connect to a server? SQL*Plus is just a command line tool.
MHE
========================================================
My Reply :
I'ma little confused because the TNSNAMES.ORA is found in these places in my disk.Pls suggest as to which one should i look?I will then check for the host string as you suggested.
1. win32/SQLNET/8_0_6_0_0-1181195/install/NET80/CLIENT
2. win32/SQLNET/8_0_6_0_0-1181195/install/NET23/CLIENT
3. E:\orant\NET80\ADMIN
4. E:\orant\NET80\TNSAPI
5. E:\orant\NET80\ADMIN\SAMPLE
6. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET23\CLIENT
7. F:\Oracle_Forms\win32\SQLNET\8_0_6_0_0-1181195\install\NET80\CLIENT
I downloaded 6.0 and extracted it in F:/ and i ran the setup and installed it in E:/orant.
the TNSNAMES.ORA has the following :
==========================================================
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)
=================================================
As suggested I checked in the command by using tnsping..
C:\tnsping\Beq-local.world (also Beq-local)
I got the following error:
'TNSPING'is not recognised as an internal or external command, operable program or batch file.
=> I also tried to enter the Beq-local.world and
Tcp-loopback.world as host string and tried scott/tiger and system/manager with it. but i'm getting the following error
ORA-12154 :TNS :could not resolve service name.
Some one Plz tell me how to proceed further ?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
