Home » RDBMS Server » Networking and Gateways » Host String,Username and Password Help (merged)
Host String,Username and Password Help (merged) [message #242906] Tue, 05 June 2007 08:11 Go to next message
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 Go to previous messageGo to next message
Maaher
Messages: 7062
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:\>
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
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 ?
Re: Host String,Username and Password Help ? [message #243757 is a reply to message #243748] Fri, 08 June 2007 15:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
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 ?




Go man download 10g after all 11g is on its way..


And please dont post/cross
Re: Host String,Username and Password Help ? [message #243758 is a reply to message #243748] Fri, 08 June 2007 15:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't start a new topic, continue on the previous one.

Regards
Michel
Re: 10g Host String,Username and Password Help (merged) [message #243803 is a reply to message #242906] Sat, 09 June 2007 02:05 Go to previous message
g.s1223
Messages: 17
Registered: May 2007
Junior Member
I downloaded 10g and istalled forms,reports and sql plus with it.
Still I'm not able to connect in SQL PLUS.tThese two errors occur in it.
1. Unable to relove service service name and
2. No listener
Plz Help
Previous Topic: Oracle Connection Manager Licensing
Next Topic: Error :12154 Could not resolve service name and No listener error
Goto Forum:
  


Current Time: Wed Dec 07 12:51:10 CST 2016

Total time taken to generate the page: 0.18570 seconds