| FirsT Time Login Problem for Win 98 [message #1563] |
Mon, 13 May 2002 07:59  |
Tejas
Messages: 1
Registered: May 2002
|
Junior Member |
|
|
|
i am noT able To login SQL Plus 8.0.3.0.0 in win 98 whaT should i do.. i Tried all possible soluions. please help ... email me if possible
|
|
|
|
|
|
| Re: FirsT Time Login Problem for Win 98 [message #1607 is a reply to message #1586] |
Wed, 15 May 2002 21:33  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
From the Oracle Support site:
==============================================
Troubleshooting Guide: TNS-12203 Error
==============================================
......
Windows95 Windows98 Windows NT:
When troubleshooting ORA/TNS-12203 errors on Windows 95, 98, or NT, it will be helpful to have a copy of the TNSNAMES.ORA file located in front of you. This
file is normally located in the ORACLE_HOMENETWORKADMIN directory (or NET80ADMIN).
If the file is not there, go to section 6.
2.1. Go to, or log on to, the server where Oracle resides. If you have a Windows NT server, go to section 2.2. If you have a Unix server, go to section 2.3.
2.2. Open a DOS window and type 'ipconfig' at the operating system prompt. Your DOS window will show information similar to the following:
+-----------------------------------------------------------------------+
| Command Prompt [[_]][[-]][[X]]
+-----------------------------------------------------------------------+
| Microsoft(R) Windows NT(TM)
| (C) Copyright 1985-1996 Microsoft Corp.
|
| C:>ipconfig
|
| Windows NT IP Configuration
|
| Ethernet adapter El90x1:
|
| IP Address. . . . . . . . . : 138.2.121.221
| Subnet Mask . . . . . . . . : 255.255.255.0
| Default Gateway . . . . . . : 138.2.121.1
|
| C:> _
+-----------------------------------------------------------------------+
You will be referring to this IP address throughout the paper so you
may want to jot it down. Continue to section 2.4.
2.3. At the operating system prompt, type '/usr/sbin/ifconfig -a'. This command
will display the actual IP address of the server.
You will be referring to this IP address throughout the paper so you
may want to jot it down. Continue to section 2.4.
NOTE: The ifconfig command may be different of different Unix platforms.
A 'man' on ifconfig will inform you of the correct switches to use
in order to display the IP address.
2.4. Open your listener.ora file in a text editor. If you do not have a
listener.ora, skip to section 6. Replace the HOST name with the IP address
in your TCP address block.
If you are already using the IP address, and it matches the IP address you
found earlier, go to section 2.5. If not, make the change and save the
listener.ora file. Continue to section 2.5.
2.5. At the command prompt, restart the listener by typing 'lsnrctl stop' (if
you are on Windows NT running Oracle 8, type 'lsnrctl80 stop') followed by
the command 'lsnrctl start' (if you are on Windows NT running Oracle 8,
type 'lsnrctl80 start').
2.6. On the client, go to the command prompt and type 'ping <IP address>'
using the IP address of server you found earlier in this section. For
example: > ping 138.2.158.34
You should get some response back stating that the ping was successful or
that the server is alive. If this is the case, continue to section 2.7. If
you get any errors, or messages stating that there was a timeout problem, or
that the host was unreachable, or the IP address was bad, contact your
network administrator and find out why you can't ping the server. This is
cause of your TNS-12203 error.
2.7. You have verified that you can physically contact the server and that the
listener is running. The next thing to do is verify the correctness of the
TNSNAMES.ORA file. Locate the TNSNAMES.ORA file. This file is usually in the
ORACLE_HOMEnetworkadmin (or net80admin) directory. Open the file in a text
editor. Make sure the HOST parameter for the alias you are trying to connect
with is set to the IP address of the server - rather than using the host name.
You also need to make sure the value of the PORT parameter in the tnsnames.ora
file matches the value of the PORT parameter in the listener.ora file. After
you've verified these two items, try a connection. If the connection still
fails, continue to section 2.8.
2.8. A lot of times, a person will unknowingly use an application designed for
SQLNet 2.3, but only have Net8 installed or vice versa. For example, if you
are executing PLUS33W.EXE, then make sure the TNSNAMES.ORA file is in the
networkadmin directory. If you are using PLUS80W.EXE, make sure the
tnsnames.ora file is in the net80admin directory. If you have a 3rd party
application and are not sure which directory the configuration files go in,
just place the tnsnames.ora file and sqlnet.ora file in both the networkadmin
and net80admin directories.
2.9. We need to verify the file size of your WSOCK32.DLL. This DLL is the 32
bit Winsock driver for the operating system. Use the table below to determine
if you are using the correct file:
Filename OS Location Size
------------+-------+---------------------------+--------------------
wsock32.dll Win98 windowssystem 40k (40,960 bytes)
wsock32.dll Win95 windows 65k (66,560 bytes)
wsock32.dll WinNT winntsystem32 20k (20,240 bytes)
If your wsock32.dll does not match the appropriate file as listed above,
then reinstall your operating system's TCP/IP stack. If your DLLs are okay,
continue to section 2.10.
2.10 There may be a syntactical problem with the configuration files.
Please check the syntax as described in section 6:
...
...
section 6. Please go to the section that describes your problem:
6.1: You created the TNSNAMES.ORA file by hand and are unsure of syntax
6.2: You are missing your TNSNAMES.ORA file
6.3: You are missing your LISTENER.ORA file.
6.1: This section depicts 3 examples of a TNSNAMES.ORA file entry. The first
2 out of the 3 are created incorrectly.#---INCORRECT EXAMPLE 1---#DEV1.WORLD =
<TAB><TAB>(DESCRIPTION = <TAB><TAB><TAB>(ADDRESS_LIST =
<TAB><TAB><TAB><TAB>(ADDRESS =
<TAB><TAB><TAB><TAB>(COMMUNITY = SAMPLE_COMMUNITY)
<TAB><TAB><TAB><TAB>(PROTOCOL = TCP) <TAB><TAB><TAB><TAB>(HOST = <SERVER>)
<TAB><TAB><TAB><TAB>(PORT = 1521) <TAB><TAB><TAB>) <TAB><TAB>)
<TAB><TAB><TAB>(CONNECT_DATA = <TAB><TAB><TAB>(SID = <SID>) <TAB><TAB>) <TAB>)
#---INCORRECT EXAMPLE 2---#DEV1.WORLD = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (COMMUNITY = SAMPLE_COMMUNITY) (PROTOCOL = TCP) (HOST = <SERVER>)
(PORT = 1521) ) ) (CONNECT_DATA = (SID = <SID>) ) )#---CORRECT EXAMPLE---#
DEV1.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(COMMUNITY = SAMPLE_COMMUNITY) (PROTOCOL = TCP) (HOST = <SERVER>)
(PORT = 1521) ) ) (CONNECT_DATA = (SID = <SID>) ) )
6.2: Use Notepad or vi to create a tnsnames.ora file using the "correct
example" syntax in section 9-1. This file normally goes in the
ORACLE_HOMEnetworkadmin directory.
6.3: You can create the listener.ora file by using the sample below:listener=
(address_list= (address= (protocol=tcp)
(host=otcsol1) <-- the host name of your server
(port=1521) <-- what port you want the listener to listen on ) )
startup_wait_time_listener=0connect_timeout_listener=10sid_list_listener=
(sid_list= (sid_desc= (sid_name = ORCL)
(oracle_home = /usr/product/oracle/7.3.4) ) )
====
end
====
HTH,
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
