Windows :: Unable To Find DLL Library File
Nov 21, 2012
We are getting below error....Our one package called orawpcom.dll library file.
ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
'/oracle9i/app/product/11.1.0.7.0inorawpcom.dll'.
ORA-06512: at "GFSAM.OAINVOKEDOUBLE", line 1
ORA-06512: at "GFSAM.ORDCOM", line 229
ORA-06512: at "GFSAM.ORDEXCELSB", line 450
ORA-06512: at line 43
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
Attach this orawpcom.dll file?
View 1 Replies
ADVERTISEMENT
Apr 1, 2010
I have 3 code files written in ProC. I have precompiled, compiled, tested them in my local environment (Windows) & they work fine. But when I try in real environment, AIX 5.3, I can precompile them. But when I try to compile & link them with the libclntsh library I get errors. I am using a Makefile but just for testing this is the command -
xlc oraProcs oraProcs.c test_curva.c lib_util.c -I $ORACLE_HOME/precomp/public -L $LIBPATH -l libclntsh.a
Error - ld: 0706-006 Cannot find or open library file: -l libclntsh.a
ld: open(): A file or directory in the pathname does not exist
where LIBPATH = $ORACLE_HOME/lib
library libclntsh.a exists in $ORACLE_HOME/lib & has the right permissions
I also tried removing the library libclntsh.a & recreating it using the command - genclntsh When I run this command I get this warning more than once -ld: 0711-783 Warning TOC overflow TOC size: 66888 Max size: 65536 genclntsh creates the library libclntsh.a, just not sure if these warnings damage the library file and are related to my link erros in some way.
View 2 Replies
View Related
Sep 20, 2010
version: 10.2.0.4
OS: windows server 2003
I am not able to delete one month old archive log file manually on windows which doesn't having info about the standby on v$archived_log view of primary database. the sequence were already applied to the standby database. It shows the status as deleted in v$archived_log. while deleting the file manually. it showing an error like another program or person is using it.
View 10 Replies
View Related
Oct 4, 2012
In my database smon tracefile was huge,now we want to delete the same,I also tried with ordebug operation but no use, delete tracfile which Smon generates.
View 5 Replies
View Related
Mar 14, 2012
While Running a Report through form i am getting this below error.
REP-0118 Unable to create a temporary file
But while running the same report in a windows 98 or windowsXp PC i dont get this error.
View 1 Replies
View Related
Oct 23, 2013
When I try to start lampp, I am getting the below error.
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/no-debug-non-zts-20090626/oci8.so' - libclntsh.so.10.1: cannot open shared object file: No such file or directory in Unknown on line 0
But I have libclntsh.so.11.1 in my system. Why it is searching for libclntsh.so.10.1?
View 3 Replies
View Related
Jan 25, 2010
I am using forms 6i with 10g data base. i have compiled a form in developer 6i after that when i open *.fmb file it is showing PDE-PLI018 Could Not find Library "form name". i have not attached any library in form.
View 4 Replies
View Related
Dec 1, 2008
I'm currently new to Oracle 10g SQL and I need to query a large library file.I need to find the different first keywords associated with references written by authors who have more than 10 references in the readings table.
View 4 Replies
View Related
Jul 16, 2008
We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.
We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?
We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .
View 4 Replies
View Related
Mar 30, 2008
I am trying to have sqlldr running against a file:
C:oratest20080318
Is it possible I get SQL*Loader-500: Unable to open file and 503 file not found just because the file name does not have an extension?
I can see that any file name I try it looks after whateverFileName.dat! Is there a way to have sqlldr working with files that do not have extensions?
View 22 Replies
View Related
Mar 22, 2011
why am i getting this?
SQL> SELECT TABLE_NAME,owner from dba_TABLES where TABLE_NAME in ('BSNL_ACCOUNT_DATA','BSNL_SERVICE_DATA','BSNL_PKG_DETAILS');
TABLE_NAME OWNER
------------------------------ ------------------------------
BSNL_ACCOUNT_DATA BPREAD
BSNL_SERVICE_DATA BPREAD
but the table exists
SQL> select count(*) from BPREAD.BSNL_PKG_DETAILS;
COUNT(*)
----------
3704
SQL> select TABLE_NAME,owner from dba_TABLES where TABLE_NAME='BSNL_PKG_DETAILS';
no rows selected
why is it showing no rows even if the table exists
View 3 Replies
View Related
Jul 15, 2011
I am creating database instance from template. I have specified the location of redo log files. When I run the dbca utility it does creates the redo log files in specified directory. But the installation fails . When I checked the trace file. it says unable to locate the specified file(redo.log). But when i check in directory they are created.
I am using windows 32 bit oracle 11g
View 1 Replies
View Related
Jan 31, 2013
Oracle 10g. I want to find which sql statement was blocking others.
I know the sid of the blocker but I am unable to find the sql statement of the blocker.Also, when I check enterprise manager top activity only shows the waiter.
I tried to run the queries from below link, but it only shows the information about the waiting session.
[URL]
How can I find the sql statement of the particular sid from history ?
View 3 Replies
View Related
Jan 8, 2011
Is oracle 10g availble for Windows 7, I downloaded oracle 10g from ORACLE'S website. The name of the file is "10203_ vista_ w2k8_ x86_ production_ db.zip" but when I m installing it, I m getting error at the very beginning regarding the system requirements failure.
below is the message which i receive at the PRODUCT-SPECIFIC PREREQUISITE CHECK
======================================
Checking operating system requirements ...
Expected result: One of 5.0,5.1,5.2,6.0
Actual Result: 6.1
Check complete. The overall result of this check is: Failed <<<<
Problem: Oracle Database 10g is not certified on the current operating system.
Recommendation: Make sure you are installing the software on the correct platform.
=======================================================================
[code]....
View 6 Replies
View Related
Apr 3, 2013
I installed Oracle 10g XE on windows7 to create a database i opened "start database command interface" and created an SID and followed some steps afterwards i am facing "TNS ADAPTER NOT FOUND"
View 7 Replies
View Related
Jun 26, 2012
I've been asked to configure RMAN on an existing Oracle 11g R1 database running on Windows Server 2003 (32-bit) & when I connect using RMAN client to the database instance, I'm getting the following error setting the Fast Recovery Area and don't know why:
C:>rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Mon Jun 25 14:39:45 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ORCL11G (DBID=825621007)
RMAN> shutdown immediate;
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
[code]....
RMAN-01007: at line 1 column 1 file: standard inputAccording to Oracle documentation, I appear to be entering the correct command sequence but it's not working for some reason..
View 6 Replies
View Related
Nov 21, 2012
Am getting the following error while connecting db from sql dev "network adapter could not establish connection vendor code 20"
FYI - database is up and running fine in sqlplus, and am not able to find the service in lnsrctl. As am using OIM db as service name while its showing CLRExtProc.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
ction
Start Date 21-NOV-2012 20:28:48
Uptime 0 days 0 hr. 27 min. 32 sec
Trace Level off
[code].....
View 2 Replies
View Related
Apr 20, 2012
how can i find the oracle patch on os window. oracle 10.2.0.1
i m using sql>opatch lsinventory but cant work.
View 10 Replies
View Related
Apr 21, 2011
I attempt to log to the Enterprise Manager via --> [URL] but I only receive the 'Page not found' error
As this is on a windows server I attempt to restart the service to no avail Also I try to start emctl start dbconsole - whcih also does not work
The Listener is up and running
If I issue a emctl status oms - I receive error Oracle Enterprise Manager 10g Grid Control not installed. Request Ignored.
with --> emctl status dbconsole
output is Oracle Enterprise Manager 10g is not running.
Logfiles:
Logs are generated in directory D:\oracle\product\10.2.0\db_1/ukedgas71.pcroot.com_OEMREP/sysman/log
Logfiles:
Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log
20/04/2011 15:06 10,297 emagent.log
05/06/2009 09:48 0 emagentfetchlet.log
05/06/2009 09:46 0 emdctl.log
20/04/2011 15:05 6,363,995 emoms.log
20/04/2011 15:14 29 OracleDBConsoleOEMREPexit.log
20/04/2011 15:14 188,284 OracleDBConsoleOEMREPsrvc.log
05/06/2009 09:46 4,383 secure.log
7 File(s) 6,566,988 bytes
Tracefiles:
Directory of D:\oracle\product\10.2.0\db_1\UKEDGAS71.pcroot.com _OEMREP\sysman\log
20/04/2011 15:14 1,418,777 emagent.trc
05/06/2009 09:48 0 emagentfetchlet.trc
28/11/2009 16:21 8,360 emagent_perl.trc
21/04/2011 11:12 2,060,670 emdctl.trc
20/04/2011 15:05 1,649,464 emoms.trc
5 File(s) 5,137,271 bytes
0 Dir(s) 3,274,207,232 bytes free
View 14 Replies
View Related
Jan 4, 2012
We are unable install oracle 10g client it is showing error error in writing directory c:Docume~1admin~1locals~1emporainstall2012-01-04_08-05-38PM. ensure that this directory is writable and has atlest 45MB of disk space . Installation cannot continue
View 3 Replies
View Related
Jan 10, 2007
I installed 10.2 client on Windows 2000 Terminal Server. I created the system dsn odbc connection. When connected to the terminal server via RDP as a domain administrator, the odbc connection functions appropriately. When connected to the terminal server console as a standard user, the odbc connection functions appropriately.When connected to the terminal server via RDP as a standard user, I get the error: "Unable to connect SQLState= IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"
I have reviewed the numerous other posts regarding this error and I've executed the following recommendations: My oracle_home is defined first in my path environment variable (path - c:oracleclientin;). I select my folder options (there is no security tab, windows 2000) I select sharing, then permissions. I allow 'Everyone' and 'Authenticated Users' full control, change & read permissions. I reboot the server.
View 4 Replies
View Related
Sep 25, 2012
Iam unable to kill one database session, Today i killed one session
alter system kill session '418,12499'
but status shows as killed but process still exits in OSLevel
SQL> select sid,serial#,status from gv$session where sid=418;
SID SERIAL# STATUS
---------- ---------- --------
418 12499 KILLED
we all know we can kill by using ORAKIL but still we unable to kill
SQL> select spid from v$process a, v$session b where a.addr = b.paddr and b.sid = '418';
SPID
------------
5644
i killed using orakill
C:Documents and SettingsAdministrator>orakill oraci 5644
Kill of thread id 5644 in instance oraci successfully signaled. but still process exits in os level also i notice below error in alert log
orakill: ssthreadkill(tid=5644) unable to get the thread list mutex: err=0
View 3 Replies
View Related
Jan 25, 2012
I am getting below ORA-01555 error in alert log everyday.
ORA-01555 caused by SQL statement below (SCN: 0x09ad.86a4562a):
Sat Jan 21 08:39:45 2012
SELECT (NVL(MAX(BLOCK_ID + BLOCKS ),0) * :b1 ) / 1024
FROM DBA_EXTENTS WHERE TABLESPACE_NAME = :b2 AND FILE_ID = :b3
I cannot able to find the sql_id here. So how can I find from which process or session this query is firing? before increasing the undo size, I need to analyze as why it is occuring?
undo_management string MANUAL
undo_retention integer 900
undo_suppress_errors boolean FALSE
undo_tablespace string
View 9 Replies
View Related
Jul 24, 2013
I was prompted by an error in the middle of Oracle 11g Release 2 installation and unable to continue further.
The error was file not found e:product11.2.0.dbhome_3oc4jj2eeoc4j_applicationsapplications em.ear.
View 2 Replies
View Related
Mar 28, 2012
I am trying to install Oracle 11g R2 on Windows 7 professional at the time of database creation they give error.
ORA-12638:Credential retrival failed.
View 9 Replies
View Related
Aug 30, 2013
I have been trying out the new 12c on Windows 2012 Essentials with the same type of errors. The OraDim step fails and cannot create the services. It fails a bit differently if I choose "Create New Windows User", choose a "Use Existing Windows User", or choose the Windows Built-in user.
View 3 Replies
View Related
Feb 28, 2013
1. On the Home Page, click the "Settings" wheel in the header of the Team Development region on the right side.
2. On the Home Page Preferences popup set "Show" to something else as "All" and click [Apply Changes]
3. Back on the Home Page, in the Team Development region on the right side, click the number next to "Bugs"
4. ERR-1002 Unable to find item ID for item "P3500_RELEASE" in application "4800".
View 0 Replies
View Related
Aug 11, 2010
The below Oracle Forms code works fine for Excel 2003/Windows XP/IE6 but doesn't work for Excel 2007/Windows 7/IE8.
*********************
application := Client_OLE2.CREATE_OBJ('Excel.Application');
Client_OLE2.SET_PROPERTY(application,'Visible','TRUE');
workbooks := Client_OLE2.Get_Obj_Property(application, 'Workbooks');
args1 := Client_OLE2.create_arglist;
************************
There is no error while executing the form, by debugging we found that the control skips all the above code.
I'm using Oracle forms 10.1.2.3 and jre 1.6.0_16.
View 3 Replies
View Related
Jun 17, 2011
I have a 11g database installed on a windows 2003 server. When I created the database I could not assign more than 2GB for SGA_TARGET where as I have 16GB of RAM available on the server. I created the database with SGA_TARGET as 1.5 GB and Memory_TARGET as 2GB. I could create the database successfully. Later when I again tried to increase SGA_TARGET to 6GB and MEMORY_TARGET to 8GB, I could not start the database. I got below error;
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command
Quote:I added /pae in the boot.ini
Added AWE_WINDOW_SIZE key to registry as 2000000000
Set use_indirect_data_buffers=true
added db_block_buffer=131072 (ie. 2GB DB_BLOCK_SIZE=16kb)
java_pool_size= 1000M
large_pool_size=1000M
shared_pool_size=2000M
I got again the same error
I could not use SGA_TARGET. So is AMM not allowed with AWE?
View 21 Replies
View Related
Jul 15, 2010
I am trying to compile a .pc file. I am working with Oracle 11gR1 and windows env. I am able to create .c file from .pc file. I am able to produce .o file from .obj file. But i am not able to link it and produce .exe. My installation does not contain / precomp /demo folder.
View 7 Replies
View Related