Recently, I've just restored my QAS database and filesystem from my backup tape. I have checked all the configuration files and oracle setting files and do not notice any problem.
However, when I tried to start my listener, it shows some error messages as below. As a result, I'm unable to start my SAP application.
Error:
-------
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
For you information, I'm able to start my Oracle instance. Please refer to below.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5620367360 bytes
Fixed Size 2064184 bytes
Variable Size 2818572488 bytes
Database Buffers 2785017856 bytes
Redo Buffers 14712832 bytes
Database mounted.
oraqas 3> lsnrctl start
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 30-AUG-2010 12:57:25
Copyright � 1991, 2007, Oracle. All rights reserved.
TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /oracle/QAS/102_64/network/admin/listener.ora
Log messages written to /oracle/QAS/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=QAS.WORLD))
STATUS of the LISTENER
-------------------------------
Alias LISTENER
Version TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
Start Date 30-AUG-2010 12:57:29
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/QAS/102_64/network/admin/listener.ora
Listener Log File /oracle/QAS/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS.WORLD)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=QAS)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=drqaecc)(PORT=1527)))
Services Summary...
Service "QAS" has 1 instance(s).
Instance "QAS", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener Usage: /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbstart ORACLE_HOME Processing Database instance "orcl": log file /u01/app/oracle/product/11.2.0/dbhome_1/startup.log
how to set oracle listener ? i tried using listener.ora file again show the same error
I am having a problem getting my listener to start.
[oracle@jhlinux ~]$ lsnrctl start LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.1.0.6.0 - Production System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521))) [code]...
TNSLSNR for Linux: Version 11.1.0.6.0 - Production System parameter file is /oraeng/app/oracle/product/11.1.0/listener.ora Log messages written to /oraeng/app/oracle/product/11.1.0/log/diag/tnslsnr/server1/list/alert/log.xml TNS-01151: Missing listener name, list, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
Should i have to do some changes in sqlnet.ora for overriding the default settings?
I tried to reinstall oracle 11g on windows 2008 R2 and couldn't complete the installation as i am unable to start the oracle service. The system gives the following error message
Instance created. DIM-00019: create service error O/S-Error: (OS 1053) The service did not respond to the start or control request in a timely fashion.
I try to manually create the service and it gives me the same error.I also tried to start the service using the net start as follows
C:UsersAdministrator>net start oracleserviceprod The service is not responding to the control function.
Having looked at the event viewer in windows, I noticed three different error messages as followsr
Application popup: Microsoft Visual C++ Runtime Library : Runtime Error!
R6034 An application has made an attempt to load the C runtime library incorrectly.and then A timeout was reached (30000 milliseconds) while waiting for the OracleServiceprod service to connect.
The OracleServiceprod service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:Userssandifer>emctl start dbconsole Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. C:Userssandifer>SET ORACLE_HOSTNAME=localhost
[code].....
I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.
1. Install patch 6613550 (./rootpre.sh) 2. Install 10.2.0.1 for AIX 64-bit 3. Install 10.2.0.5 Patch Set 4. Create Database 5. Created/Setup LISTENER and TNSNAMES (test connection successful)
After installation of database, everything went well until we tried to restart the server, what happened is that we cannot start the listener, the error was:
TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00525: Insufficient privilege for operation IBM/AIX RISC System/6000 Error: 1: Not owner
What i did to resolve this problem is to change the owner of /tmp to oracle, after that i was able to start the listener. ($lsnrctl start) The problem is that our sys admin said that the /tmp directory is being used by the OS and it's owner must be root. But if i return it to root, the listener will not start again. (After server restart)
BTW, our /tmp has enough space so we did not perform the following steps from the installation guidelines:
TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production System parameter file is /u01/app/oracle/product/network/admin/listener.ora Log messages written to /u01/app/oracle/product/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.1.17.43)(PORT=1521))) TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA NL-00305: the specified path name does not exist
Listener failed to start. See the error message(s) above...
I am not using RAC (to my knowledge), but I installed grid so I can use ASM with my RDBMS.
Recently I noticed that the "CRS Listener" service was not started, when I try to start it then it immediately stops. It does not seem to affect the databases, they are still up and running. What is this service used for and how can I get it to start. I am using Oracle Enterprise Server 11.2.0.3 and Grid 11.2.0.3 on a Windows 2008 R2 64-bit server.
I am trying to use the Apex listener 2.0 (instead of HTTP server). I installed and went thru the configuration of the listener, but I must be missing something. When I do the java -jar apex.war to start it up in standalone mode, I get the configuration properties etc., but when I open up my browser and try to bring up APEX with http://localhost:8080/apex/ I get a 500 - Internal Server error with the info below.
***********ERROR*********** init: # headers=43 declare nm owa.vc_arr := ?; vl owa.vc_arr := ?; begin owa.init_cgi_env( ?, nm, vl ); htp.init; htp.HTBUF_LEN := 63; ? := sys_context('USERENV','SID'); end; SID:880 CALL: begin apex; commit; end; BINDS PAGE CALL: declare nlns number := 999999; l_clob CLOB; lines htp.htbuf_arr; l_buff varchar2(32767); l_clob_init boolean:= false; l_file varchar2(5); l_doc_info varchar2(1000); begin OWA.GET_PAGE(lines, nlns); if (nlns > 1) then for i in 1..nlns loop if ( length(lines(i)) > 0 ) then if ( ( lengthb(l_buff) + lengthb(lines(i))) > 32767) then if (NOT l_clob_init) then dbms_lob.createtemporary(l_clob, TRUE); dbms_lob.open(l_clob, dbms_lob.lob_readwrite); l_clob_init:=true; end if; dbms_lob.writeappend(l_clob,length(l_buff),l_buff); l_buff := lines(i); else l_buff := l_buff || lines(i); end if; end if; end loop; end if; if (l_clob_init) then
One of our requirements is to secure the listener and other Oracle services by running them as a local OS account rather than as LocalSystem on the server.
I created a local OS account (assume it's named oracleuser), assigned it to the User and ORA_DBA groups on the server, and then I went to the Local Policies and added oracleuser to "Deny log on locally" and "Log on as a service".
I opened up the Services utility and stopped the four Oracle services we have running (OracleMTSRecoveryService, xxx_home1iSQL*Plus, xxx_home1TNSListener, and OracleServiceMYDB). I changed the "Log on as" for each service to oracleuser with its password (copied and pasted so I know there are no typo's), and restarted the services.
All the services except the listener started up. Attempting to start the listener caused the following error:
"The xxx_home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."
I tried rebooting the server and had the same result.For now just the listener service has been switched back to logging in as LocalSystem while the other services continue to use the local OS account and the database seems stable, but I do need to figure this out.
I have setup a RAC machine of two nodes on Oracle 10GR2(with 10.2.0.4 Patchset). All setup went well. I am able to connect one node from sqlplus but the other node is connected to idle instance. I tried to startup the database with mount and nomount option but it fails. Following is the error :
SQL> startup nomount; ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/LCLCLKS/spfileLCLCLKS.ora' ORA-17503: ksfdopn:2 Failed to open file +DATA/LCLCLKS/spfileLCLCLKS.ora ORA-15077: could not locate ASM instance serving a required diskgroup SQL>
I am using ASM and it is running on both nodes even I am able to connect the SQL prompt from it. I am able to view the diskgroups I created from the second node but through "asmcmd" option I can't go inside the disk group. It gives :
ASMCMD> ls DATA/ INDEX/ ASMCMD> cd DATA asmcmd: diskgroup 'data' does not exist or is not mounted
On first node, everything is fine and I am able to import the database on it, as well.
SQL> startup ORACLE instance started. Total System Global Area 522092544 bytes Fixed Size 2090224 bytes
[code]...
Database altered.
SQL> select count(*) from scott.test; select count(*) from scott.test * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only
I am trying to modify an existing form in oracle apps. I copied all the necessary objects and modified the form. I can compile the object in windows. When I am trying to compile the object in Linux server using SSH I am getting the following error.
FRM-91500: Unable to start/complete the build.I am using the following command for compile
, I got the following error while trying to restart a 3 node RAC database. OEM reported two out of three nodes to be down. We also noticed that the cluster_database parameter was set to "False" and the cluster_database_instances integer was set to 1.We changed the parameters to 'True' and '3' respectively and while trying to restart the database we get the error message as shown below.
The resource action "ora.abc123.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode. For details refer to "(:CLSN00107:)" in
"/oradba/app/grid/11.2.0.3_a/log/abcde104/agent/crsd/oraagent_oradba/oraagent_oradba.log". CRS-2674: Start of 'ora.abc123.db' on 'abcde104' failedCRS-2632:
There are no more servers to try to place resource 'ora.abc123.db' on that would satisfy its placement policy
CRS-5017: The resource action "ora.abc123.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode.
For details refer to "(:CLSN00107:)" in "/oradba/app/grid/11.2.0.3_a/log/abcde103/agent/crsd/oraagent_oradba/oraagent_oradba.log". CRS-2674: Start of 'ora.abc123.db' on 'abcde103' failed
I'm trying to install Oracle 10g Enterprise Ed. (on Windows 2003 Std. Ed) and I get some errors:
First “Fail to start OCR” I press "continue" and the installation continue. Next “Operative System Error when start OracleCSService” and when I press "continue" the installation finish.
At the end of installation, It seems like Oracle DB is Ok, but not really...I can't connect to database from Enterprise Manager and the OracleCSService is in "Starting mode".
We have a server that crashed due to hardware failure and although brought back up OK Oracle DB's are no longer mounting. I am not a DBA but it looks bad to me and it seems there are no backups. This is Oracle 11G XE running on Centos 6. There is no Oracle contract here.
[root@627963 trace]# sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 12 23:18:26 2013
SQL> connect sys as sysdba; Enter password: Connected to an idle instance. SQL> startup ORACLE instance started.
Total System Global Area 1068937216 bytes Fixed Size 2233344 bytes Variable Size 893389824 bytes Database Buffers 167772160 bytes Redo Buffers 5541888 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 10571 Session ID: 62 Serial number: 3
SQL> startup /nomount SP2-0714: invalid combination of STARTUP options SQL> startup nomount ORA-24324: service handle not initialized ORA-01041: internal error. hostdef extension doesn't exist SQL>
I have just downloaded Oracle 11g from the Oracle website.How do I start enterprise manager?
but once I get away from UNIX I don't have a clue what I am doing. What are the windows bits. I go to the oracle bin directory from a dos window and enter emctl commands, and I get "emctl" is not recognised as an ibternal or external command.
I've installed oracle 11.2 in Windows 7 - 64 bits. Everything was working fine until suddenly stops working. Oracle Service (OracleServiceORCL) doesn't start and when I try to start manually, returns OS error 1067. Listener starts well. Below I list my listener.ora, sqlnames.ora and sqlnet.ora
I have oracle8i database on windows 2008 but not a domin server now i have domin server and i want to join this server on domin network i try to join domin it fine but my oracle8i service did not start what to do ?
old hostname=bagmati afterchange hostname=bagmati.alkatel.org.np
I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output Starting Oracle Net Listener...Done Configuring database...
Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details
When I look at the logs I get the following error ORA-01034: ORACLE not available. After receiving this error I have attempted to start Oracle manually.
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup ORA-00845: MEMORY_TARGET not supported on this system
As you can see I got
ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions
My Oracle jobs are not running. I can run them manually but they don't start automatically as per interval. The job_queue_processes=100 and CJQ process is not running. I started CJQ0 process by resetting it to 0 and then to 100. But as soon as I enabled a job this background process stopped.
The job also did not execute in its next execution time. I have created the database manually without using DBCA. Is the problem because of this? I have set crontab immediately to get rid of it.
