| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle DBA's should know this problem... HELP!!!!!!!!
It is really hard to give a solution to your problem, since I've never
used Personal Oracle before and I've installed Designer only couple of
times long time ago. And I have to say, that you don't give
overwhelmingly much information about your problem either. So don't
expect, that me (and possibly others) to find quick solution to those
problems you have described so far.
I give you some general advice, maybe you find it helpful.
Such a complex junk of software like Oracle client/server combo consists of several layers that all have to be installed and configured before they begin properly interact and work together. Take a look at the illustration below:
|User of the software | /|\ /|\
---+---------------------+ | | --+---------------------+
| Client software | | | | Oracle database |
O | (for example | | P | | server |
r | Designer 2000 | | a | | |
a |---------------------| | t | |---------------------|
c | SQL*Net (Oracle 7.x)| | h | | SQL*Net (Oracle 7.x)|
l | or | | | | or |
e | Net8 (Oracle 8.x) | | o | | Net8 (Oracle 8.x) |
|---------------------| | f | |---------------------|
| Oracle Protocol | | | | Oracle Protocol |
| Adapters | | d | | Adapters |
---+---------------------+ | a | --+---------------------|
O | Network protocols | | t | | Network protocols |
S | (for example | | a | | (for example |
| TCP/IP, SPX/IPX) | | | | TCP/IP, SPX/IPX) |
|---------------------| | | |---------------------|
| Low level network | | | | Low level network |
| protocols (like | | | | protocols (like |
| Ethernet) & hardware| | | | Ethernet) & hardware|
+---------------------+ +------------+ +---------------------+
| Physical network |
+-----------------------------------------------------+
If any of these layers is not working properly, then the whole thing is not going to work and user of the software starts getting weird error messages, like you did. To find out where is the problem area, you have to verify that all those layers work. Start with lowest level and go up layer by layer to the client software.
The good start is to check if you have a network interface card (NIC) installed :), cables plugged in and necessary drivers installed. Of course, in your case, it may be irrelevant, because you have client and server in the same computer and if you are using bequeath protocol, you don't have to worry about this network stuff. But since you are trying to use TCP/IP, the lowest level has to be in working condition too.
The most common network protocol is TCP/IP. The easyest way to make sure if it is working is just using ping. If you can ping the server computer, then this layer (and layers below it) are working. In your case you have to ping your own computer (ping localhost or ping 127.0.0.1). If you don't get any "request timed out" or other kind of errors then TCP/IP is OK.
Next verify that you have all necessary Oracle protocol adapters installed. Now comes the hardest part -- configuring the net8 and/or sql*net.
Client side first:
The necessary configuration files are in %oracle_home%/net80/admin
(net8) and %oracle_home%/network/admin (sql*net). There are two files,
sqlnet.ora and tnsnames.ora, in those folders. These are text files, so
you can edit them with any text editor. Of course, you can use some of
those configuration utilities (like 'net8/sql*net easy config'), but in
my opinion, they are crap. In tnsnames.ora there must be connect
descriptor for every database you are planning to use. For example look
at my tnsnames.ora:
dbalias.dbdomain =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.1.106)
(PORT = 1526)
)
(CONNECT_DATA =
(SID=JUKU)
)
If you are using tcp/ip and only one database then your tnsnames.ora should be quite similar to this, just change the alias, domain, host, port and sid to describe your database. You have to use the same port which the listener uses, host must be db-servers ip-address or alias and sid must be database sid.
Next check that your sqlnet.ora file has following parameters:
NAMES.DEFAULT_DOMAIN = dbdomain
NAMES.DIRECTORY_PATH= (TNSNAMES)
If you are using both sql*net and net8, then make sure that you copy
those files to both folders I've mentionned.
Server part.
You have to configure and start oracle network listener. You can do this
via Oracle Net8 Assistant. Just make sure, that there is under listening
location correct host and port and under database services there is your
database sid. Listener is necessesary when you are not using bequeath
protocol.
Then, if your database is running, you should be able to use your client software to access database. In the beginning, test the connection using tnsping (sql*net) and tnspin80 (net8), then try to log into database using both sql*plus73 and sql*plus80. If that succeeds, then everything is OK.
I hope that you are aware that before you can start using Designer you have to go through painful repository installing process. So RTFM.
Gee...If this is any help, you should buy me a beer next time I see you around...:)
"N. Steffens" wrote:
> > RIGHT! > > BUT... now the listener starts... I can connect with PL/SQL to my ORACLE > database (that's th one with TCP protocol).... but when I try to connect > with forms developer I get an windows error (dump) on NTTNT.DLL > > I have a version of 41 Kb from 15 May 1997. > What's wrong now??? > > thnx, > > Niels > > Juhan Kundla heeft geschreven in bericht <37B96A8C.B3DA6FF6_at_ensib.ee>... > >Those so-called tcp-ip protocols you installed from Oracle cd, are not > >network protocols but Oracle protocol adapters. You still have to > >install the tcp-ip protocol stack (if it is not already installed). You > >can check this out, if you click the network icon on control panel. > >There you should see amoung the other things properly configured tcp and > >ip protocols. If they don't exist (which, I think, is the case here) you > >have to install them from M$ Windows cd. > > > >
--
Ilusat suve...
\ | /
\ | /
-----( )-----
/ | \
/ | \
...ja päikest :)
Juku Received on Wed Aug 18 1999 - 15:21:47 CDT
 |
 |