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 found:SQL> select QUEUE_TABLE from dba_queue_tables where owner='BIRJAC';no rows selectedThere is other method to find this table?The version of database is:SQL> select banner from v$version;BANNER Oracle8i Enterprise Edition Release 8.1.7.0.1 - ProductionPL/SQL Release 8.1.7.0.0 - ProductionCOR
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....
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 found 2 folders where the old IP is involved:<c:\oracle\ora1020\db01\192.168.188.71_dev01> and <c:\oracle\ora1020\db01\oc4j\j2ee\OC4J_DBConsole_192.168.188.71_dev01>I saw some articles, but didn’t find exact solution of my problem.I would appreciate very much any help regarding steps I s
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:==================================================drop user &1 cascade;drop tablespace &1 INCLUDING CONTENTS;drop tablespace &1.idx INCLUDING CONTENTS;create tablespace &1datafile 'c:\ORACLE\ORADATA\&1..dbf' size 3M reuse autoextend onnext 5M maxsize unlimited;create tablespace &1.idxdatafile 'c:\ORACLE\ORADATA\&1.idx.dbf
Here is the setup: Oracle 10g RAC on LinuxOracle instance fails to start due to invalid LOCAL_LISTENER parameter in Oracle spfile. It's a binary file and the only way to configure it to get rid of the invalid parameter is to run 'alter system set/reset .... LOCAL_LISTENER'.When I try this I get (no surprise):alter system reset LOCAL_LISTENER;alter system reset LOCAL_LISTENER*ERROR at line 1:ORA-01034: ORACLE not availableI can't start the instance to change the parameter and i cannot change the parameter in spfile until I start the instance.Is the a way out of this vicious cycle? Any advise wi
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't remember my system login and password? How do i resest these?ERROR:ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux Error: 2: No such file or directoryMessage was edited by: monteroMessage was edited by: montero
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 cerrada64-bit Windows Error: 109: Unknown error tks for you help
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
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 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database SID: NM45Listener port number: 1529Password for SYS user:Password for SYSMAN user:Password for SYSMAN user:Do you wish to continue? [yes(Y)/no(N)]: yJun 16, 2009 10:00:20 PM oracle.sysman.emcp.util.EMCALogManag
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 or alter user password, etc.Which views / synonyms I need to re-create? Where is the file location?
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 or alter user password, etc.Which views / synonyms I need to re-create? Where is the file location?
this again same old problem of listener.I have installed oracle 8 on my home pc RUNNING WIN2000 SP 4.The listenet runs fine when I am connected to the internet through dialup CONNECTION but fails when I am not connected .I donnt have a network adapter with my pc.How caN i run listener on a stand alone system ?the computer name is kabilpc........................................................Following error is spitted when I give start command from LSNRCTL80 System parameter file is d:\orant\NET80\admin\listener.orLog messages written to d:\orant\NET80\log\listener.logListening on: (ADDRESS=(P
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 says "LISTENER SUPPORTS NO SERVICES" , some of the listener message are: ****************************************************FIRST STOP THE LISTENERoracle@tux ~/product/10.1.0.3/bin $ ./lsnrctl stopLSNRCTL for Linux: Version 10.1.0.3.0 - Production on 02-DEC-2005 15:53:33Copyright (c) 1991, 2004, O
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. But oracle locks these files, so i cant delete them. if i shutdown the database and restart it, i can delete the files, but this solution is unacceptable.so my question is, can I drop this "oracle-reference" on the file to delete it?
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. We've got a couple procedures, triggers, etc. Then we recreate the user and all of their objects and initialize the database with some data. The problem I'm having is that on my machine (the other 2 developers do not have this problem), this drop user command takes over 1 minute. The whole time the c
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
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 existbeside, when run # /oracle_home/bin/ocmi login to the oracle management server and i tried the users:sysman, SYS, SYSTEM and the user of the globale database but it didnt workit gives error: unable to connect to the host, please verify the host name and the oracle management serverany suggestio
I have installed Oracle Work Flow 2.6.4 from companion CD on Oracle 10.2 (64bit)database.While I try to run the wf java listener $ORACLE_HOME/wf/admin/wfjvlsnr.cshI got the following message:no ocijdbc10 in java.library.pathConnected to OWF_MGR@RECU with character set UTF8Unable to connect to RECUHow can I resolve this?
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?
Can anyone please tell how to drop an Oracle JOB?
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.1.0 - Production on 16-JUL-2007 18:15:09Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /mnt/work/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /mnt/work/oracle/product/10.2.0/db_1/network/admin/listen
i'm using oracle 8.0.6. here is a copy of my tnsllistener.ora and tnsname.ora file when i'm starting oracle i get tns listener errors : TNS:12545, TNS-12560 AND TNS-00515. TNSLISTENER:LISTENER =(ADDRESS_LIST =(ADDRESS=(PROTOCOL= IPC)(KEY= oracle.world))(ADDRESS=(PROTOCOL= IPC)(KEY= ORCL))(ADDRESS=(PROTOCOL= IPC)(KEY= EXTPROC0))(ADDRESS=(COMMUNITY= NMP.world)(PROTOCOL= NMP)(SERVER= KCP)(PIPE= ORAPIPE))(ADDRESS= (PROTOCOL= TCP)(Host= KCP)(Port= 1521))(ADDRESS= (PROTOCOL= TCP)(Host= KCP)(Port= 1526))(ADDRESS= (PROTOCOL= TCP)(Host= 127.0.0.1)(Port= 1521))(ADDRESS= (PROTOCOL= SPX)(Service= KCP_lsnr
I am using Oracle8 Enterprise Edition Release 8.0.5.0.0 on Windows XPMy problem is thatWhen I tried to stop listener by using lsnrctl80 stop it gives me the subjected error,while when I stop the listener from Windows Servcies it stops successfully.Plz note that when I start listener by using lsnrctl80 start it starts successfully.Following is the information of listener.oraLISTENER =(ADDRESS_LIST =(ADDRESS= (PROTOCOL= TCP)(Host= it-rhassan)(Port= 1521)))STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = 0SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = i
in 8i, how to drop all oracle scheduled jobs ?Many
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/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /home/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.oraLog messages written to /home/oracle/app/oracle/product/10.2.0/db_1/network/log/listener.logError listen
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, but it will not be possible to start this listener until the conflict is resolved. Would you like to continue with the configuration anyway? Yes|NoIf I try to delete this conflicting LISTENER, the GUI screen says "Listener LISTENER was deleted", but my ssh session says:Oracle Net Services Configur
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 following error that i've got....when I edited my listener.ora file, type the host name using IP address got this error --> :TNS-12541: TNS:no listener [oracle@oracle4 ~]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 12-JUL-2008 11:31:17Copyright (c) 1991, 2005, Oracle. All rig
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 that are not possible to drop?
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 Name orcl Version 10.2.0.4.0 Host myhost Listener <**this is missing **> View All Properties Listener Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 64-bit Windows: Version
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.oraLISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))(ADDRESS = (PROTOCOL = TCP)(HOST = kankala.kalyan)(PORT = 1522))))my question is why the listener's names are same even though thy are on different ports?and for people worrying, why i have installed 10 n 11 is Inital
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: ankurEnterprise Manager is not able to connect to the database instance. The state of the components are listed below. Page Refreshed Jul 4, 2009 3:08:18 AM PDT On the login screen I see a down red arrow for the database instance that says:Host ankur.gateway.2wire.netPort 1521SID ankurOracle Home C:\app\AnkurA
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, or am I completely off base?Here is what my OEM looks like - !http://www.tomklonowski.com/lsnrstatus.PNG!Here is what lsnrctl status reports -LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-AUG-2009 20:33:19Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(AD
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 and the tnsnames.ora files of the server that is not receiving and it is well configured comparing it with the server that is receiving the redo logs. If I check the status of the listener: lsnrctl status listener_<node name>Both of the Standby servers look fine.But if I connect directly to the
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: TNS:no listener.The client DBA says the tnsnames and the listener.ora look correct. He has done the EMCA but still gets the error. This should be an easy problem to resolve but he's having issues.
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: please wait...TNSLSNR for Linux: Version 10.2.0.3.0 - ProductionSystem parameter file is /u01/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KE
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 insufficient privileges.i done grant all privileges to userthen also i could not drop the schema Give me Suggestions please
Im trying to create emca repository for my rac db but its failling with this error ...Invalid username/password or database/scan listener not up or database service is not registered with scan listener. emca -config dbcontrol db -repos create -clusterSTARTED EMCA at May 3, 2010 12:44:27 PMEM Configuration Assistant, Version 11.2.0.0.2 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved.Enter the following information:Database unique name: testService name: test.domain.comListener port number: 1529Listener ORACLE_HOME [ /u01/app/grid01 ]:Password for SYS user:Password for DBSNMP use
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 still able to fetch records from sql server which i don't want to happen.How to do this? Also i have problem restarting the listener when there is any session establshedSo whenever i want to stop the listener i want to kill the established session as well how to do this?
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 LISTENER_SCAN1 exists. Port: TCP:1521SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521[oracle@vm01 admin]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node vm02SCAN Listener LISTENER_SCAN2 is enabledSCAN listener LISTENER_SCAN2 is run
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 starts with installing the database according to the all in one book.Settings for installing a database (with DBCA):- custom database- ocp11g for global database name and SID- Same passwords for all accounts- Deselect all options except Enterprise Manager Repository- Deselect all standard database optio
I have a full oracle install on a desktop windows box for development.I develop on another desktop with Ubuntu 7.04. I use most oracle tools on the windows box but our build is quite well automated with a frequently used task to refresh the database. Part of this task, using ant, calls SQLPlus to set up various stored procs etc on the database.I have a tnsnames.ora set up as follows:ROWROW-JB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.369.430)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rowrow) ) ) Having this in place, the actual log i
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 the listener.ora and tnsname.ora file, it could be a problem ?Someone can tell me where I am wrong ?Below the command and the result: ./emca -deconfig dbcontrol db -repos drop (with a SID orcl and 1521 port).........CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /Oracle/app/oracle/product/11
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/app/oracle/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_dbu1vip_ssp not found. -bash-3.2$ emca -deconfig dbcontrol db -repos drop Jun 9, 2010 10:39:09 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControlCONFIG: ORA-12541: TNS:no listeneroracle.sysman.assistants.util.sqlEngine.SQLFatalEr
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 get class but thatdoesn't help me...
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.
I have installed Oracle 7.3.4 on a Win NT4 machine (old stuff, I know, but for a client) I have been following the guide provided by Oracle for this version and am at the point where I must start LSNRCTL and NAMESCTL. LSNRCTL starts automatically on startupNAMESCTL does not, and when I try to start it manually from cmd, I get the following output: NAMESCTL> startStarting "names.exe". . .Service OracleNamesService start pending.Service OracleNamesService started.service not started, errors followNNC-00002: error listening on stream (ADDRESS=(PARTIAL=yes)(PROTOCOL=spx))TNS-12538: TN
I'm trying to create a database link between two DB in the same DB domain but I received an error 'ORA-12203: TNS:unable to connect to destination'. I read the Oracle manual but cann't find the problem. Can any one give me a help!?SQL PULS Message #############################################SQL> select * from all_db_links;OWNER DB_LINK USERNAME HOST CREATED --------------- ---------- SCOTT TO_DB01.WORLD SCOTT TO_DB01 03/02/2002SQL> select * from scott.tab001@to_db01;select * from scott.tab001@to_db01*ERROR at line 1:ORA-12203: TNS:unable to connect to destination########################
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 code:2I don't know how to solve it. Can anyone help me?
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 listener ([oracle]$ lsnrctl start), logging to SQL*Plus ([oracle]$ sqlplus /nolog), connect (SQL> connect / as sysdba) and starting database (SQL> startup), here is what I get:SQL>startupORACLE instance started. Total System Global Area 43356200 bytesFixed Size 450600 bytesVariable Size 41943040
I'm trying to configure my listener so I can use COM automation and I'm getting ORA-28575. The documentation for this is kind of lacking. Here is my listener.ora and my tnsnames.ora. Any help would be appreciated.Thanks.# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.oraLISTENER = (DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = laptop2)(PORT = 1521))(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)))))STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = offSID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_N