SQL 8.0 1

[Keyin99]

I want to enable students to use SQL Plus 8 on their Think Pads while at home and not networked.  I have been getting an error on trying to log on as "Scott" "Tiger".  I have used SQL on a local machine before but have missed something along the way.  Should I have a Web Server running first, then have the students copy the table script from the server?  Any suggestions would be a help

 

[carp]

What is the exact error message you are getting?

 

[carp]

Also, what OS?<br>

 

[Keyin99]

I'm using Win 95 and the error message is TNS-ORA 12203.&nbsp;&nbsp;Any ideas

 

[carp]

Keyin99 -<br><br>Here is a portion of a rather lengthy note I found regarding 12203.&nbsp;&nbsp;I just pulled the Windows chapter for you.&nbsp;&nbsp;Hopefully the answer is in here somewhere!!<br><br><br>Windows95 Windows98 Windows NT:<br><br>When troubleshooting ORA/TNS-12203 errors on Windows 95, 98, or NT, it will be <br>helpful to have a copy of the TNSNAMES.ORA file located in front of you.&nbsp;&nbsp;This <br>file is normally located in the ORACLE_HOME\NETWORK\ADMIN directory (or NET80\ADMIN).<br>If the file is not there, go to Chapter 6.<br><br>2-1.&nbsp;&nbsp;Go to, or log on to, the server where Oracle resides.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If you have a Windows NT server, go to section 2-2.&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If you have a Unix server, go to section 2-3.<br><br>2-2.&nbsp;&nbsp;Open a DOS window and type 'ipconfig' at the operating system prompt.<br>Your DOS window will show information similar to the following:<br>+-----------------------------------------------------------------------+<br>¦ Command Prompt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[_][-][X] ¦<br>+-----------------------------------------------------------------------+<br>¦ Microsoft(R) Windows NT(TM)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ (C) Copyright 1985-1996 Microsoft Corp.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ C:\&gt;ipconfig&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ Windows NT IP Configuration&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ Ethernet adapter El90x1:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IP Address. . . . . . . . . : 138.2.121.221&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Subnet Mask . . . . . . . . : 255.255.255.0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Default Gateway . . . . . . : 138.2.121.1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ C:\&gt; _&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>+-----------------------------------------------------------------------+<br><br>Write down, or note in the space provided, the 'IP Address' given.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-IP Address = ____.____.____.____<br><br>I'll be referring to this address throughout the paper.&nbsp;&nbsp;Continue to section<br>2-4.<br><br>2-3.&nbsp;&nbsp;At the operating system prompt, type 'hostname' and then grep for the <br>hostname in the /etc/hosts file.&nbsp;&nbsp;A sample screen shot will look like this:<br><br>+----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;---------------+<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ [otcsol1]/u06/home/nsupport&gt; hostname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ otcsol1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ [otcsol1]/u06/home/nsupport&gt; grep otcsol1 /etc/hosts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ 138.2.158.34&nbsp;&nbsp;&nbsp;&nbsp;otcsol1 loghost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦ [otcsol1]/u06/home/nsupport&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>¦&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;¦<br>+-------------------------------------------------------------+<br><br>Write down, or note in the space provided, the IP Address given.<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-IP Address = ____.____.____.____<br><br><br>You will be referring to this address throughout the paper.&nbsp;&nbsp;Please go to section<br>2-4.<br><br>2-4.&nbsp;&nbsp;Open your listener.ora file in a text editor.&nbsp;&nbsp;If you do not have a <br>listener.ora, skip to Chapter 6.&nbsp;&nbsp;What you are going to do will not be permanent, <br>but has to be done to resolve this error.<br>Replace the HOST name with the IP address in your TCP address block.&nbsp;&nbsp;For <br>example, if your listener.ora file resembles the following:<br><br>listener=<br>&nbsp;(address_list=<br>&nbsp;&nbsp;&nbsp;(address=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(protocol=ipc)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(key = dev1)<br>&nbsp;&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp;&nbsp;(address=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(protocol=tcp)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(host=otcsol1)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(port=1521)<br>&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp<br>startup_wait_time_listener=0<br>conect_timeout_listener=10<br>sid_list_listener=<br>&nbsp;(sid_list=<br>&nbsp;&nbsp;&nbsp;(sid_desc=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(sid_name = ORCL)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(oracle_home = /usr/product/oracle/7.3.4)<br>&nbsp;&nbsp;&nbsp<br>&nbsp<br><br>... then you want to change your listener.ora file to look like this (notice<br>the change in 'host'):<br>listener=<br>&nbsp;(address_list=<br>&nbsp;&nbsp;&nbsp;(address=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(protocol=ipc)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(key = dev1)<br>&nbsp;&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp;&nbsp;(address=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(protocol=tcp)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(host=138.2.158.34)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(port=1521)<br>&nbsp;&nbsp;&nbsp<br>&nbsp;&nbsp<br>startup_wait_time_listener=0<br>conect_timeout_listener=10<br>sid_list_listener=<br>&nbsp;(sid_list=<br>&nbsp;&nbsp;&nbsp;(sid_desc=<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(sid_name = ORCL)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(oracle_home = /usr/product/oracle/7.3.4)<br>&nbsp;&nbsp;&nbsp<br>&nbsp<br><br><br>If you are already using the IP address, and it matches the IP address you<br>found earlier, go to section 2-5. If not, make the change and save the<br>listener.ora file. Continue to section 2-5.<br><br>2-5. At the command prompt, restart the listener by typing 'lsnrctl stop' (if<br>you are on Windows NT running Oracle 8, type 'lsnrctl80 stop') followed by the command <br>'lsnrctl start' stop' (if you are on Windows NT running Oracle 8, type 'lsnrctl80 <br>start').<br><br>2-6.&nbsp;&nbsp;On the client, go to the command prompt and type 'ping &lt;IP address&gt;' <br>using the IP address of server you found earlier in this chapter.&nbsp;&nbsp;For example:<br><br>&gt; ping 138.2.158.34<br><br>You should get some response back stating that the ping was successful or<br>that the server is alive.&nbsp;&nbsp;If this is the case, continue to section 2-7.&nbsp;&nbsp;If<br>you get any errors, or messages stating that there was a timeout problem, or<br>that the host was unreachable, or the IP address was bad, contact your<br>network administrator and find out why you can't ping the server.&nbsp;&nbsp;This is<br>cause of your TNS-12203 error.<br><br>2-7.&nbsp;&nbsp;You have verified that you can physically contact the server and that the <br>listener is running.&nbsp;&nbsp;The next thing to do is verify the correctness of the<br>TNSNAMES.ORA file.&nbsp;&nbsp;Locate the TNSNAMES.ORA file.&nbsp;&nbsp;This file is usually in the <br>ORACLE_HOME\network\admin (or net80\admin) directory.&nbsp;&nbsp;Open the file in a text <br>editor.&nbsp;&nbsp;Make sure the HOST parameter for the alias you are trying to connect<br>with is set to the IP address of the server - rather than using the host name.<br>You also need to make sure the value of the PORT parameter in the tnsnames.ora<br>file matches the value of the PORT parameter in the listener.ora file.&nbsp;&nbsp;After<br>you've verified these two items, try a connection.&nbsp;&nbsp;If the connection still<br>fails, continue to section 2-8.<br><br>2-8. A lot of times, a person will unknowingly use an application designed for <br>SQLNet 2.3, but only have Net8 installed or vice versa.&nbsp;&nbsp;For example, if you <br>are executing PLUS33W.EXE, then make sure the TNSNAMES.ORA file is in the <br>network\admin directory.&nbsp;&nbsp;If you are using PLUS80W.EXE, make sure the <br>tnsnames.ora file is in the net80\admin directory.&nbsp;&nbsp;If you have a 3rd party <br>application and are not sure which directory the configuration files go in, <br>just place the tnsnames.ora file and sqlnet.ora file in both the network and <br>net80\admin directories. <br><br>2-9. We need to verify the file size of your WSOCK32.DLL.&nbsp;&nbsp;This DLL is the 32 <br>bit Winsock driver for the operating system.&nbsp;&nbsp;Use the table below to determine <br>if you are using the correct file:<br><br>Filename&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Location&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Size<br>------------+-------+---------------------------+--------------------<br>wsock32.dll&nbsp;&nbsp;&nbsp;Win98&nbsp;&nbsp;&nbsp;\windows\system&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;40k (40,960 bytes)<br>wsock32.dll&nbsp;&nbsp;&nbsp;Win95&nbsp;&nbsp;&nbsp;\windows&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;65k (66,560 bytes)<br>wsock32.dll&nbsp;&nbsp;&nbsp;WinNT&nbsp;&nbsp;&nbsp;\winnt\system32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20k (20,240 bytes)<br><br>If your wsock32.dll does not match the appropriate file as listed above,<br>then reinstall your operating system's TCP/IP stack.&nbsp;&nbsp;If your DLLs are okay, <br>continue to section 2-10.<br><br>2-10.&nbsp;&nbsp;There may be a syntactical problem with with the configuration files.<br>Please check the syntax as described in Chapter 6.<br><br><br><br>

 

[pram]

one of my student ask me how much data / records we can store in oracle ?

 

[loren256]

Pram,
As far as total data storage capacity, I cannot find the exact point of reference but I believe it is 512pterabytes for Oracle8i.

On a more practical note, I have the following Min and Max Database limits for you for Oracle8i (ref EXAM CRAM,Oracle 8 to 8i Upgrade,Coriolis,Freeman/Pack):

Format= type,minvalue,maxvalue;note.

DB block size,2K,32K;OS dependent.

DB blocks per datafile,2,2(22nd power)-1;platform dependent.

Control files,1,N/A

Control file size,N/A,20000 DB blocks

Database files per tablespace,1,1022;OS dependent

Data files per database,1,65533;dependent on OS,DB_BLOCK_SIZE,MAXDATAFILES,DB_FILES

Database file size,N/A,OS dependent;usually 4 million blocks

Maxextents,1,unlimited

Redo log files,2,;dependent on OS, MAXLOGFILES and LOG_FILES

Redo log file size,50K,OS dependent;usually 2GB

Tablespaces,1,unlimited

SGA size,N/A,2 to 4GB for 32-bit systems;more than 4GB for 64-bit systems.

Nested queries,0,255

Columns per table,1,1000

Columns per index,1,32;30 for bitmap indices

Indices per table,0,Unlimited

VARCHAR2 data type,1,4000bytes

NUMBER data type,-999...(38 9's)*10(125 power),999...(38 9's)*10(125 power)

LONG,N/A,2GB

BFILE CLOB BLOB,N/A,4GB

 

[vishnu]

Pram,

The data storage capacity for most of the recent releases of Oracle 8 is 512 peta bytes

 

[ELVIN]

Hi,all..

I'm having problems with the plus33w.exe file, it keeps appearing in the taskbar
whenever I start up Dataquery4. Well this isn't the problem, the real problem is that the file uses 99 cpu , and there for my computer gets really slow!
If anyone has an answer or any information concerning this problem please contact me at this forum or by my email enatrop@efss.dhl.com.