Error occurred when try to drop an Oracle schema

I try to drop an oracle schema but an error was generated:SQL> drop user birjac cascade;drop user birjac cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tablesI try to find the queue table, but no table was fo ...

Uses of Oracle Listener, Oracle Client.........

Please provide the uses of OracleListener, and Oracle Client in the most simple way?To connect Database using JDBC, is Listener Install needed for that Database?Plz Reply.... ...

New IP caused a problem to launch DBConsole & listener (Oracle 10gR2)

Guys,I have installed Oracle 10gR2 on XP system. My dev machine does not have permanent IP address and recently it has been changed.As a result I can launch Listener and Enterprise Manager - it‘s a problem to start OracleDBConcoledev01 and OracleOraDb10g_home1TNSListener.My sid name is dev01. I fo ...

error during drop of oracle 10g user -> queue tables

i'm trying to import my db dump (oracle 10g) using this commands:SQLPLUS system/manager1@mydb @importdb.sql myuser mypasswordimp myuser/mypassword@mydb file=c:\dump\myuser.dmp fromuser=myuser LOG=myuser.log commit=Yand this is importdb.sql contents:==================================================d ...

Unable to Start Listener? ORacle 10.2.0 (solved)

I am on Oracle 10.2.0I followed the necessary steps to the T.I tried to Connect to the database using SQL*Plus:sqlplussystemsystem_passwordselect count(*) from dba_objects; #(This should# return a count of the number of objects in the# database)But i was unable to connect. The problem is that i don' ...

listener oracle 10 g problems

i have a problem to start the service lsnrctl. the operating system is windows 2003 64 bits and oracle version is 10.2.0.1.0 . When i tried start the service the system display the follow errors. TNS-12537: TNS:conexi≤n cerradaTNS-12560: TNS:error del adaptador de protoTNS-00507: Conexi≤n cerrad ...

Error while starting Listener (Oracle 10.2.0.1)

I did not encounter any problem while installing the database. but as soon as I start the listner, I get an error saying "tnslsnr.exe has encountered a problem and needs to close."Any clues to the cause and resolution to the problem would help.Thanx ...

Unable to drop Oracle Enterprise Manager console in Oracle 11g

I am trying to drop the Oracle Enterprise Manager console in Oracle 11g (Windows server 2008 32 bit). I am getting the following error. D:\Oracle\Ora11G\BIN>emca -deconfig dbcontrol db -repos dropSTARTED EMCA at Jun 16, 2009 9:59:58 PMEM Configuration Assistant, Version 11.1.0.7.0 ProductionCopyr ...

Oracle Error in drop user Error:ORA-00942

While I want to drop some Oracle users, the following error exists:SQL> drop user simon cascade;drop user simon cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00942: table or view does not existHowever, I can select data from dba_users and no problem on create user ...

Oracle Error in drop user Error:ORA-00942

While I want to drop some Oracle users, the following error exists:SQL> drop user simon cascade;drop user simon cascade*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-00942: table or view does not existHowever, I can select data from dba_users and not problem on create user ...

Oracle Listener issue

forum members, In this moment I'm working on gentoo linux and I' new in oracle, I could install oracle and created a test database called "oracle.gentoo" , but I don't know if the listener it's really registering a service in order to access to the database with a java program , because the listener ...

Oracle drop reference on ascii-file/external table

my database imports data from an external table by a job. the problem is, that the structure of the ascii-file may differ (sometimes), so the job fails. the job executes again and again, but it will never be successful. now i've coded a procedure to delete these files if job-failures reach e.g. 4. B ...

Oracle drop user slow

We have an application in development mode right now. We currently have oracle installed locally on each developer's machine. The first thing we do when we "start" the application is drop the oracle user (using a more priveleged user).drop user clm cascade;This is just our approach to start clean. W ...

Oracle Listener - Security

One way to secure the listener is setting password(encrypted). Are there any other ways in which I can secure the listener. Oracle version used 10g ...

Oracle TNS: no listener!!!!

i have oracle9i and when i run # /oracle_home/bin/emcai couldnt login to update my database an error display:SQL exception encoutered:reason: ORA-12541: TNS: no listenerOracle error: 12541Error code: 2so what might be the problem!!!!beside how can i create init$ORACLE_SID.ora ???? because it is not ...

Performance of drop user on Oracle 10

our application has a function to drop an oracle user. Just the simpledrop user aaa cascade;The user owns only views and synonyms - no tables.This takes about 15 Minutes.Does anyone have similiar problems? Solutions? Idea? ...

How to Drop Oracle JOB?

Can anyone please tell how to drop an Oracle JOB? ...

Probelm starting listener after installing Oracle 10g R2 on CentOS 5.0

I installed Oracle 10g R2 twice on my CentOS 5.0 but ended up both the times with the same problem. I wasn't able to start oracle listener after a reboot. On the terminal when I log in with oracle user and try to start the listener:[oracle@localhost ~]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0 ...

Oracle How to drop all scheduled jobs

in 8i, how to drop all oracle scheduled jobs ?Many ...

Oracle My LISTENER won't start. Please help!

I am not sure why i keep getting the following error. Here is the error msg when i try and start my listener.[oracle@dina admin]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-JAN-2008 10:40:06Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /home/oracle/app/ora ...

Fresh OS, new Oracle install, listener already exists

I've installed RHEL4u5 from scratch, and then Oracle 10.2.0 Enterprise. I can install the database and dbca, but when I go to install the listener, I get:The information provided for this listener is currently in use by other software on this computer. You can proceed with the configuration as it is ...

Oracle another Listener problem...no listener and protocol adapter error

This morning I've something to do with my PC...when i changed my IP address...the listener couldn't be started....I though that it was the IP address didnt match with the listener.ora....so i came to change back to my old IP address....but....the listener still couldn't be started....here's the foll ...

Oracle Bizarre blocked listener, help !

My listener is blocked. And it does not seem to be for the usual reasons which I have seen on the Web.It is blocked directly after startup, when there are no user connections. So it is not a PROCESSES issue.LSNRCTL> services LISTENER_POPBConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=212 ...

Oracle Drop possibility of tablespaces

What are the tablespaces that are not allowed to drop in oracle?As far as i concern these are the tablespaces that is not possible to drop!-SYSTEM, SYSAUX, DEFAULT TEMPORARY TABLESPACEIs it possible to drop "DEFAULT PERMANENT TABLESPACE" and "DEFAULT UNDO TABLESPACE"?Are there any other tablespaces ...

Oracle Enterprise Manager Does not show Listener

In Oracle Enterprise Manager, it does not show the Listener Oracle 10.2.0.4Windows 2003 ServerThe server has 2 database orcl and orcl1 with one listener as LISTENEROracle Database Home tab ------------------------------------   General Status Up Up Since Mar 25, 2009 11:25:59 AM EDT Instance Na ...

Info about Listener for oracle 10g and 11g installed on single systm

I have installed oracle 10g n 11g on my system. I have question regarding oracle listener.oracle 10g , Listener.oraLISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP)(HOST = kankala.kalyan)(PORT = 1521)))) oracle 11g, Listener.oraLISTENE ...

Oracle ORA-12505: TNS:listener does not currently know of SID given in connect des

I was trying to configure Oracle Enterprise Manager to use the web interface for oracle administration on my home laptop and ran into trouble.The url I am using is:https://ankur.gateway.2wire.net:1158/em/I am logging as sys with sysdba privilege. I see:A down red arrow Database Instance: ankurEnterp ...

Oracle Listener Status in OEM

I am getting mixed signals on the status of my listener. Oracle Enterprise Manager says that listener is down, but when I type the command lsnrctl status, it states that it is up. I have restarted my OEM and my listener to see if it would fix the mixup, but it remains the same. What should I trust, ...

Oracle Listener not working in one of the servers of the Standby site

The system is a RAC with two servers working as Primary site, and two servers working as Standby site.Both servers of the Primary site are sending redo logs to one of the servers of the Standby site. The other server of the Standby site is not receiving any redo log.I have checked the listener.ora a ...

Oracle Error: Listener is not up. Start the Listener and run EMCA

Client cloned an environment from a cold backup (PSDEMO cold backup created, cloned to PSCFG). The PSCFG looks ok, we can connect ok, v$database looks correct but we keep getting the error CONFIG: ORA-12541: TNS:no listener oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: T ...

Oracle I can't startup the listener

Please help me!! I got this message when I tried to start the listener:[oracle@serverbd ~]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0.3.0 - Production on 04-MAY-2010 08:26:38Copyright (c) 1991, 2006, Oracle. All rights reserved.Starting /u01/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: pl ...

Oracle drop-schema

I am new to oracle.could some one help me how to drop an oracle schema?This is what i have doneConnected to the oracle instance.Then from googling i have DROP DATABASE command.I done this got errorORA-01586: database must be mounted EXCLUSIVE and not open for this operationwhile doing shutdown says ...

oracle transparent gateway listener issue

I am using oracle transparent gateway 11g for sql serverOracle 10g Database users are using this gateway to fetch records from sql server.when i stop the oracle transparent gateway listener oracle 10g users unable to establish new connection but the users who had already established connection were ...

Oracle Install RAC 11g2 : DBCA error with listener

I get this error while create database with DBCA in RAC 11g2 installation. ORA-00119: invalid specification for system parameter REMOTE_LISTENERORA-00132: syntax error or unresolved network name 'rac-scan.edu.vn:1521' My scan listener : [oracle@vm01 admin]$ srvctl config scan_listenerSCAN Listener L ...

Oracle Probl install 11g Listener not up or database service is not registered wit

OK, i am just beginning to study with oracle 11g.I've played a bit with the express edition.Now i am walking throught the oracle all in one book (good book b.t.w.).Installing 11g with installing a database works with no problems. All the applications are usable for as far as i have seen.Problem star ...

Oracle emca tool and TNS

I try to re-install manually the dbconsole of an Oracle11gR2 database on linux but I have an issue with emca command.When I try to drop the repository I get an TNS:no listener error in the log file but the listener is up and the tnsping can reach the database.I put "localhost" for the hostname in th ...

Oracle dbconsole can't start and re-configure

The problem is as following:-bash-3.2$ emctl status dbconsoleOC4J Configuration issue. /u01/app/oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_dbu1vip_ssp not found.-bash-3.2$ emctrl start dbconsole-bash: emctrl: command not found-bash-3.2$ emctl start dbconsoleOC4J Configuration issue. /u01/ap ...

jQuery get id of drag element in droppable.drop

Hi, I have the folowing problem:I need to get the ID of the element that was dropped on my droppableElement.I tried to get it with .attr('id') through the drop listener (with $(ui.draggable)) and through the start listener(with $(this)) of thedraggable, but both won't work. I was able to ...

How to delete an Oracle Object

I want to drop an oracle object created with object type as "java class"need to know the steps.If i make the 'status' of the object from user_object to 'Invalid',does this solve the purpose...How to permantely remove the object created.Need Help. ...

Oracle Installation problems

I'm a beginner with Oracle and i'm trying to install Oracle 9i. The installation is finished succesfully, but when i try to configure the Enterprise manager i get an error saying:SQL Exception EncounteredReason: ORA-12541:TSN: No hay ningun listener (There isn't any listener)Oracle error:12541Error ...

ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.0.0.

I just installed Oracle9i database version 9.2.0.1.0 on Red Hat Linux 9. I followed documentation for step by step installation. I managed to fix many installation bugs but this one I have no idea what to do, even after looking at Error Messages Documentation for ORA-01571. After starting the listen ...

Generic Connectivity 4 MS ACCESS on host A and ORACLE 9I on host B..

i have tested the Generic Connectivity for MS ACCESS on One machine i meanMS ACCESS and ORACLE 9i same machineIt's working fine there..But When i test the Generic Connectivity for MS ACCESS on Two machine i meanMS ACCESS on host A and ORACLE 9I on host B It's not working thereand gives the errorERRO ...

Oracle Help in creating database

I have created a new database using database configuration agent, Enterprise manager 10g shows the database instance is down.Host D675PM0J.Belkin port 1521 SID kam Oracle Home C:\oracle\product\10.2.0\db_1 when I try to startup I put my passwords in successfully but i only get operation shutdown imm ...

Oracle I cannot login from sqlplus and the HTML DB is not working properly in 8080

I just installed Oracle 10g XE in WinXP SP2, when I tried to use HTML DB, it was down, I telnet the port 8080 and it wasn't listening anything from it. I checked the services (Oracle Instance Service, Oracle Listener, Oracle Agent) and they are working properly.I cannot access from sqlplus as well, ...

Oracle ECLIPSE CONNECTION ISSUE

forum members, In this moment I'm working on gentoo linux and I' new in oracle, I could install oracle and created a test database called "oracle.gentoo" , but I 'm trying to connect an eclipse plugging with the database (i'm usign the driver from the ojdbc14.jar file), the plug-in is Quantum DB,. a ...

Oracle help with network configuration

I have installed a 10.2.0 database on a linux machine in order to learn a little about administration. I'm having a problem with the network configuration (I've spent some hours trying to understand what the problem is but I can't).The installation instructions I followed created a listener.ora, no ...

Oracle 10g Database error

I installed Database 10g EE on a Windows 2003 Server computer with a dynamic IP so I installed a ms loopback adapter. After doing I tried to install Application Express. I got a little ways through the install when I got an error when I tried to log into Database 10g saying the following.Error loadi ...

Oracle Trouble w/ Response Files

All,Im having a bit of trouble with my response file working correctly and wanted to get your thoughts.Im creating a custom db with only the following options:oracle.rdbms:10.2.0.1.0oracle.sysman.console.db:10.2.0.1.0oracle.rdbms.oci:10.2.0.1.0oracle.network.listener:10.2.0.1.0Below is a portion of ...

Oracle Whenever I have to restart Windows Server 2003...

...this seems to happen. If i have to restart the server for any reason, then bring up Enterprise Manager it says the "Database Instance" and the "Agent connection to Instance" are down, but the Listener is up. Database Instance DOWNHost: oracleserver Port: 1521 SID: oracledb Oracle Home E:\oracle\p ...

Error in connecting to Oracle 10g Database

Can anybody please help me with these problems.1) Im trying to connect to my Database using Enterprise manager Database COntrol but it give me this message:=================================================Database Instance: BCMDDB Enterprise Manager is not able to connect to the database instance. T ...