| oracle configuration tools to be used for server database connection with client pc [message #665335] |
Thu, 31 August 2017 03:06  |
 |
adil shakeel
Messages: 47
Registered: August 2017
|
Member |
|
|
Hi all,
I am using oracle 10g xe Edition,
I want to ask which "Oracle Configuration Tool" should be used for making connection of oracle database installed onto the server, so that it runs onto the other client PCs which are connected to that Server.
The client systems have only form builders+form runtime plus reports builders+report runtime / compilers.
I have a wired network.
Please guide me with full procedure as how to generate the TNSNAMES.ORA file for client pcs and whether to use SQL Developer or any other tool like toad etc?
Please guide me.
|
|
|
|
|
|
|
|
| Re: oracle configuration tools to be used for server database connection with client pc [message #665344 is a reply to message #665341] |
Thu, 31 August 2017 07:44  |
John Watson
Messages: 8976
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Adil, these are simple tools with which anyone working with Oracle should be familiar. If you are not, you should perhaps consider whether to inform your client that you need assistance to carry out this task.
If you can't find the tools (where have you looked?) then you'll have to create the tnsnames.ora file by hand. There should be one in your Oracle XE home that you can use as a template. It might even function unchanged.
|
|
|
|
|
|
|
|
|
|
| Re: oracle configuration tools to be used for server database connection with client pc [message #665418 is a reply to message #665415] |
Tue, 05 September 2017 07:29 |
 |
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
adil shakeel wrote on Tue, 05 September 2017 05:45Or I think if I am making a mistake as to create the listener file which resides into the server system? Whether should I make some changes to that listerner file too, so as to run it successfully?????? If so then please also guide me about the changes to be made.
Why do you think you need to change the listener.ora at all? Most likely you don't even need it. The listener will quite happily start without a listner.ora and will use all default values, which is sufficient for 99% of all installations.
Show us the output of 'lsnrctl status', as executed on the database server.
Quote:
Second Option:
I addition to it, I have another option into my mind for solving this client issue.
that is :
Should I put the whole text of that TNSNAMES.ORA FILE HERE? And anyone please change it so that it fits for the client PC?
If it is possible for you then should I put the whole internal text of the tnsnames.ora here????????
To properly "fix" your tnsnames, we'd have to know about the rest of your network. But if you show it, and the output of 'lsnrctl status', we can probably help.
Please note that no one is going to do your job for you, but we will gladly try to help you to learn to do it for yourself.
|
|
|
|
|
|
|
|
| Re: oracle configuration tools to be used for server database connection with client pc [message #665452 is a reply to message #665424] |
Wed, 06 September 2017 06:51 |
|
EdStevens
Messages: 1376
Registered: September 2013
|
Senior Member |
|
|
adil shakeel wrote on Tue, 05 September 2017 08:19Quote: we'd have to know about the rest of your network
Quote:
What details I have to provide further?
Should I show you the WHOLE TEXT OF tnsnames.ora file? which resides into the server?
I so then I dont have any issue in disclosing that code out.
What details to provide?
Like I said, "Show us the output of 'lsnrctl status', as executed on the database server."
And "show us your tnsnames.ora".
And, on further review of this entire thread, the most fundamental thing of all -- an actual error message that you get from a failed connection.
As for your original question of "I want to ask which "Oracle Configuration Tool" should be used for making connection of oracle database installed onto the server, so that it runs onto the other client PCs which are connected to that Server.", the only "tool" you really need is a simple text editor like notepad. All of the oracle network connectivity configuration is in three files - listener.ora, sqlnet.ora and tnsnames.ora. listener.ora applies only on the server running the listener and is most likely not needed. sqlnet.ora is used on both server and client, and tnsnames.ora is used only by client processes. And all are clear-text files that can be maintainted with a simple text editor. I can't remember the last time I used netca, though it can be useful to get you started. YOu said you couldn't find netca, but it looks like you didn't look very well. Instead of "looking" where you think it should be, try using the search capability native to your OS. It's possible it did not get installed with a windows client, depending on what type of client (instant, runtime, admin) was installed. In any event, it WILL be on the db server. And since all it produces are simple text files, there is nothing to prevent you from using it there to create a tnsnames.ora that you can the manually edit (if necessary) and copy to the client.
You might find this article useful to give you a better framework of understanding. http://edstevensdba.com/oracle-tns/help-i-cant-connect-to-my-oracle-database/
|
|
|
|
|
|
|
|
|
|
|
|
| Re: oracle configuration tools to be used for server database connection with client pc [message #665496 is a reply to message #665495] |
Thu, 07 September 2017 07:46 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
[oracle@vbgeneric ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-SEP-2017 08:45:31
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 29-AUG-2017 10:10:11
Uptime 8 days 22 hr. 35 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service orcl12c
Listener Parameter File /u01/app/oracle/product/12.2/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/vbgeneric/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vbgeneric)(PORT=8081))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "49bff8a6bb912582e0530100007f8be4" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "4fe762cf3c871a73e0530100007ff9fb" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12c" has 2 instance(s).
Instance "orcl12c", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "orcl12cXDB" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Service "ords" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@vbgeneric ~]$ lsnrctl service
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 07-SEP-2017 08:45:43
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "49bff8a6bb912582e0530100007f8be4" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
Service "4fe762cf3c871a73e0530100007ff9fb" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
Service "orcl12c" has 2 instance(s).
Instance "orcl12c", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
Service "orcl12cXDB" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: vbgeneric, pid: 2983>
(ADDRESS=(PROTOCOL=tcp)(HOST=vbgeneric)(PORT=52831))
Service "ords" has 1 instance(s).
Instance "orcl12c", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:8 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@vbgeneric ~]$
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
It is not really possible to work in database administration unless you already have some knowledge of system administration, in this case a basic understanding of tcp/ip networking fundamentals. You have some studying to do! Enjoy the journey. It will interest you for the rest of your working life.