Oracle 11g - Got Error On PL/SQL Developer / Could Not Initialize

Nov 25, 2011

i install the PL/SQL developer version 9.0.3.1641 on Windows-7 64 bit...i have Oracle 11g on this computer.when i run PL/SQL i got this error:

initialization error
could not initilize "c:\.......oci.dll"

make sure you have the 32 bits oracle client installed..what i need to install and from where to download ? (can i have link to download)

View 1 Replies


ADVERTISEMENT

RAC & Failsafe :: Installation Error On Vmware - Failed To Initialize Cluster Registry

Nov 19, 2011

RAC installation on vmware is failing with following errors. I followed below link for installation. URL..... Found the following errors:

[root@rac2 ~]# cd /crs/oracle/bin/
[root@rac2 bin]# ./vipca
PRKR-1062 : Failed to find configuration for node rac1
PRKR-1062 : Failed to find configuration for node rac1
[code]....

The "/crs/oracle/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.The "/crs/ oracle/cfgtoollogs/configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.

[root@rac2 bin]# /crs/oracle/bin/racgons add_config rac1.localdomain:6200 rac2.localdomain:6200
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry
[root@rac2 bin]# /crs/oracle/bin/oifcfg setif -global eth0/192.168.2.0:public eth1/192.168.0.0:cluster_interconnect
PRIF-10: failed to initialize the cluster registry

View 8 Replies View Related

Connect To Oracle DB - Developer Error?

Apr 26, 2009

i've been trying to connect to the Oracle DB with Oracle SQL Developer.I get a message

State: Test Failed - IO Exception "The network adapter could not establish the connection"

When i go try tnsping 1521 It detects a connection by Oracle Database.And finally i get TNS-03505: Failed to resolve name

When i went into the "services.msc" and tryed to run the "OracleOraDb10g_home1TNSListener"

Got a message: "Error 3: The sytem could not find the specified path"

View 9 Replies View Related

Getting Error While Trying To Debug Procedure In Oracle SQL Developer

Apr 16, 2012

I tried to debug the procedure in Oracle SQL Developer and got the below error,

Connecting to the database TEST.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '****', '4000' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:operation timed out
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Process exited.
Disconnecting from the database TEST.

Here,

TEST is my database name,
**** is IP address of my local machine
4000 is the port number, also I have set the debug port range as 4000 - 4999 in SQL DEVELOPER.
firewall is not enabled in my machine.

View 2 Replies View Related

Forms :: Error While Installing Oracle Developer Suite 10g?

Jul 1, 2011

While installing Dev Suite 10g i got the following error:[URL] What should i do? I specified another oracle home name, i have oracle database 11g installed too, and i'm installing dev suite 10g on another location.

View 3 Replies View Related

Forms :: Error While Installing Oracle Developer Suite 10g 10.1.2.0.2?

Oct 11, 2011

When I try to install "Oracle Developer Suite 10g 10.1.2.0.2" on Windows 7, I'm getting error , " Install has encountered an error while attempting to verify your virtual memory settings. verify that the sum of the initial sizes of the paging files is atleast 256 MB."

View 4 Replies View Related

Client Tools :: 10g On Windows 7 - Unable To Initialize Oracle Call Interface

Oct 16, 2013

I work with oracle 10g, on windows 7. sometime when i try to start my sqlplus in prompt command this message display.

C:UsersSony>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

But the solution people have proposed into the forum are:

1 - check the environment variable Oracle_home and modify if it ending by ""

2 - or try tho run my promt command as Administrator.

I try the both, but only the second works. while now i don't understand why it works when i start the promt command as Administrator and why it no works when i don't run it like administrator. Another thing is i am the only user of my computer, i have only one session (administor session).

View 4 Replies View Related

Client Tools :: Database Won't Start / Unable To Initialize Oracle Call Interface

Mar 10, 2010

I am facing the problem in windows 7. I have oracle client 10g installed. When i run sqlplus from comand prompt it gives the error as:

C:Userssrirams>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

When I select the executable 'sql+' and run as administrator it works fine.

View 6 Replies View Related

Client Tools :: Connect With Sqlplus Or Toad - Unable To Initialize Oracle Call Interface

Sep 6, 2012

when i try to connect with sqlplus or toad then i get an error

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Users>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:Users>

and i want to tell what i do before it-my all files were be converted in .FLT then i shorted out this problem after that when i tried to connect with sqlplus or toad then i get above error.and i have restarted my system but throwing same error.

i am using oracle 11.2.0.1 on windows 7

View 5 Replies View Related

Error In PLSQL Developer

Dec 22, 2010

I have upgraded my Operating Syatem from Vista to Win7. I have SQL nav version but is not supported on Win7. So I have installed PLSQL developer. When I try to connect its giving the error connection not open. But when I tried the same credentials with SQLPLUS it's working fine.

View 3 Replies View Related

Getting Error When Try To Open PL / SQL Developer

Jul 3, 2012

i try to open PL/SQL Developer and i get this error:

Could not locate OCI dll
OracleHomeKey:SOFTWARE\ORACLE\KEY_OraOracle11g_home1
OracleHomeDir: d:\app\...................\product\11.1.0\client_1

what can be the problem ?

View 2 Replies View Related

Client Tools :: Getting Error While Connecting To DB In PL/SQL Developer

Dec 5, 2012

I am able to connect to the DB in TOAD , but I am not able to connect to the DB in PL/SQL developer.

PL/SQL developer

Version 8.0.1.1498
01.61091 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Oracle 11g

I am getting the below error

ORA-12154: TNS could not resolve the connect identifier specified

View 1 Replies View Related

Networking And Gateways :: ORA-12505 Error With SQL Developer

Jul 21, 2013

I installed oracle 11g successfully and was able to login with SQL plus.When I tried making a connection with the username and password via SQL developer I'm getting the ora-12505 error (picture is attached)

Printout of tnsname.ora:

# tnsnames.ora Network Configuration File: C:Oracle11gproduct11.2.0dbhome_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
ORACLE11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle11g)
[code]....

getting sql developer connected with my oracle database?

View 13 Replies View Related

Client Tools :: Error When Trying To Connect Sybase Through SQL Developer

Nov 17, 2012

I am getting bellow error message when trying to connect Sybase through Sql developer: status:failure-test failed:IO Error:The network adapter

View 1 Replies View Related

Client Tools :: ORA-12545 Error In PL/SQL Developer In Windows 7

Jul 16, 2013

I am using Oracle 11g version, and i am using plsql developer 7.1.I am able to connect Oracle through sql*plus, But i am not able to connect Oracle through plsql developer from past few days, it is giving me error like: ora-12545 connect failed because target host does not exist...I recently installed oracle dev_suite 10g client first and then i installed oracle 11g server in windows 7. Both tns files are having identical entries.

Please find the tns entries below.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPANIGR-IN)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
[code]....

View 7 Replies View Related

SQL & PL/SQL :: How To Initialize Array

Mar 5, 2010

I have written a pl/sql function. But it is returing null value. Because I have initialize pl/sql table. how to initialize it?

--------------
return v_list
As
type value_list is table of varchar2(100);
v_list value_list:= value_list()

[code]...

View 2 Replies View Related

Client Tools :: Closed Connection Error After Procedure Debug In SQL Developer

Feb 25, 2011

Oracle Database: Oracle 11g Version: 11.1.0.6.0
Tool: Oracle SQL developer. Version : 1.1.3

Problem:
After completing debug of procedure from SQL Developer, whenever I try to compile that procedure or execute any query from the SQL worksheet, I get the closed connection error message. However I can debug that procedure for any number of times. Any other activity for that database connection gives closed connection error.

View 2 Replies View Related

SQL & PL/SQL :: Initialize Variable With Whole Array

Dec 3, 2012

I'm having some hard times with attempts to initialize a set of values, Of a specific column from a table into a variable containing it as an array(like a single column table).

I've created & populated table TEST_TAB:

SQL>
SQL> CREATE TABLE "TEST_TAB"
2 ( "KEY1" NUMBER(10));

Table created.

SQL>
SQL> insert into "TEST_TAB" values ('1');

1 row created.

SQL> insert into "TEST_TAB" values ('2');

1 row created.

SQL> insert into "TEST_TAB" values ('3');

1 row created.

SQL> insert into "TEST_TAB" values ('4');

1 row created.

SQL> commit;

Commit complete.

SQL>
SQL>

Then I am trying to compile a function that gets a parameter - a number. The function should check whether this number exists in this list(return 1), or not(return 0).

I want to initialize key1 column of table TEST_TAB *into* v_my_array(this will be my list), just to see that I can have a set of values in this variable. Then I will want to see if the number is in that list, and return 1 or 0 accordingly.

I get the following error compiling, and can't seem to understand what's wrong:

SQL> create or replace function is_num_in_list (p_number number)
2 return number
3 is
4 TYPE varray_type IS TABLE OF NUMBER(10) INDEX BY PLS_INTEGER;
5 v_my_array varray_type;
6 begin
7 select key1 into v_my_array from TEST_TAB;
8 --if the number provided exists in the list, then 1(TRUE)
9 if p_number in v_my_array then
10 return(1);
11 else
12 --if the number provided *IS NOT* in the list, then 0(FALSE)
13 return(0);
14 end if;
15 end;
16 /

Warning: Function created with compilation errors.

SQL> show error
Errors for FUNCTION IS_NUM_IN_LIST:

LINE/COL ERROR
-------- -----------------------------------------------------------------
9/16 PLS-00103: Encountered the symbol "V_MY_ARRAY" when expecting one
of the following:
(
SQL>

View 2 Replies View Related

Forms :: FRM-18103 / Failed To Initialize Development Environment

May 27, 2010

Error - FRM-18103:Failed to initialize the Development Environment I have installed Oracle 11g and Oracle Developer Suite 10g in separate oracle homes.

When I try to open Oracle form builder I am receiving 'FRM-18103:Failed to initialize the Development Environment' error.

View 5 Replies View Related

C++ Call Interface :: ORA-01804 - Failure To Initialize Timezone Information

Jun 14, 2012

I am having an issue to connect my C++ application to my Oracle DB. When my code calls

oracle::occi::Environment::createEnvironment(),

I get an error "ORA-01804: failure to initialize timezone information".

The application works on other people's Windows machine with their Oracle DB. But it doesn't work from my machine connecting to their Oracle instance. So I guess the issue does not come from my instance but rather from my Oracle dlls maybe?

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0

View 0 Replies View Related

Reports & Discoverer :: Java Class For BarCode Failed To Initialize While Running At Web?

Aug 27, 2011

<jsp:useBean id="BC" scope="page"class="oracle.apps.barcode.util.BarCodeConstants" />
<jsp:useBean id="BM" scope="page" class="oracle.apps.barcode.BarCodeMaker" />

This code makes me unlucky while run that jsp report on web and comes up with orror no out put for the job.RegEdit REPORTS_CLASSPATH set to my oraclebarcode.jar with others jar files.

At Report builder web layout works fine [With Barcode generation] but not through Report server.

View 5 Replies View Related

Export/Import/SQL Loader :: Error During Data Pump Import With Developer

Sep 17, 2012

I try to transfer data from one database to another one through data pump via SQL Developer (data amount is quite important) exporting several tables. Tables export is doing fine, but I encounter the following error when I import the file (I try data only and data + DDL).

"Exception: ORA-39001: argument value invalid dbms_datapump.get_status(64...=
ORA-39001: argument value invalid
ORA-39000: ....
ORA-31619: ...

The file is in the right place, data pump folder of the new database. User is the same on both base, database version are similar.

View 4 Replies View Related

Oracle Developer 10g Installation

Feb 12, 2011

I have installed oracle form developer10g. without installing the oracle database. Oracle developer 10g can run independently.

I get the Error TNS: Protocol Adapter Error

My listener has the following:
# listener.ora Network Configuration File: D:DevSuiteHome_2NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = Oracle8)
(SID_NAME = ORCL)
[code].......

tnsnames.ora has following words:

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)

View 2 Replies View Related

Forms :: Java In Oracle Developer 10g R2

May 11, 2010

I am using oracle developer 10g R2. Now i would like to create a java(jar) function or any other type then would like to add this jar file into my oracle form with a button and when i run this and click on this button then display the message from java function.

View 1 Replies View Related

Windows :: Oracle Developer 6i And 10g On Computer?

Dec 2, 2011

How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?

View 1 Replies View Related

Windows :: Cannot Run Oracle Developer 6i Setup

Jan 24, 2002

Cannot run Oracle Developer 6i setup. Windows error message:

AppName: orainst.exe
AppVer: 0.0.0.0 ModName: oibknd32.dll
ModVer: 0.0.0.0 Offset: 0000ad41

View 11 Replies View Related

Forms :: Oracle Developer Suite 11g

Feb 17, 2010

I just upgraded our server to Oracle Fusion Middleware 11g with Forms and Reports and now I want to update the developers workstation too.

They have Oracle Developer Suite 10g R1 for the moment. The last version of Oracle Developer Suite is 10g R2 and I don't see anything for 11g. All I can find is that it's now in Fusion Middleware 11g and JDeveloper... But, from what I can see, JDeveloper is for Java development, not for Forms/Reports development.

So, do I need to use Oracle Developer Suite 10g R2 or is there a new version of it?

View 4 Replies View Related

How To Import Dmp File Through Oracle SQL Developer (3.2.20.09)

Nov 12, 2012

How to import *.dmp file Through Oracle SQL Developer (3.2.20.09) ? How to do it ?

View 3 Replies View Related

SQL & PL/SQL :: Text Mining With Oracle Developer?

May 19, 2012

I have a data set with these attributes

User IDQueryDateItem RankURL
26241powered by tofu t-shirt01/03/2006 23:595studentsforanimaldefense.org
898756from sad to raw01/03/2006 23:591fromsadtoraw.com
1322994white pages phone book01/03/2006 23:595numberway.com
1322994white pages phone book01/03/2006 23:591whitepages.com

I want to classify Query and URL Columns in Oracle SQL Developer.

I used built text, and make token for each column. but in classifications model couldnt continue.text mining in Oracle SQL Developer?

View 2 Replies View Related

Schema For Oracle Report Developer 10G Course

Nov 27, 2009

I took the course for "Oracle Reports Developer 10g" but I didn't copy the schema when I took the course.

Now,I have the book "Oracle Reports Developer 10g: Build Reports Student Guide" but I look over the internet and I can't find the schema for this course. I needed the schemas for the following tables:

CUSTOMERS
ORDERS
ORDER_ITEMS
WAREHOUSES
INVENTORIES
PRODUCT_INFORMATION
PRODUCT_DESCRIPTIONS
ONLINE_MEDIA
PRINT_MEDIA

where I can find the sql scripts for this schema ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved