| To access Oracle 7.3 using HP-Unix [message #161365] |
Fri, 03 March 2006 08:44  |
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
|
Member |
|
|
Dear friends,
Need Suggestion.
Can we access Oracle 7.3 which is using Unix10.2 through
Windows 2003 server ??
Do needful.
Rgds,
Sunidhi
|
|
|
|
| Re: To access Oracle 7.3 using HP-Unix [message #161468 is a reply to message #161365] |
Sun, 05 March 2006 00:21  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
question is not clear.
what is the operating system on which oracle 7 is running? is it unix or windows?
if you are connecting to the server directly, you can allways access oracle.
if you are on a client machine , and the database is on a different server, then you need oracle client set up(tnsnames.ora)
|
|
|
|
|
|
| Re: To access Oracle 7.3 using HP-Unix [message #161559 is a reply to message #161468] |
Mon, 06 March 2006 01:02 |
sunidhi
Messages: 36
Registered: January 2006
Location: New Delhi
|
Member |
|
|
Hello sir,
thanks for ur reply
I m using Unix 10.20 os OS for Oracle 7.3.
Need to access ORacle7.3 Which is on another Server ?
through Windows 2000 Server.
Please Tell me in Step by step a I m new to this field.
Regards,
Sunidhi
| niravshah wrote on Sun, 05 March 2006 13:21 |
question is not clear.
what is the operating system on which oracle 7 is running? is it unix or windows?
if you are connecting to the server directly, you can allways access oracle.
if you are on a client machine , and the database is on a different server, then you need oracle client set up(tnsnames.ora)
|
|
|
|
|
| Re: To access Oracle 7.3 using HP-Unix [message #161579 is a reply to message #161559] |
Mon, 06 March 2006 02:19 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
You need to configure your tnsnames.ora file.
The steps are:
click on:start->program->oracle-orahome92(or some other)->configuration and migration tool->Net configuration assistant.
once this net config assistant window comes,choose Local Net Service Name Configuration (3rd radio button),click next.
Click on the "Add" button, click next,
Click on the "Oracle 8i or later" and click next,
Enter the name of the database in the next text box,click next,
select TCP,click next,
give host name of linux server(or -if not available then its ip address)
click on yes, perform test..and it should succeed. if it does not, try to change the login and check username and password.
this all is related to configuring your tnsnames.ora file.
post back , if u get errors..
also, make sure that you are able to ping to your unix server (which has the database installed), from your pc(which has windows)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
