Oracle ORA-12528: TNS:listener:

i have a database for learning purpose. i got this error when i connected to database.
may i know what could cause this to happen?

Enter user-name: sys@baba as sysdba
Enter password:
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Smilar Topics

  • Oracle ORA-12528, TNS: Listener All appropriate instances are blocking new connect

    Im new to Oracle. Just installed Oracle XE on a Suse 9.3 machine. When I connect remotely to the machine (f.i with Aqua Data Studio) using JDBC I get the following error:ORA-12528, TNS: Listener All appropriate instances are blocking new connectionsWhen I run oracle-xe status I get the following res ...

  • Oracle ORA-12528: TNS:listener: networking problem...

    Can someone help???I am recieving the following error when trying to connect to my asm instance remotely (using password file)10gr2 running under Redhat linuxORA-12528: TNS:listener: all appropriate instances are blocking new connectionsI have tried to modify the listener.ora to include sid_name, gl ...

  • Oracle ORA-12528: TNS:listener: todas las instancias adecuadas están bloqueando n

    When I restart My computer I retrieve this error How can I solve it?ORA-12528: TNS:listener: todas las instancias adecuadas están bloqueando nuevas conexiones He leido que hay un patch para este error,he leido mucho sobre quees porque no arranca bien la instancia etc,Es que de momento lo que hago e ...

  • Oracle ORA-12528: TNS:listener

    When I start the EM (port 1158) I see the following error:Enterprise Manager is not able to connect to the database instance. The state of the components are listed below:The database instance is down (red arrow).LISTENER:Status UP (green arrow)Port: 1522AGENT CONNECTION TO INSTANCE:ORA-12528: TNS:l ...

  • Oracle ORA-12528: TNS:listener: all appropriate instances are blocking new connect

    First I must say that I'm a total novice in Oracle. I'm now installing Oracle XE as I need to Oracle to test Spacewalk (management of RH derived Linux distributions like CentOS). The server runs CentOS 5.3 and is a virtual one on KVM and has 1GB memory, 1GB swap and plenty of disk space.I have insta ...

  • Oracle ORA-12528: TNS:listener: all appropriate instances are blocking new connect

    I am new to Oracle, when am attempting to log in to oracle getting the following error.please feel free and give me a solution.ORA-12528: TNS:listener: all appropriate instances are blocking new connections ...

  • Oracle ORA-12528: TNS:listener: all appropriate instances are blocking new connect

    When I shutdown my database, it shut down normally. But when I want to startup mount my database, it gives this error: ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsWhat is the reason??? ...

  • Oracle ORA-12528: TNS:listener: all appropriate instances are blocking new connect

    tnsping is working ok on both machines. can connect from system itsef too.trying to connect from 2nd system. receving following error.ORA-12528: TNS:listener: all appropriate instances are blocking new connections restart the listener on both nodes as well. ...

  • Oracle ORA-12528: TNS:listener: all approriate instances are blocking new connecti

    i am getting this error while log on on database 10g on operating system is WINDOW XPORA-12528: TNS:listener: all approriate instances are blocking new connectionPlease GUide me how to resolve this issue ...

  • Oracle ORA-12528: TNS:listener: all appropriate instances are blocking new connect

    I am having very strange issues here. I am having DG on Y machine and when I am trying to connect with it through the string sqlplus sys@TEST10G1 as sysdbaI am getting ORA-12528 error and same way when I am trying to connect with remote locations too same error. My DG is in no-mount mode. What could ...

  • Oracle when i try to login my 10g that give me error ORA-12528: TNS:listener: all

    sir see this error when i try to login i my 10g last day i user rightly when i use today that give me this error ORA-12528: TNS:listener: all appropriate instances are blocking new connections please give me idae how i use my oracle 10g database ...

  • Oracle ORA-12514: TNS:listener does not currently know of service requested

    I'm currently trying to set up a reporting data source in VS2005 in a Reporting project. Now when I try to create a new report using my Oracle based data source I get the following:A connection cannot be made to the database.Set and test the connection string.ERROR [NA000] [Microsoft][ODBC driver fo ...

  • Oracle ORA-12505: TNS:listener could not resolve SID given in connect descriptor

    Anybody knows this oracle error?ORA-12505: TNS:listener could not resolve SID given in connect descriptor) This error happen while connecting to Oracle Manager using user 'sys' or 'system'. I was able to connect without specifying a 'service'.I am using Oracle 8.0.5 for NT. OracleTNSlistener is up a ...

  • Oracle ORA-12505 TNS listener could not resolve SID given in connect descriptor

    I had installed Personal Oracle 9i on W2K and it workes fine in SQL*Plus and Forms after installation.I had connected with: scott/tiger@db9i_server1 and had worked with the http server demos.Than in the next day (after booting) I received following error: 'ORA-12505: TNS-listener could not resolve S ...

  • Oracle ORA-12500: TNS:listener failed to start a dedicated server process

    Hi. I am getting this error message. ORA-12500: TNS:listener failed to start a dedicated server process I am using Oracle 8.1.7 on an Escala/AIX.I have modified my init.ora file so processes = 1500 # from 1200However this has not helped. When I use ps -ef | grep oracle | wcIt only reports 1125 proce ...

  • Oracle ORA-12523: TNS:listener could not find instance appropriate for the client

    SQL> connect sys/sys@safedb as sysdbaConnected.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.ORA-12523: TNS:listener could not find instance appropriate for the client connectionWhen i see solution Cause: The listen ...

  • Oracle ORA-12514: TNS:listener could not resolve SERVICE_NAME

    I have installed Oracle 10g on a Windows Server 2003(Intranet). I am trying to connect to it from a XP machine(on the same network) using .NET driver from Oracle. When I run the aspx page which connects to the database It gives me the following error:ORA-12514: TNS:listener could not resolve SERVICE ...

  • Oracle ORA-12514: TNS:listener does not currently know of service requested in con

    HiI have 3 instances(ora1,ora2 & ora3) of 10g on my pc. My Oracle_home is set to ora3 home. I can tnsping all the 3 instances but when I try to connect to ora1 or ora2(sqlplus scott/tiger@ora1) it is giving error:ORA-12514: TNS:listener does not currently know of service requested in connect des ...

  • Oracle ORA-12500 TNS:listener failed to start a dedicated server process?

    I am receiving this message when I try and connect to a new database:ORA-12500 TNS:listener failed to start a dedicated server processThis is my listener.ora file.# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = ...

  • Oracle ORA-12514: TNS:listener could not resolve SERVICE_NAME given in conne

    I am running Oracle 8.1.7.1.4 on Windows 2000. After I created a database TEST using a script created by my previous colleague, I got the following error:sqlplus SYSTEM/PASSWORD@TESTERROR:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptorEnter user-name:But if I enter ...

  • Oracle ORA-12505: TNS:listener could not resolve SID given in connect descriptor

    from other Oracle Systems (8.05, 9i) I can't connect to my Database 10g.On the server where the 10g-Database is installed I can connect:sqlplus user/passwortorsqlplus user/passwort@telkas2.worldFrom other machines the tnspning result is okay. tnsping telkas2.worldAttempting to contact (ADDRESS=(COMM ...

  • Oracle ORA-12516 TNS:listener fail

    I need help soonI have:Red Hat Advanced Server 3.2.3-42Oracle Enterprise Edition 10GHP Server with processor ItaniumI have 5 instances running in the server, one has problems with its dispatcher:Service "Instance1" has 1 instance(s).Instance "instance1", status READY, has 1 handler(s) for this servi ...

  • Oracle ORA-12514: TNS:listener could not resolve SERVICE_NAME.

    I've got 2 databases in a server. One is 9iR2 Database and another of 10g AS.Using the command prompt when i set the ORACLE_SID to the respective database and dosqlplus "/ as sysdba" it connects well to the respective DB. Show Parameter service_name; shows me the right DB.But, when i connect from th ...

  • Oracle ORA-12516: TNS:listener could not find available handler with matching prot

    We are using Oracle 10g Database and 10g Oracle App ServerWe are finding this error continously after 2 - 3 hours of workingWe are using Oracle 10g Database and 10g Oracle App ServerError SaysORA-12516: TNS:listener could not find available handler with matching protocol stack Cause: None of the kno ...

  • Oracle ORA-12500: TNS:listener failed to start a dedicated server ...

    Environment; o/s: WindowsDatabase: Oralce 9iI have setup standby database many times.However, While i tried to setup standby db today, for one of our client,for startingup the standby db, i am not able to connect as sys or "/" . it gives the error "ORA-12500 TNS:listener failed to start a dedicated ...

  • Oracle ORA-12514: TNS: listener does not currently know of service requested ...

    I installed Oracle XE on my laptop at work. During installation no errors appearead, but when I tried to connect to oracle with sqlplus.exe it says:SQL> connEnter user-name: system@xeEnter password:ERROR:ORA-12514: TNS:listener does not currently know of service requested in connectdescriptorIf I ...

  • Oracle ORA-12520: TNS:listener could not find available handler for requested type

    I am new to Oracle, I have a multithreaded application in which a few threads connect simultaneously to the database, I am currently using a self developed database and I wanted to try using Oracle XE (I am using ODBC to work with the database so switching is possible). When I run with a small numbe ...

  • Oracle ORA-12514: TNS:listener does not currently know of service requested in con

    I am facing a problem with connecting to oracle from sqlplus.when I enter the following command I get an error (ora-12514) and the system asks me for a username/password again. when I enter the same username and password I am able to connect to oracle. as shown below C:\Documents and Settings\Admini ...

  • Oracle ORA-12514: TNS:listener could not resolve SERVICE_NAME given

    HiI have 3 server having oracle 9i database same version -one at head office -one at ours sister company and-one at port when i create string from Gui (SQL*NET configuration head office database)to connect sister co's database it works well and then i create db link by using this string its working ...