[sqlplus] - SP2-1503: Unable to initialize Oracle call interface

I've just reinstall an new Oracle DB 10.2.0.1.0 and when i type SQLPLUS i've this error:$sqlplus /nologSP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may not be functioning properly what's hapening ??? ...

Oracle ora 07445 ,sp2-1503,sp2-0152 error

When i am trying to connect oracle through Sqlplus, i am not able to connect. this problem is not consistent one, some times only I am facing this problem. Sqlplusw window getting closed after entering the username/password and hostname.if i am trying to connect the DB through sqlplus from cmd line, ...

Oracle Migration problem - SP2-1503 and 0152

This is my situation: I am migrating my current prodution database version 10.2.0.3.0 to another machine to use as a backup (all on Windwos 2003), this time as version 10.2.0.4.0. I completed all the prerequisite for migration including creation of services etc. The services is up and running on the ...

Oracle 11g sqlplus (command line)

I just have this basic question to all of you , who are using 11g sql+ client.I have sqlplus client installed on my windows box, which created a shortcut to this executable (.....11.1.0\client_1\BIN\sqlplus.exe)when I invoke it, it opens a command line & lands straight into SQL..The problem I am ...

Oracle Trapping sqlplus SP2 errors

In sqlplus called from Unix shell scripts, I'm trapping SQL errors via 'whenever sqlerror exit N' and OS errors via 'whenever oserror exit N'. However sqlplus errors (SP2 errors) are not trapped by either of these mechanisms, for example:SQL> whenever sqlerror exit 7SQL> whenever oserror exit ...

Oracle Instant client install on Windows SP2-1503

System: Windows 2003 SP1 32bitI have downloaded instantclient-basiclite-win32-10.2.0.4.zip and instantclient-sqlplus-win32-10.2.0.4.zipI believe I have setup my environment correctly.ORACLE_HOME=C:\OraHome1\instantclient_10_2TNS_ADMIN=C:\OraHome1\instantclient_10_2\network\adminPATH=C:\OraHome1\inst ...

SP2-1503: Unable to initialize Oracle call interface

I have installed Oracle 10g R1 on my new HP laptop with OS as Windows 7 and the installation was successful.But, unfortunately while trying to connect to the DB with the sqlplus /nolog command, the below error is re- occuringSP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may no ...

sp2-1503 unable to initialize oracle call interface in windows vista

I have installed Oracle 1OG(10.2.0) on my systemOperating system is Microsoft Windows Vistawhen I tried to enter enter sqlplus command in the command prompt then i am getting the following error messages.SP2-1503: Unable to initialize Oracle call interfaceSP2-0152: ORACLE may not be functioning prop ...

Issue in logging into sqlplus - Oracle 11g Database

I have installed oracle 11g database in my system, After installation, i am able to login into the Oracle Enterprise manage by accessing the link https://localhost:1158/em with my system or sys user name and the password.Both as Normal and as SYSDBA But if try to give to the same user name and passw ...

Problem in moving recordset (ASP, Oracle 11g, Win 2003 Server SP2)

I am using Oracle 11g on Windows 2003 Server R2 x64 (SP2). When I use recordset.movenext (ASP coding) I am getting the below error:OraOLEDB error '80040e0e' Bookmark is invalid. Can any one please enlighten me what is this?Bcos the code which I have written is perfectly working for Oracle 10g on Win ...

Oracle 11G DB on windows server 2003 sp2 Unable open EM webpage

I am new to this forum, i think this is correct place to post this thread.I am getting one trouble while configuring emca.Mar 18, 2010 5:29:52 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArrayCONFIG: New Env List: [ALLUSERSPROFILE=C:\Documents and Settings\All Users, APPDATA=C:\Document ...

SP2-1503: Unable to initialize Oracle call interface

hiI am using windows system and i am having oracle 10.2.0 installed in my system which was working fine.After that i installed 11.2.0.1.0 in new home.I set the env ORACLE_HOME to the 11.2.0.1.0 home. I am able to connect the 11i db.But when i connect to 10g i set ORACLE_HOME to 10ghome and oracle_SI ...

Problem in moving recordset (ASP, Oracle 11g, Win 2003 Server SP2)

I am using Oracle 11g on Windows 2003 Server R2 x64 (SP2). When I use recordset.movenext (ASP coding) I am getting the below error:OraOLEDB error '80040e0e' Bookmark is invalid. Can any one please enlighten me what is this?Bcos the code which I have written is perfectly working for Oracle 10g on Win ...

Oracle 11g on Windows server 2003

I've oracle 11g installed on Windows Server 2003.I have installed oracle 11g twice, so wasn't sure how to uninstall one version without effecting the other.There are a few databases set up, none of which are now working.Trying to connect using mysql client, or the oracle11g client results in TNSList ...

Oracle Re:SQLPLUS error

I Installed 11.2.0.1 on one machine first, that time sqlplus and everything is working fine. I Installed 10.2.0.1 software on same machine and want to create 10gr2 database. when changing ORACLE_HOME and doing sqlplus getting below error. Any one of them faced this kind of problems.echo $ORACLE_HOME ...

MDM 9/ RSA 754 with Oracle 11g

We use MDM 901, RSA 754 and Oracle database 11g rack.The DB is on a remote server. Problem: When using Workbench setup wizard, I filled all the information but could not get connected. In the error message pop-up window, the failed SQL was 'sqlplus -L xxx/xxx@//10.xx.xx.xx@MDM'. I ran it from comman ...

DS4700 and Oracle 11g ASM database on SLES 10 Dell 2950

What is the proper config for a DS4700 that contains Oracle 11g ASM database. The OS for this server is SLES 10 sp2 64 bit. The server is a Dell 2950. The current layout of the DS4700 has 6 arrays (I think) raid 6 across 4 enclosures, the disk size is 300 GB SATA. It looks like each array has a tota ...

Oracle 11g

Has anyone used Oracle 11g yet? If so, do you know why sqlplus does not work? Here is the error:$ORACLE_HOME/bin/sqlplus -H/u01/app/oracle/product/11.1.0/bin/sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/lib/libnnz11.so: cannot restore segment prot after reloc: Permis ...

Installing Oracle 11g on RH Fedora 7

I was installing Oracle 11g on RH Fedora 7during the installing process,I got the two error messages: The first:NFO: Configuration assistant "Oracle Net Configuration Assistant" failed *** Starting OUICA ***Oracle Home set to /home/chobits/app/chobits/product/11.1.0/db_1Configuration directory is se ...

oracle 11g on rhel5

oracle community,i've installed the new oracle 11g on rhel5 enterprise linux. i put all necessary packages in place and set all needed kernel parameters as documented. the installation worked fine, and the OUI created a starter database for me. listener is configured and started. so everything is pr ...

Font Loading in Oracle 11g javavm

I want to write a java source in Oracle 11g that creates an image containing texts.I tried to create a java class from sqlplus using "create or replace and resolve java source" .....that contains .."Font fnt = new Font("Courier",Font.PLAIN,14);"and,"g.setFont(fnt);".The source is compiled and resolv ...

Oracle 11g problem with linux Suse 10.3

I am using openSUSE 10.3, and i installed oracle 11g and the installation worked successfully, but after installation, it seems that there is no oracle on my system, i tried sqlplus commands, the response was "command not found", i tried to log into the database through my browser, but also it says ...

Oracle 11g Database Schema problem

I have installed the Enterprise Edition of Oracle 11g on windows XP SP2. I log in to Enterprise Manager. When I click on the schema tab I get the following error message.Error Internal Error has occured. Check the log file for details.Does anybody know why ? and which log file they are refering to?A ...

how to export objects from Access 2003 to oracle 11g ?

I have an access file contain a lot of tables and there some tables with a lot of columns.so .... is there anyway to export the objects ( and data also if possible ) from Access 2003 to Oracle 11g ?Note : I use windows XP SP2 I'm waiting for the answer ....... and ...

Oracle 11g Install, loopback adapter static IP, dbconsole fails when NIC added

11g installation:Development Laptop environment for Oracle 11g, ODPNET, and Visual Studio 2008.Goal: install Oracle on loopback adapter with static IP, and then install networkinterface card with DHCP IP for internet and IIS use.1. Disabled motherboard network interface card.2. Booted to new unparti ...

Oracle 11g ODBC on Ubuntu 8.04 64-bit

Has anyone been successful in making Oracle 11g ODBC work under Ubuntu 8.04 64-bit? I've got the client installed, and sqlplus works fine.P.S: Sorry about the devil smiley - haven't posted in a long time! ...

Oracle [11g] ORAPWD and ORA-01031

I use Oracle 11g on Linux and I cannot remotely connect as SYSDBA in sqlplus.I created the password file with ORAPWD, I set parameter remote_login_passwordfile to EXCLUSIVE and I restarted the database.But I still get the error ORA-01031: insufficient privileges.When I check the v$pwfile_users view, ...

Initializing error while invoking the SQLPULS in Oracle 11G.

I installed Oracle 11G freshly and now I am geting following errors while invoking the sqlplus from the client side. C:\Documents and Settings\Administrator.SC14FT1>sqlplusError 57 initializing SQL*PlusError loading message shared library Any idea ? ...

Oracle starting SQLPLUS

I installed Oracle 11g and trying to start using SQLPLUS - stand alone management console. I started the database console through emctl start dbconsole, then typed sqlplus system, asking for pwd, while i typed password the system through error message saying oracle not exists...Does anyone could hel ...

Oracle 11G demobld.sql script(s)...

I have been asked by a coworker to install the demo tables that Oracle used to provide (e.g., scott/tiger HR, EMPL, and other tables, but I don't seem to be able to find the demobld.sql script in the old location ($OH/sqlplus/demo).Does Oracle still provide a simple demo for developers and such to l ...

Oracle 11g database startup problems

first of all - merry Christmas everyone!Like a real geek i'm spending my christmas trying to get a grip with oracle I had oracle XE running on my server, now am trying oracle 11g. (Oracle XE was uninstalled after the installation of 11g)Installed 11g according to http://www.pythian.com/blogs/654/ins ...

Oracle 11g ODBC Gateway to MS_Access 2003

I am trying to set up an ODBC gateway between Oracle and Access. I have several Oracle to SQL Server gateways running but this one is different. I have the Oracle 11g ODBC gateway installed on GRID36. I have an MS-Access 2003 database called PI_CINSTPI. The table (piiinterp) in PI_CINSTPI is a linke ...

Is that possible to convert from small to a Bigfile Tablespace(oracle 11g)?

Is that possible to convert from small to Bigfile Tablespace(oracle 11g, windows 2003 R2 sp2)?Now I have 10 GB of data inside my oracle database and 400 gb in SQLserver 2000 one.I am going to merge thease two and make a one big oracle database.My current oracle db_block_size = 8kb and it means that ...

Problem with Application Login after upgrading to Oracle 11g

I have a home-grown application with Oracle 10g database running under Windows XP Pro. Recently, I installed Oracle 11g and imported the application database from 10g to 11g (still want to keep the 10g running for a while). However, I now having problem with the application logging into the new 11g ...

tns problem with Oracle 11g ODAC 11.1.0.6.21 with Oracle Developer Tools

I installed the fullOracle 11g ODAC 11.1.0.6.21 with Oracle Developer Tools for Visual Studio now I am at the good old "[ORA-12154: TNS:could not resolve the connect identifier specified]" error.I copied the same tnsnames.ora as used on the db serveronto the client "C:\Oracle\product\11.1.0\client_2 ...

ORA-01034+27101:Can't start db after applying Oracle 11g patch (11.1.0.7.0)

I installed Oracle Database Enterprise 11.1.0.6.0 and it runned without problems.After applying Oracle 11g patch (11.1.0.7.0), i get this errors on starting the db:sqlplus "/as sysdba" SQL*Plus: Release 11.1.0.7.0 - Production on Tue May 12 10:38:45 2009Copyright (c) 1982, 2008, Oracle. All rights r ...

Oracle 11G + Database Connection taking too much Time

I am using Oracle 11G . When i try to connect to oracle databasesqlplus system/impetus@databaseit takes too much time ( more than 1 min )I am not getting why this is happening ?Before some day it was working fine but suddenly the problem occurred.. Is this issue is related to log files generated by ...

conflict between installs of oracle 11g and the app server from 10g

I have oracle 11g installed on a windows xp pro pc. To support Apex, I installed App Server 10g. Apparently the modifications made to the Path def by the App Server 10g installation gives tns listener problems when invoking sqlplus from a cmd window. Based on something I read in the data base forum, ...

Oracle 11g: "ORACLE initialization or shutdown in progress" problem.

We are using Oracle 11g (enterprise edtion) in Windows server 2008. Whenever we reboot the machine we are not able to connect the database. Following output indicate the errors. :\Users\Administrator.F1STD.000>sqlplus dbo/<password>@<connect string>SQL*Plus: Release 11.1.0.7.0 - Produ ...

SQL PLUSW.EXE Not Supported on oracle 11G

I installed Oracle 11G and am not able to connect the GUI SQL Plus. When SQLPlus.exe is executed, it brings me to a DOS based version of SQL Plus. Is there a way I can get the GUI verison installed with 11G? i ve installed Oracle Database 11g Release 1 Client (11.1.0.6.0) for Microsoft Windows (32-b ...

Oracle 11g Installation problems

there, Im a new Oracle's user, and I am trying to install Oracle 11g in my computer I have Windows Vista SP2 32bits, but I have a lot of problems.The program send me various messages of Warnings and Errors so I couldnt finished the complete instalation and configuration.Somebody can help me with som ...

Oracle 11g ora-12546 : tns permission denied

I have oracle 11g - 11.1.0.7.0 on AIX 6.1The problem i have is connecting to sqlplusThe oracle user can connect but other users outside of oracle or dba group cannot connect unless they go through the listener.EG: user/password@database works fine,but if i try just sqlplus user/password i have the e ...

Oracle 11g Remote Connection issue

When I try to connect to Oracle database remotely using SQLPlus or SQLDeveloper I get the following error.ORA-01017: INVALID USERNAME/PASSWORD; logon denied.Server details:Oracle 11g on Enterprise Linux 4I can connect using SQLPlus on the server.SHOW SQLCASE is MIXEDClient details:Windows Server 200 ...

Database timeout issue in oracle 11g 64 bit windows machine

Database connection getting timedout for every 30 seconds in oracle 11g database 64 bit windows environment.And the error we are getting is "Invalid user name and passoword".After altering the schema passoword alter username identified by pwd;we are able to connect to database but it is getting time ...

Oracle 11g em console very slow

I installed 11g enterprise on a centos 5. I followed steps:1. startup db[oracle@isc ~]$ ORACLE_SID=orcl; export ORACLE_SID[oracle@isc ~]$ sqlplus / as sysdba2. listener start[oracle@isc ~]$ ORACLE_SID=orcl; export ORACLE_SID[oracle@isc ~]$ lsnrctl start 3. Oracle Enterprise Manager start[oracle@isc ...

Post installation issues in Oracle 11g

i have installed oracle 11g on my windows vista- ultimate OS. installation was successful without any error, but after the completion of installation i found that sqlplus.exe file's icon was not proper. it is like a default .exe icon of vista. moreover this, when i executed it, i am getting a comman ...

Oracle 11g compatiblity matrix

I need to find out which versions of sqlplus are compatible with 11.1.0.7. I am googlingoracle compatibility matrix 11g and searching the pay support site. I am not finding. I also try stuff like oracle 11g compatibility sqlplus. Can someone send me al ink to this doc or a doc number? Its probably m ...

[Oracle 11g R2 - windows 32 bit] Can't locate CompEMdbconsole.pm

Please help me how to solve this problem.I have installed oracle 11g R 2 windows 32 bit on windows xp professional at the vmware.Listener, sqlplus and the database is normal. we can connect from another PC as well.However, when I start the EM always get error below. I have already recreate the emusi ...

Unable to connect to Oracle 11g R2

I just installed Oracle 11g R2 on windows server 2008 R2. So everything is 64 bitIf I do tnsping from server everything looks ok.Also I am able to connect using sqlplus locallyBut if I am trying to connect from my laptop I am getting an error:ORA-12541: TNS:no listenerAre any changes in tnsnames.ora ...

Can't download Oracle 11g instant client for win32

I tryed to download Oracle 11g instant client from:http://download.oracle.com/otn/nt/instantclient/112010/instantclient-sqlplus-win32-11.2.0.1.0.ziplink above from main site: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.htmlLink is broken.Someone know if there are ...