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
I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).
Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...
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"
i m unable to run the following script in sqlplus
SQL> @D:vasucount.sql
SP2-0310: unable to open file "D:vasucount.sql"
SQL>
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"
I want to work on isql*plus but i don't know how?!!?. whether i have to install it anywhere or what is the procedure to use it.?
View 2 Replies View RelatedI am using oracle 10 g on my pc .i have no issues while working on it but whenever i am not connected to the internet its says failed to connect.As most of the time i am not connected to the internet the isql plus browser would show the same error but the moment i connect to the inet,it works.
Is it that 10g isql plus wont work while not connected to internet ?
can we install oracle 10g,developer 2000 at window7 64 bit
View 9 Replies View RelatedI am try to install the oracle toad 8.6 in oracle 11g 32bit for window 7 operating system.
- the install oracle toad completed, but trying to connection to the database, unable to connect, nothing error when trying to connect.
-is oracle toad 8.6 support to window 7? any version for oracle toad to support window 7.
I am getting error while running oracle forms (oracle 10g) in internet explorer.
an unhandled win32 exception occurred in iexplorer.exe [7572]
is there any way to call internet explorer with in form.i want to provide net fascility to the users using 10g forms.
I have tried some beans but some restrictions are there.it is not properly displaying page.
For all my client machine Internet Explorer 8 is not working. Internet Explorer 7 is working fine . For a machine with Internet Explorer 8 after Installing Mozilla Firefox it's working under Mozilla Firefox Browser well.
View 3 Replies View RelatedI am looking for a possibility to get the current language from Firefox and/or Internet Explorer.
I searched through the Mozilla Developer Center but could not find an interface to realize that. For IE I also didn't find anything.
I know that IE adapts the current system language from the OS, but can I readout this value?
When I try to access the database control, I am un able to.The page cannot be found
I am using this URL in firefox [URL] But it is coming blank. with message as HTTP 404 not found
I have already did this
$ emca -repos create
$ emca -config dbcontrol db
my colleague added a new node to RAC yesterday, i found that can not access via IE, but dispaly em has started in background.
g841o-db134-> emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
"***/em/console/aboutApplication"
Starting Oracle Enterprise Manager 10g Database Control ............................ started.
[code]....
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
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.
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 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?
View 12 Replies View Relatedi want to open dialog window using oracle forms 10g on button click event.
View 3 Replies View RelatedI 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.
1> I installed "Microsoft Visual Studio Express 2012 for Web[32 Bit]" on Win-7[64 Bit] platform.
2> Then installed Oracle Database 11gR2 [64 Bit]
What else do i need to install, in order to Add a new database connection through Visual Studio 2012's Database Explorer.
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
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.
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
There are three versions of Oracle 10g instant client (10.2.0.2, 10.2.0.3 and 10.2.0.5) on Oracle website. which one works with Window 7? Where I can find the documentation from Oracle website?
View 1 Replies View Relatedi 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
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.
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?
View 9 Replies View RelatedDue 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.
View 4 Replies View Related