Current Position:Home > Error while login as sysdba

Error while login as sysdba

Update:10-11Source: network consolidation
Advertisement
Hello all,
i was not getting this error before but just got this error as i installed oracle 10g developer kit when i try to connect from report builder i get an error of TNS and when i tried connecting my orcl database i got an error as
*"the procedure entry point could not be located in the dynamic link library oranl10.dll"*
can any one please help me to resolve it....
Thanks & Regards
Pratik Lakhpatwala
Jr Oracle DBA

The Best Answer

Advertisement
This is what i got as out put
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Kedar1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 23-SEP-2009 14:55:11
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Kedar1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit
D:\Pratik\9i-10g Imp\START UP INSTANCE>exit
SQL> connect [email protected] as sysdba
Enter password:
ERROR:
ORA-12557: TNS:protocol adapter not loadable
  • Error while login as sysdba for creating a new db Update:10-11

    Hi DBAs, i need to create a new database base, so trying to login as sysdba after exporting <ORACLE_SID> and <ORACLE_HOME> and getting the following error, need your help urgently. SQL> conn / as sysdba exec(): 0509-036 Cannot load program

  • Error while login as sysdba Update:10-11

    Hello all, i was not getting this error before but just got this error as i installed oracle 10g developer kit when i try to connect from report builder i get an error of TNS and when i tried connecting my orcl database i got an error as *"the proced

  • Could not login as sysdba after changing oracle sid Update:10-11

    I am using Oracle 10g on Windows. I am getting errors while performing cloning of database from cold backup ( just for leaning purpose). The problem is that when i set the ORACLE_SID=ORCL, then i can get login as sysdba but when i change the ORACLE_S

  • Login as sysdba for patch R12 problem Update:10-11

    Hi, I am trying to apply the patch 12.0.3 for R12. On of the items is to run a script under a SYSDBA user, however I am not able to login as Sysdba, also not the sys user. The scripts : SQL> select * from v$pwfile_users; no rows selected Seems that m

  • ORA-01031:  when login as sysdba Update:10-11

    We have Oracle 11.2 on Redhat 5.6. on the server box, I can login as sysdba by doing sqlplus / as sysdbaBut failed when I do sqlplus sys/****@cchdev as sysdba ERROR: ORA-01031: insufficient privileges or In sqlplus conn sys/****@cchdev as sysdba ERRO

  • Unable to login as sysdba after installing ODAC and Oracle developer tools Update:10-11

    Hi..I was able to login with sqlplus / as sysdba and unlock scott account. I then installed ODAC and now when i try to login as sysdba i get Insufficient privileges error. also tried sys/password , sys/change_on_install, system/manager but no luck. P

  • Error logging in as sysdba - "insufficient privileges" Update:10-11

    Hi, I have AS10.1.2.0.2 installed on my linux box. i have infrastructure as well as midtier both installed in the same machine on different oracle homes. after installing everything worked fine and brought down the system just to test it. and upon re

  • Error while connecting as sysdba Update:10-11

    while login as sysdba getting an error as SQL> conn / as sysdba ERROR: ORA-12560: TNS:protocol adapter error Warning: You are no longer connected to ORACLE.actualy oracle is installed in server we are using the client version so is it possible to cha

  • Only able to login as sysdba? Update:11-30

    I just installed 11g2 on Redhat 5. I logged in using sqlplus as follows: $sqlplus sys/abcabc as sysdba I created a user as follows: sqlplus> create user "xyz" profile "DEFAULT" identified by "abcabc" default tablespace &qu

  • Error while login to UCM console. Update:10-11

    Hi, I am getting below error while login with 'weblogic' in UCM 11g console "http://server IP: 16200/cs" "Content Server Request Failed Unable to load the user information. Possible database connection failure encountered. Error message: (!