ORA-12500 / TNS - Listener Failed To Start A Dedicated Server Process

Dec 12, 2011

We are getting the below error in between from database. The database throws the below error some times only not continuous.

ORA-12500, TNS:listener failed to start a dedicated server process.

View 6 Replies


ADVERTISEMENT

Networking And Gateways :: Listener Error - Failed To Start

Sep 23, 2011

after creating database i try to start listener i have copied listener.ora and edit according to db created i have folling issues.

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 23-SEP-2011 15:02:05

Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/bin/tnslsnr: please wait...

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...

View 16 Replies View Related

Networking And Gateways :: Listener Start Failed After Configuring?

Nov 2, 2011

i could not able to add and open listener to install Oracle database 11g R2 on window 7 ( 64 bit OS).

Steps :

1) i installed Oracle 11g R2 Software Only.

2) Started DBCA to configure Database

3) I got a message that i need to configure Listener first.

4) I opened NETCA and add a listener ( default name LISTENER)

5) Then re-opened DBCA to start Database configuration and found the same message configure listner.

6) I went to control panel-> Services -> i found no listeners there

7) i started NETMGR and add a listner and its location as well I started DBCA and found the same message add listener

9) i opened LSNRCTL and typed the command to START LISTENER and i found no listener error

10) When i am trying to add listener using NETCA ,during it's last step listener adding completion i found the below message :

Oracle Net Services Configuration:
Stopping Oracle Net Listener:
Running Listener Control:
d:apporacleproduct11.2.0dbhome_1inlsnrctl stop LISTENER
Listener Control complete.
Listener stop failed.

[code]....

View 4 Replies View Related

Server Administration :: Cannot Start Listener (/tmp Related)

May 9, 2012

OS: AIX 6.1 64bit
DB: Oracle 10gR2 (10.2.0.5.0)

What we did is..

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:

$TEMP=/directory
$TMPDIR=/directory
$export TEMP TMPDIR

I was thinking if that we must make a temp directory for oracle and set it in the profile, or change the owner to root again and perform this:

$chown -R oracle:oinstall /tmp
$chmod -R 777 /tmp

View 2 Replies View Related

Dedicated Vs Shared Server Mode

Sep 17, 2013

Why for dedicated server mode session memory is alloted from PGA and same in shared server mode by SGA ??

View 4 Replies View Related

Server Administration :: How To Check Whether Database Is Dedicated Or Shared

Feb 3, 2012

How to check whether database is dedicated or shared ?

View 1 Replies View Related

Networking And Gateways :: Shared Or Dedicated Server - Configuration

Feb 6, 2012

I've below questions about my raised topic.

1. How would I know whether I'm running Shared Server or Dedicated Server?
2. How to configure Shared Server?
3. How to configure Dedicated Server?
4. How Can I use both these connection types with one database?

I mean one session with dedicated and one with shared at the same time.

View 5 Replies View Related

PL/SQL :: Failed To Process SQL Command

Apr 29, 2013

There is a stored procedure to which i am trying to schedule, but getting error as below:" Failed to process SQL command

-ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at line 2 "

I am not getting where issue is, as i am new to ORCL SQL Dev.

View 5 Replies View Related

Enterprise Manager :: DBConsole Failed To Start?

Apr 26, 2007

When i am trying to start dbconsole, it throughs error:

oracle@aaa:aaa:>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.4
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://aaa:5500/em/console/aboutApplication

[Code].....

View 9 Replies View Related

TNS-01153 / Failed To Process String

Aug 3, 2010

Long running data extract executed from SQL SERVER into Oracle.Process runs long time then chokes. What breaks after the process is running ?

03-AUG-2010 05:00:10 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4498)) * establish * MyDB * 0
03-AUG-2010 05:00:11 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4500)) * establish * MyDB * 0
03-AUG-2010 05:00:12 * (CONNECT_DATA=(SERVICE_NAME=MyDB)(CID=(PROGRAM=C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtshost.exe)(HOST=SQLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xx.x.xxx)(PORT=4502)) * establish * MyDB * 0
03-AUG-2010 05:00:14 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)
(SERVICE=LISTENER)(VERSION=153092864)) * status * 0

[code]....

View 1 Replies View Related

Unable To Start Oracle Listener

Aug 30, 2010

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.

Starting /oracle/QAS/102_64/bin/tnslsnr: please wait...

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

View 6 Replies View Related

Real Application Clusters :: VKTM Process Taking Longtime To Start In RAC Environment?

Jun 30, 2012

I'm having a 2node 11.2.0.3 RAC setup with ASM on Solaris 10 x64 platform.During the restart of the database, it is taking longtime to start around 10mins.

View 3 Replies View Related

Oracle Solaris 11 Database Control Failed To Start Set ORACLE_UNQNAME

Apr 20, 2013

Oracle Solaris 11
Oracle Database 11.2.0.3

Create a new database using dbca and at the end dbca reports it could not start database control.

The dbca warning window asks to set ORACLE_UNQNAME and to start database control again.

su - oracle
$ . oraenv
rcat
export ORACLE_UNQNAME=rcat
emctl stop dbconsole
emctl start dbconsole
failed...

I tried that and dbconsole still cannot start.

View 3 Replies View Related

Database Failed To Start Up - ORA-03113 / End-of-file On Communication Channel

Jun 19, 2012

We had power failure, and i had to restore the database from offline backup.after restore i tried to start the database and i received following errors.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 663961600 bytes
Fixed Size 2184056 bytes
Variable Size 394267784 bytes
Database Buffers 260046848 bytes
Redo Buffers 7462912 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

[code]....

I reviewed the /oracle/PRD/saptrace/diag/rdbms/prd/PRD/incident/incdir_583361/PRD_ora_7179_i583361.trc, it hugh file with alot of Jargon.

View 7 Replies View Related

Networking And Gateways :: Unable To Start Listener

Mar 1, 2011

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]...

View 36 Replies View Related

Networking And Gateways :: Unable To Start Listener?

Feb 27, 2011

I could not able to start the listener if i have named it other than the default name: LISTENER and the default Port:1521

if I name it list and port : 9999 it is throwing an error as

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-FEB-2011 13:02:23

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting /oraeng/app/oracle/product/11.1.0/bin/tnslsnr: please wait...

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?

View 17 Replies View Related

Automatic Storage Management :: How To Start CRS Listener Service / What Is It Used For

Apr 25, 2013

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.

View 2 Replies View Related

Backup & Recovery :: Unable To Auto-start Oracle Net Listener

Dec 30, 2011

when i try to run dbstart i got Message like "

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

View 3 Replies View Related

Application Express Listener :: 2.0 Configured But Can't Start In Standalone Mode

Feb 25, 2013

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

[code]....

View 4 Replies View Related

Export/Import/SQL Loader :: DMP File In Oracle XE - Failed To Process Parameters

Jul 18, 2012

I am getting the following error while trying to import dmp file in oracle xe:

D:>imp system/manager file=pune_ucf.dmp tables=(ARR_TOT, DE
P_TOT) grants=no indexes=no rows=yes ignore=yes log=loc.log buffer=100000000;
LRM-00104: '100000000;' is not a legal integer for 'buffer'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully.

View 2 Replies View Related

Networking And Gateways :: TNS Listener Service Won't Start After Changing (Logon As) Setting

Mar 22, 2010

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.

View 2 Replies View Related

Listener Operation - Log Entry Corresponding To Failed Connection?

Dec 10, 2012

I have a DB on my local machine and it was working fine till yesterday.Today suddenly I started receiving error "IO Error : The Network Adapter Could not establish the connection".

1) My first question is that is there some log entry corresponding to this failed connection attempt in listener.log or alert.log ? If yes, how to identify it ?

2) My second question is : What to deduct from listener logs pasted below?I know about "service_update" messages, but what about others (having CONNECT_DATA in them) ? Also, what is "WARNING: Subscription for node down event still pending" in below logs ?

......
10-DEC-2012 12:48:18 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))(SERVER=dedicated)(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58460)) * establish * orcl * 0
10-DEC-2012 12:48:20 * service_update * orcl * 0
10-DEC-2012 12:51:35 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))

[code]...

View 4 Replies View Related

Reports Process Not Terminated Database Session After Reports Request Failed

Oct 12, 2012

why Database session was not terminated for failed reports request processed by reports engine.

My engine element parameters are as followed:

<engine minEngine="3" maxIdle="30" maxEngine="16" id="rwEng" engineResponseTimeOut="10" engLife="50" class="oracle.reports.engine.EngineImpl">
<property value="/home/TMAP/KO/shared/reports" name="sourceDir"/>
<property value="no" name="keepConnection"/>
<property value="no" name="diagnosis"/>
</engine>
<engine minEngine="0" maxEngine="1" id="rwURLEng" engLife="50" class="oracle.reports.urlengine.URLEngineImpl"/>

View 6 Replies View Related

Installation :: Fail To Start OCR And OS / Error When Start OracleCSService

Jun 5, 2012

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".

View 3 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Not Able To Start Apache Server?

Sep 11, 2013

Machine details : UNIX machine Solaris 10 OS.I am not able to start the apache server using opmnctl startall command. i am getting the below error message

QUOTE Error
--> Process (pid=823)
failed to start a managed process after the maximum retry limit
Log:
/usr/local/oracle/OH_STANDOHS/opmn/logs/HTTP_Server~1

Even i tried killing the process id = 823 , i am getting the same error message with different process id.

View 1 Replies View Related

Server Administration :: Unable To Start Second Node In RAC

Mar 16, 2011

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.

View 9 Replies View Related

Server Administration :: Getting Error When Start Database 10g

May 4, 2010

I start my database and suddenly got this error:

ORA-00371: not enough shared pool memory, at least 72102521958 bytes

How to fix? I use startup command only and shutdown when shutdown the database.

View 2 Replies View Related

Server Administration :: Oracle 8i Service Did Not Start

Apr 27, 2013

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

View 3 Replies View Related

Production Database Server Process

Apr 27, 2013

Oracle 11g default server process is dedicated select distinct server from v$session; dedicated

Which server process is used in the oracle 11g Production? if the database is connect to an online application?

View 19 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved