Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to install instant client, get error code 126

user1395450Feb 19 2014 — edited Mar 11 2014

On Windows Server 2008 R2, I have installed and extracted oracle instant client 12.1.0.1.0.  I have added to the existing path the location where sqoras32.dll resides.  Via the ODBC Data Source Administrator, when I attempt to add the driver to the System DSN, I get the following error

The setup routines for the Oracle in instantclient_12_1 ODBC driver could not be loaded due to system error code 126:  The specified module could not be found.

It then lists the correct path and filename for the sqoras32.dll resides.

Comments

Karthick2003
945400 wrote:
create index ts_portfolio_dm.instrument_ref_dim_indx1 on ts_portfolio_dm.instrument_reference_dim(instrument_type_dvd, revenue_source_dvd, pricing_dt, instrument_dim_key);

when I execute this command the process is taking too long to create an index .is there any additional coding that can help create index fast.
The time taken to create an index depends largely on the the volume of data in the table and number of columns being indexed.
fjfranken
Hi

You could add the "NOLOGGING" option.
This might speed it up a bit, because no redo logging is written for the index-creation. But it is only a small improvement

Your statement would then look like: 
CREATE INDEX ts_portfolio_dm.instrument_ref_dim_indx1
   ON ts_portfolio_dm.instrument_reference_dim (instrument_type_dvd
,                                               revenue_source_dvd
,                                               pricing_dt
,                                               instrument_dim_key) nologging ;
Maybe also add the PARALLEL clause to force parallel execution. But for the remainder I agree with the other reply. It is simply the amount of data that makes the time here
948403
Hi ,

thanks for the reply .

could you please give me the statement that contains both

1.parllel creation 2.no logging.

Is there any further improvements that can be done on this .
The table is very huge and lot of procedures use this .Hence the reson we are not able to allow the statement to execute for more time .
cheers,
P
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 8 2014
Added on Feb 19 2014
#odbc, #windows-and-net
2 comments
21,478 views