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 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).
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.
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.
I have TOAD 8.6 installed and hoping to use with Oracle 10g databases. I have SQL Navigator also - it works fine. However TOAD does not. Open up TOAD and see the TNS dropdown, select a database and try to log in - click on Connect and the little SQL hour glass comes on, goes off - there is no error, no message and no connection. I have tried several databases and again, SQLPlus, SQL Navigator are both working fine.
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?
I try to login as SYS@sid AS SYSDBA When I login via TOAD, I am able to. However, as in (1), all my attempts to login from command-line SQL *Plus fails. The error I get is ORA-1031 Insufficient Privileges Even if I am on the physical server and try to run the SQL *Plus, I get the same error -- Insufficient Privileges
Here are the environment details:
Server: Windows Server 2008 R2 Server: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Client: Windows 7 Professional Client: SQL*Plus: Release 11.2.0.1.0 Production
i do have a set of monthly process, where i need to run query one after the other. Some query will take one hours time to complete but some will take 10 hours or more to execute. My problem is that we have wait or machine shouldn't hang or log off during that time ...
I am executing the query in TOAD and windows SQL*Plus. Query can run Parallel at a time.
Is the there anyway to run the query in the background like what we do in the unix nohup command in toad?
there is a problem , related to toad. when i try to connect with my database through toad then it throws an error-"Can't initialize OCI. Error -1", how to sort out of this problem. and i am using toad 9.2.7.1 on widows server2008.
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.
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.
I am able to connect to DATABASE from SQLAssistant only when I provide string like ABOVE........If I dont mention the SERVICE, m unable to connect to DB.Now the biggest issue is with SQL Developer.....m not at all able to connect to DB using SQL Developer.
it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems
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]......
I am in the process of converting my skill in oracle and this time PRO*C from Windows to Linux. I have oracle 11g R2 installed on a UBUNTU (12.04) server and have installed the instant client as described in
[URL]
This has a query which will run in SQLPLUS but fails with PRO*C
:~/Projects/proc/proctest1$ proc INAME=proctest.pc SQLCHECK=NONE ONAME=proctest.c LNAME=proctest.lis LTYPE=long Pro*C/C++: Release 11.2.0.3.0 - Production on Mon Apr 22 21:00:18 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. System default option values taken from: /home/neill.rutherford/instantclient_11_2/precomp/admin/pcscfg.cfg PCC-W-02109, SQLCHECK=NONE is no longer supported.. using SYNTAX
I have installed Oracle 10g XE in my laptop having Windows 7 home 64 bit OS..I have created some users in the oracle and iam able to connect these users through cmd prompt..But the issue is that iam unable to connect to the database through TOAD..
I have given the user name and password and database as XE and connect using as : XE but still iam getting the error as "TNS could not resolve the connect identifier (XE).
Unable to connect in TOAD in ORACLE 11g through sys user.
I am using Toad for ORACLE version 9.0.0.160 and ORACLE 11gR2 (11.2.0.1).
I make the FALSE to "sec_case_sensitive_logon" parameter hence not able to login through sys user. I can logged in through system user without any issue.
We are using oracle10g database. Every time, we need to run the sql query and find answers for them. We are getting lot of request every day. I wanted to develop interface and i want ops team use the interface to pull the data.
Here are my thoughts...
1. using oracle APEX to develop interface.
2. Use the excel to write macro and get the answers for user request.
3. I can write a PLSQL to run the batch job and extract the data into excel and give it to ops team.
I am running TOAD 10.6 on Windows 7 (64-bit). I have two 64-bit Oracle 11g clients installed (all on the same machine). The first is Instant Client (client_1); the second is the Runtime client (client_2). The installation of Instant Client was a mistake, since it doesn't have a Network / Admin folder to drop a tnsnames.ora file into. The Runtime client is my desired client, which has the aforementioned folder that I subsequently dropped the file into.
On starting TOAD, it says that "No valid Oracle Client found. Please note that Toad only supports 32 bit Oracle Client installations". (This is odd, since my colleague is running the same Oracle Runtime client as me and has TOAD 11.6, and yet his is working fine. But, this is aside the point.) When, I click on the ellipsis button next to the "Connecting Using" field, TOAD says that I don't have any Oracle homes installed. I checked my registry key (via regedit) under Computer / HKEY_LOCAL_MACHINE / SOFTWARE / ORACLE. It looks like I have 2 Oracle homes (because of the 2 clients).
Also, I right-clicked on My Computer and brought up Properties, Advanced system settings, Environment Variables (on the Advanced tab). My PATH variable has both of my clients.
How to make my available clients (particularly, my client_2) show up in TOAD?
Here is what I have tried thus far:
-Alter the PATH variable to just have client_2. This didn't do anything.
-Try to uninstall client_1 and client_2 via:
a) There is a Universal Installer under Oracle Installation Products in my Runtime client. I do Deinstall Products, click on any of my Oracle homes, click on Remove, and a Warning window pops up saying to run a command at some location, but the location is truncated since I can't expand the window.
b) In my client_2, there is a deinstall Windows Batch File in the deinstall folder. When I run this, the command window sits there for a little bit, saying that some files were copied and that 1 directory was removed. It then closes on its own. This doesn't seem to do anything.
[oracle@localhost ~]$ sqlplus system/password SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory
But when i am using SID name while connecting to database i am able to connect...
[oracle@localhost ~]$ sqlplus system/password@apple SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012 Copyright (c) 1982, 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 SQL>
comparison of oracle and toad products.I know we have oracle enterprise manager for doing application and enterprise management.I am listing the tools from toad
Can list the tools from oracle which have or perform the same functionality.
Toad Toad Development Suite for Oracle Toad DBA Suite for Oracle Toad for SQL Server Professional Edition Toad for SQL Server Xpert Edition Toad Data Point Pro Edition Toad Data Point Pro Edition- with analytics
I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed). but when I see the variable from DEFINE.. It shows that default editor is notepad..
I can use editor in winxp.How to get (use) editor ?
I have a shells script which invokes a SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback.
My sql file has 3 lines 3 are correct and 1 is incorrect. For example: INSERT INTO TEST_ROUTING VALUES (24, 'ROUTING'); INSERT INTO TEST_ROUTING VALUES (25, 'ROUTING'); INSERT INTO TEST_ROUTING VALUES (26, 'ROUTING);
Lets say file is called 1.sql
My shell script invokes this SQL as follows: (Where $File1 = 1.sql)
$SQLPLUS_PATH/sqlplus -s /nolog <<-EOF>> ${LOGFILE} connect $DB_USER/$Password1@$Database1 SET AUTOCOMMIT OFF @$File1 WHENEVER SQLERROR EXIT ROLLBACK; EOF [code]......
So tried SET AUTOCOMMIT, tried SQLERROR ROLLBACK and tried few variations.
I install Oracle instant client 11g in my Windows 7(32bit), and use MSVC6++ to test program occidml.cpp, compile is no problem, but when I run it, it crash on create Connection. I have tried to link with different version of OCCI library ( v8,v9), but all crash on create Connection.
