What does Oracle XE perform during installation

configurationinstallationoracle

I have oracle11g2 installed on my noteobook.

I then installed the Oracle Database 11g XE. Now a .dll which uses the oracle11g2 client does not work anymore. First I recogniced that I had now two tnsnames.ora, which I resolved by linking the new one to the old one. But still my program cannot connect via the dll and throws an error.

I am relatively sure that the installation broke something which worked before so I need to know which steps the Oracle 11g XE installation procedure performs to system variable (like PATH) or to registry entries which might be important? Is there something like an installation log or can I somehow revert all changes which were done during installation?

My system is running Windows 7 x64.

Best regards, Fox

Best Answer

XE changes the following:

tnsnames.ora
Path variables
takes the default port 1521 for itself and this cannot be changed

The best way to install XE and other products is to install XE first, then any other Oracle version afterwards.

I think you can fix this by

examining the path variables by entering PATH at the command line
ensuring that each installation has a file path to the bin folder, something like this

c:\oracle\db11g\product\11.1.0\db_1\bin; c:\XE\product\11.1.0\db_1\bin;
check that the listener.ora has the correct parameters by starting a command line and entering lsnrctl status This will show you which listener is in use, it's location and what databases it is servicing.
change the port for the non XE database to anything other than 1521 in the listener.ora

Related Solutions

Windows – Import Oracle full dump file to fresh Oracle installation

If you are using the old imp method the users and tablespaces must be created first. This includes grants, database links and any advanced queues you may be using. A sample script could look like this in Windows imp a_DBA_user/apassword LOG =C:\dump\logs\import.log file =user01.dmp fromuser=user_name touser=user_name

The newer datapump method works wonderfully. You don't need to create the user but I would create any custom tablespaces you may have on the original.

A sample data pump call requires you to create a database link to the original database and a directory. This creates a directory

CREATE OR REPLACE DIRECTORY 
DATA_PUMP_DIR AS 
'C:\app\Oracle\product\11.2.0\dbhome_1\rdbms\log\';


GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO EXP_FULL_DATABASE;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO auser;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO IMP_FULL_DATABASE;

In your script to import set these variables NLS_LANG

ORACLE_SID= your database name

impdp a_user_who_exists/your database name directory=DATA_PUMP_DIR network_link=original database name schemas= user1,user2 LOGFILE=DataPump.log TABLE_EXISTS_ACTION=REPLACE

Sql-server – Sql Server 2008 x64 ODBC Linked Server to Oracle Not Working

If I try to right click on a view name and select Script -> SELECT To.... I get a message

The GUI is probably trying to access an Oracle Data Dictionary View (in order to read the column names & data types) that it does not have permission to select from, hence the error message.

Ask the Vendors Oracle DBA to trace the ODBC session so that you can track down the exact cause.

Best Answer

Related Solutions

Windows – Import Oracle full dump file to fresh Oracle installation

Sql-server – Sql Server 2008 x64 ODBC Linked Server to Oracle Not Working

Related Question