| Which oracle version to install ? [message #178380] |
Tue, 20 June 2006 22:02  |
tony01
Messages: 3
Registered: June 2006
|
Junior Member |
|
|
Hi Everybody :
I have installed in my computer Oracle Client 9iR2 (on window XP), because I have to access the database server on remote location. The database server is not available all the time, it is available only for some hours during the day.
Now,I want to clone the schema(A92_Owner) that I use to build queries and create reports. This schema have many tables.
My question is :
Can I install Oracle 10g XE (Windows version) in the same computer (my computer has already installed Oracle Client 9iR2), so that I can export/import the whole Schema (A92_Owner) from the database server to my computer (Oracle 10g XE).
If it is not possible, how can I do that?
Thanks in advance.
Tony
|
|
|
|
|
|
| Re: Which oracle version to install ? [message #178623 is a reply to message #178380] |
Wed, 21 June 2006 21:35  |
tony01
Messages: 3
Registered: June 2006
|
Junior Member |
|
|
Hi Maaher:
I sucessfully installed Oracle XE, It works , but when I try to connect using Oracle client, it doesn't work (before installation oracle xe it was working).
I got an error message : ORA-12154:TNS:could not resolve the connect identifier specified.
What is wrong ?
I installed oracle xe on drive D, and oracle client is on drive C,
each one has a tnsnames.ora file in its directories.
How can configure tnsnames.ora files properly?
Thanks.
|
|
|
|
| Re: Which oracle version to install ? [message #178632 is a reply to message #178623] |
Thu, 22 June 2006 00:59 |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Well, you have 2 Oracle_Homes now. You want to connect from what client (because you have 2) to what database (an old existing entry in your old tnsnames.ora or the new XE)? Here's what I tend to do: I have one tnsnames.ora file with all entries in it and all other tnsnames.ora files point to that "master" file with the following notation:
ifile=<full_path_to_master_tnsnames>\tnsnames.ora That's the only line I've put in the regular tnsnames.ora files. Now I only have to maintain one file.
MHE
[Updated on: Thu, 22 June 2006 00:59] Report message to a moderator |
|
|
|
| Re: Which oracle version to install ? [message #178999 is a reply to message #178632] |
Fri, 23 June 2006 17:59 |
tony01
Messages: 3
Registered: June 2006
|
Junior Member |
|
|
Hi Maaher:
I can not connect to databse Xpress edition (XE).
It doesn't work I got error message:
ora-12154 TNS:Could not resolve service name.
However, I can connect to remote database from my oracle client 9.2.
What is wrong??
This is my master tnsnames.ora file with ALL ENTRIES, is located at C:\oracle\ora92\network\ADMIN\tnsnames.ora (This is the oracle client 9.2)
The second tnsnames.ora file from oracle XE is located at: D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora
The entry in this tnsnames.ora file is: ifile=C:\oracle\ora92\network\ADMIN\tnsnames.ora
Here below is the master tnsnames.ora file with all entries:
##FIRST PART TO CONNECT ON REMOTE DATABSE
ABC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.8.165.40)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ABC)
)
)
## 2ND PART- ORACLE XPRESS EDITION TNSNAMES.ORA
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xzhg-7f9f212521)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
[Updated on: Fri, 23 June 2006 18:08] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
