Oracle may not be functioning properly but it is working fine with the administrator login. This entry was posted in oracle and tagged sp20152. Oracle call interface oci is the comprehensive, high performance, native c language interface to oracle database for custom or packaged applications. I installed oracle 10g r2 in my laptop with win7 ultimate32bit. The system contained 2 oracle homes as shown below the environment variable path contained the bin path of both the installation. Sp2 1503 and sp20152 when starting sqlplus doc id 467793. Oracle may not be functioning properly cause of the problem. Sp21503 and sp20152 when starting sqlplus doc id 467793. To implement the solution, please execute the following steps. Unable to initialize oracle call interface blogger.
Starting sqlplus works when logged on locally to the windows server console using the nonadministrator os account. Unable to initialize oracle call interface id 415861. Permissions at the os level arent set properly after the oracle 10gr2 install. After installation this oracle client is able to connect with the database when we login in as a administrator into the machinepc. Oci libraries are included by default in oracle database 18c. Thank you so much for sharing this kind of information. Unable to initialize oracle call interface april, 2014 agb where i tried to start sqlplus with scott and tiger as username and password, the prompt is disappearing immediately. Unable to initialize oracle call interface january 26, 2011 nareshm121 leave a. I am not able to run the sqlplus command as oracle. Sp20152 oracle may not be functioning properly cause. Oracle may not be functioning properly then i have export the path with above environment variables which i set earlier. Unable to initialize oracle call interface oracle dba. After that i restored my database and deinstalled the software.
Unable to initialize oracle call interface posted on mar 27, 2016 at 05. This blog is very useful and helpful for us to know more about this subject. No tnsnames issues as can run sqlplus as oracle admin user. Posted in installation, upgradepatch tagged oracle may not be functioning properly, sp20152, sp21503, unable. I am hopeless shopaholic who loves french movies, salsa and tango dancing, capoeira, computer programming and good books. Oracle may not be functioning properly environment is. Having experience more than 14 years, ive been working as oracle dba,rac dba, ebs dba, oracle analyst, oracle developer in different organizations. Sp21503 and sp20152 error while connect sqlplus in oracle. Unable to initialize oracle call interface, oracle apps. Though i had no issues during install i wasnt able to run sqlplus, either via the gui or through the.
Oci is also in the lightweight oracle instant client, allowing isvs and customers to quickly install. Unable to initialize a session to the oracle instance. For those who dont have access to metalink, this is the solution from the note that worked for us. Ive been involved in delivering lectures and technical workshops on oracle in various colleges and universities in pakistan. Oracle tools such as sqlplus, real application testing rat, sqlloader, and datapump all use oci. Oracle may not be functioning properly when logged on to the windows server as a nonadministrator os account using microsoft terminal services client mstsc. Oracle may not be functioning properly starting sqlplus works when logged on to the windows server using an administrator os account. Client tools 10g on windows 7 unable to initialize oracle call interface oct 16, 20. Both the databases instances were up and running fine, the processes can be seen below. Unable to initialize oracle call interface user548266 may 3, 2010 6. After all the help you guys have given me, im slowly getting there new errors when trying to start sqlplus sp2 1503.
Oracle may not be functioning properly i found on hp forums that there is a base bug 4516865. I love to read your blog and getting inspired on your blog. For supported releases of oracle database, you can downgrade a database to the release from which you last upgraded. Oracle may not be functioning properly what causes the sp1503 and sp0152 errors. Patch 5632264 to oracle enterprise manager 10g database control release 10.
If we are login with the normal user into machinepc then we are not able to connect with the database. Unable to initialize oracle call interface sp2 1503. Find answers to sp21503 error on connecting to oracle. Unable to initialize oracle call interface in oracle 11g. Indicates a library used by sqlplus to communicate with the database failed to initialize correctly. Check that the oracle environment or registry entries are consistent and correct. Unable to initialize oracle call interface solution. Unable to initialize oracle call interface sp20152. Oracle may not be functioning properly after following the above steps on my windows 7, in admin account its working fine, not on the user account, but my user account has a admin previlage. Client tools 10g on windows 7 unable to initialize. Sp21503 unable to initialize oracle call interface. Windows oracle 10gr2 in windows 7 ultimate orafaq forum. Unable to initialize oracle call interface written by sandeepsingh dba smart way of technology worked in database technology for fixed the issues faced in daily activities in oracle, sql server, mysql etc.
359 1408 1479 1174 586 490 810 1232 631 74 1270 1358 286 509 207 610 740 1006 100 1049 532 483 1331 1057 885 672 352 436 567