Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Posted on by



PL/SQL Developer will automatically find the Oracle Home directory and the corresponding oci.dll and tnsnames.ora file based on the Oracle Registry. Note that the 32 bit PL/SQL Developer version will only find 32 bit Oracle Client installations in the registry, and the 64 bit PL/SQL Developer version will only find 32 bit Oracle Client. I installed Oracle instant client 11.1 I am able to log into database using command prompt. It picks up the correct tnsnames.ora in folder C: oracle instantclient11 1 TNSNAME S.ora However, when i use an external tool such as TOAD or Pl/Sql developer it fails to pick up that tnsnames.ora. Oct 18, 2010 If you are using PLSQL developer to connect to the ORACLE database may have faced the problem ' SQL.Net not properly installed '. This problem occur beacause ORACLEHOME and the oci.dll path location may not have been configured in the preferences. To do this, go to ToolsPreferences. PL/SQL Developer connect to Oracle Database 32bit on the same computer. PL/SQL Developer connect to Oracle Database 64bit on the same computer. PL/SQL Developer connect to Oracle Database on another computer (your computer has installed Oracle) PL/SQL Developer connect to Oracle Database on another computer (your computer does not install Oracle). If Oracle Database (Release 11 or later) is also installed, a version of SQL Developer is also included and is accessible through the menu system under Oracle.This version of SQL Developer is separate from any SQL Developer kit that you download and unzip on your own, so do not confuse the two, and do not unzip a kit over the SQL Developer files that are included with Oracle Database.

Installing SQL Developer for Remote Access to Oracle 12g
(Fall 2020 configuration)

You can install SQL-Developer at home or on your laptop, and access the Oracle 12g server, without having to use client access tools in the labs. The procedure is as follows (Mac instructions are at the bottom of the page):

1. Download SQL-Developer to your computer

  • Download the SQL Developer software from the Oracle web site: https://www.oracle.com/tools/downloads/sqldev-v192-downloads.html). Keep in mind that Oracle keeps reconfiguring their website and this URL is not stable.
  • Oracle now releases products quarterly. The current version is 19.2.1. This version is installed in the labs.
  • Use the version with the JDK8 bundled in it (approx 490 MB).
  • Save it to a convenient location on your computer (e.g. C:SQLDeveloper).
  • You may need to create an account on Oracle to download the software.

2. Install the software

  • Unzip the files to the current folder.
  • See instructions on the Oracle website for how to proceed. These are not included here as they tend to change.
  • You may need to create a shortcut on the desktop manually. Ditto for including it in the list of All Programs.

3. Configure the software

    • Start the program by clicking on the program icon.
    • Right-click on the Connections icon in the left pane and select New Connection.
    • Use the following parameters for the connection – may vary by version):

Connection Name: orcl
Authentication Type: Default
Username: {your panther id}
Role: default
Password: {your Oracle/LSB password}
Save Password: {keep checked}
Connection Type: Basic
Role: default
Hostname: luboradb.ad.uwm.edu
Port: 1521
Service name: orcl.ad.uwm.edu

Your Oracle/LSB password is 12 characters and you would have received this is two installments (the first starting with alphabets, and the second starting with numbers). You must use this password to access Oracle. No other password will work. If you use any other password, it will treat it as an unsuccessful login attempt. After 10 unsuccessful login attempts, your Oracle account will be locked for 24 hours, and there is nothing that I can do to override this – this is an Oracle policy.

Alternatively, see the configuration screen below:

Remember that this is configured for you as a user and cannot be shared. If you expect to run this on a shared computer, then leave your Username and Password blank.

4. Using SQL-Developer

  • You can enter SQL statements in the Worksheet tab of the orcl pane, and either press function key F5 or use the Run Script button to execute the statements.
  • Note that SQL-Developer will likely not display times by default. You will need to use the TO_DATE function in the INSERT and UPDATE statements if you need to incorporate times into your data. Likewise, you would use the TO_CHAR function in the SELECT statements to display the times. Alternatively, you can alter the session to display times.

Mac Installation
If you use a Mac, then the instructions are a little different. Caveat: I do not have access to a Mac, so I am unable to verify these instructions.

  • Download the Mac OSX version (338MB) from the same page.
  • This version assumes you have JDK8 or JDK11 on your computer. If not, look through the Installation notes page as to how to obtain it, and which version to get.
  • Save the SQL-Developer for OSX zip file to your Downloads folder on your computer.
  • Double-click the SQL Developer icon in the Downloads folder to unzip it.
  • You can move the software to a different folder of your choice, if needed.
  • As with any downloads from Oracle, you may need to create an account on Oracle to download the software.


Similar Messages:
ADVERTISEMENT

Client Tools :: SP2-0310 / Unable To Open Temp File

Apr 14, 2012

when i run the script file 1.sqlIt throws me following error
SQL> @/c/temp/1.sql
SP2-0310: unable to open file '/c/temp/1.sql'

SQL & PL/SQL :: SP2-0310 - Unable To Open File When Running AWR Report?

Dec 1, 2011

When i run the awr report from sqlplus , i get below error message.
Quote:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
[code]////
Also i dont find the awrrpt.sql in the following path.
Quote:
$ pwd
/usr/local/oracle/product/9.2.0/rdbms/admin
$
$ ls -alrt awrrpt.sql
awrrpt.sql: No such file or directory
$
Is it something related to permissions on file ?

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key

Client Tools :: Unable To Open Oracle 9 ISQL Window In Internet Explorer 6?

Oct 12, 2010

I am unable to open Oracle 9 iSQL window in internet explorer 6. And i have two oracle version installed in my system are 9i and 10g.Now i am able to open the iSQL windows of 10g but not the 9i. It's happen after installing the Oracle 10g in system.
how i open both the iSQL windows in my system the Oracle 9i and 10g

Server Utilities :: Unable To Open File And 503 File Not Found

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?

Client Tools :: How To Open PL/SQL Developer With SQL WINDOW From Command Line

Sep 11, 2013

I am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:
I've tried:
'C:Program Files (x86)PLSQL Developerplsqldev.exe' userid=andrey/andrey@mydb
but it just opens the application with a connection, no file.
*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...
C:Program Files (x86)PLSQL Developerplsqldev.exe' userid=andrey/andrey@mydb 'C:Program Files (x86)PLSQL Developerandrey.sql'

Oracle

Client Tools :: ORA-01000 / Maximum Open Cursors Exceeded

Feb 7, 2011

I have a table by name DCODE.
I insert a row in it(TOAD) immediately after inserting it, if i try to delete it i am geeting an error saying ORA-01000: maximum open cursors exceeded.
I have tried to to solve this by increasing the value of OPEN_CURSORS. But still i get the same message.

Forms :: Unable To Open FMB File In Builder?

Jan 30, 2012

I am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message 'cannot open file'.
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.

Client Tools :: ORA-06413 - Connection Not Open Error Oracle On 64-bit Windows

Jul 11, 2013

I have newly installed Oracle 11g R2 64 bits to window 8 PRo 64 bits. Able to connection successfully Oracle NEt Configuration Assistant service name.
But when I try to connect it Toad 9.6 32 bits its show error message
ORA-06413: Connection not open

Export/Import/SQL Loader :: 500 Unable To Open File

Jun 24, 2013

Lots of email alerts reporting SQL Loader failures (the data is actually loading) but I want to prevent all these email alerts being fired. We have an SQL Loader script that is failing regularly with this error, however the data does end up in the tables so it must run subsequently succesfully the log files are cleared out quite quickly so it is difficult to track the errors. Why is there no filename just a.day reference in the error log file?
Below is the shell script I do not have much script experience, so I am unable to see how I can alter this...could I add some kind of exclusive lock check to see if I actually have access to the file before SQL Loader tries to Load it?
value used for ROWS parameter changed from 64 to 63 SQL*Loader-500: Unable to open file (/e2e_ms_xfer/cent01/.dat) SQL*Loader-553: file not found SQL*Loader-509: System error: No such file or directory SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
This is the full error log file SQL*Loader: Release 11.2.0.3.0 - Production on Sat Jun 15 12:17:38 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Control File: /tmp/e2e_load_ms_raw_coda.ctl Data File:
/e2e_ms_xfer/cent01/.dat Bad File: /tmp/e2e_load_ms_raw_coda.bad Discard File: /tmp/e2e_load_ms_raw_coda.dsc (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 50 Bind array: 64 rows, maximum of 256000 bytes Continuation: none specified Path used: Conventional Table MS_RAW_CODA, loaded from every logical record. Insert option in effect for this table: APPEND TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype -----------CODA_RECORD FIRST 4000 CHARACTER Terminator string :
[code]....

Server Utilities :: SQL Loader Unable To Open File Error?

Mar 9, 2012

I am recieving errors when trying to load the control file. The errors are as follows:
SQL*Loader-500 Unable to open file (homework.ctl)
SQL*Loader-553 file not found
SQL*Loader-559 SYstem error: The system cannot find the file specified.
My control file is located directly in the C drive (C:homework.ctl). The control file contains the following
LOAD DATA
INFILE 'c:country.dat'
APPEND INTO TABLE homework
fields terminated by ',' optionally encloded by ''
(country, month, day)
WHEN (month='April')
The command I am entering is:
sqlldr system/password control=homework.ctl
I've tried c:homework.ctl, 'c:homework.ctl', and placing the file in the BIN folder of Oracle.

Client Tools :: Unable To Run SQL *Plus?

Oct 5, 2012

I'm not able to run SQL *Plus on my machine. It is giving me below error.
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Setting of PATH environment variable is as below. If I remove below highlighted part I'm able to run SQL * Plus. I cannot remove this because it is required to run my application.
C:oracleproduct10.2.0client_1in;C:OSIBANKDLLBIN;C:OSIBANKBat_Exe;C:OSIBANKDLL;c:Program Files (x86)InteliCLS Client;c:Program FilesInteliCLS Client;C:Program Files (x86)AMD APPinx86_64;C:Program Files (x86)AMD APPinx86;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;c:Program Files (x86)Microsoft SQL Server90Toolsinn;%TFSPowerToolDir%;%BPADir%;C:Program FilesIntelIntel(R) Management Engine ComponentsDAL;C:Program FilesIntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsDAL;C:Program Files (x86)IntelIntel(R) Management Engine ComponentsIPT;C:Program Files (x86)IntelOpenCL SDK2.0inx86;C:Program Files (x86)IntelOpenCL SDK2.0inx64

Server Utilities :: Data Pump Error - ORA-39070 / Unable To Open The Log File

Nov 1, 2006

I'm getting an error when trying to use the new Data Pump Export/Import utility.
I am able to create a directory using SQLPLus, and I get the 'Directory Created' message, but no directory actually gets created on the server.
SQL> CREATE DIRECTORY datapump AS 'C:Inetpubdatafiledatapump';
Directory created. But I dont see the directory created on the server.
Then on the server:
C:Documents and SettingsAdministrator>expdp ******/****** FULL=y DIRECTORY=datapump DUMPFILE=expdata.dmp LOGFILE=expdata.log
Export: Release 10.2.0.1.0 - Production on Wednesday, 01 November, 2006 1:51:55
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at 'SYS.UTL_FILE', line 475
ORA-29283: invalid file operation

Pl sql developer oracle client not properly installed oracle home key chain

Client Tools :: Unable To Compile The Triggers?

Jan 15, 2013

i have huge sets of triggers, when i try to compile any one of those it notifies me with below error
Error: ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Client Tools :: Unable To Login Through TOAD

Aug 17, 2010

ORA-00604:error occured at recursive SQL level 1
ORA-20501:Warning: Login Using <UNAME> Prohibited, Please contact GSD/DB-Services
ORA-06512: at line 73
I'm encountering the above msg while connecting to oracle through TOAD. While connecting through SQL * Plus I find no issues.
I'm using TOAD for Oracle 9.0.1.

Client Tools :: Unable To Drop Roles

Jan 10, 2012

When I try to drop the roles in dbartisan tool, I get an error saying 'Drop DDL for **_***********_ROLE has not been generated because it is a system object', but if i go to sql prompt and say 'drop role rolename', it is working. How do I remove the role in dbartisan itself?

Client Tools :: Unable To Use Toad And PL/SQL Developer

Jun 17, 2010

Due to company restrictions, i unable to use oracle third party tools such as toad, pl / sql developer etc except oracle sql developers. I heard Oracle Developer Tools for Visual Studio is best option to work oracle pl/sql and sql.

Client Tools :: Unable To Connect To Database?

Oct 4, 2013

I am getting error in my database....
SQL> conn scott/tiger;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
I tried shutdown and startup
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 4 22:31:06 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL> shutdown;
ORA-01507: database not mounted
[code]....
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
SQL>

Client Tools :: Unable To Generate ERD For Specific Object

Dec 11, 2009

We are using erwin to generate Er diagram.But with that tool unable to generate the ERD for specific object.Or suggest any other tool from which i can generate the ERD of specific object.
i.e. Lets take an example.
I have a table with one primary key and 10 foreign keys. So now if i select the main table the tool should draw the ERD based on the Constraints ('P' and 'R') so all the different table which have the relation those table should only display. Right now we are getting all the tables ERD(more than 1500 tables) which is not neccesary.

Client Tools :: Unable To Connect To Oracle From Toad

Jul 28, 2010

I installed Oracle 10g XE and Toad 10.5 in my home system.I am able to connect to Oracle from Oracle XE homepage and XE SQL command line but when I try to connect to Oracle from toad 10.5 I am getting the error 'TNS: could not resolve the connect identifier specified (XE)'.From toad I tried direct and TNS options but it did not work. My tns ora file looks like below.
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Anu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
TNS_ADMIN variable has correct parameter and Toad is directing the correct TNS file. I tried changing hostname with my system's ip but still I am unable to connect to Oracle from Toad.

Client Tools :: Unable To Get All Views In Crystal Report

Nov 11, 2008

One of my developer creating views in his own schema,we are able to see that views from sqlplusw. But we are unable view them from crystal report tool(CRW32) ,Except this schema all are visible...

Client Tools :: Unable To View Table Names

Jun 28, 2012

i'm working on sql developer in that i'm able to access tables if particular table name is given..
i don't understand is there any grant role problem .

Client Tools :: Unable To Print Query Output On TOAD

Jan 24, 2012

When i run the below mentioned query(similar query)on TOAD. It will run without any errors and i can see 'PL/SQL Procedure successfully completed' in the task bar.....
However i am unable to see the output for the query.
print the the query output on TOAD ....
**** Sample Query Starts *****
DECLARE
i PLS_INTEGER;
BEGIN
SELECT NVL(i, 93)
INTO i
FROM DUAL;
--print i;
--dbms_output.put_line('i1: ' || i);
END;
**** Sample Query Ends*****
**** Actual Query Starts *****
-----------------------------------------------------------------
DECLARE
UnxDate number(6);
MyResult number(6);
Todaysdate date := TO_DATE('17-01-2012 00:00:00','dd-mm-yyyy hh24:mi:ss');
BEGIN
SELECT ROUND (Todaysdate - TO_DATE('01-jan-1970','dd-mon-yyyy') ) INTO UnxDate FROM dual;
[code]......

Client Tools :: Unable To Set Font For Japanese In Grid Option

Mar 9, 2011

I have TOAD Version 10.5.1.3, and i want to see the Japanese font, for that i tried changing view->toad options->display->Fonts to 'Arial Unicode MS' and selected Script as 'Japanese' and click on Apply and OK. But the Script option is automatically changed to 'Western' ( not to 'Japanese').
set the font script to 'japanese'

Client Tools :: Unable To See Database List In Dropdown Of PL/SQL Developer

Mar 27, 2013

I installed Oracle 11g client and set the ORACLE_HOME and tns_admin env variables.I installed the pl/sql developer, but unfortunately after installing , i am unable to see any database details in the drop-down list of pl/sql developer.

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).

Client Tools :: Oracle 10gR2 Database Server - Unable To Use Isqlplus?

Apr 11, 2007

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Crack

I have installed Oracle 10gR2 database server recently in the Windows box. The database works fine. But I am unable to connect through the Internet Explorer. I found that the service for the isqlplus is not available. Do I need to run any script for creating the service?

Client Tools :: Unable To Insert Euro Symbol In Database With Character Set WE8MSWIN1252?

Mar 29, 2011

I am using oracle 9.2.0.6.0 on HP-UX.
I am unable to insert and even display euro symbol from server as well as windows client.
Following are the details of my database server
SQL> select * from nls_database_parameters;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
[code]....
1) When I try to insert € from Db server (using putty) using Alt+0128 it does not print anything (nothing gets typed on the screen). Not even junk characters Also following query does not print anything
SQL> select chr(128) from dual;
C
-
2) while I set NLS_LANG on client and try to insert €, Alt+0128 produces a question mark symbol And following query displays junk character
SQL> select chr(128) from dual;
C
-
Ç
3) Regardless when I inserted couple of rows and tried UNISTR following was the result
SQL> select unistr(v) from t;
Error 45 initializing SQL*Plus
Internal error
$

Client Tools :: Unable To Paste Header (column) Names Result To Excel

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Key Lock

Jul 10, 2012

when i'm saving the result in excel sheet....results are saving but unable to paste column / header names.

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

Mar 10, 2010

Pl Sql Developer Oracle Client Not Properly Installed Oracle Home Keyless

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.