Hi all,
This has been causing me endless problems for two days now and I desperately need to leave our database running before the weekend. I cloned our database and moved it to a new server following the instructions in this guide, after a quite a few attempts I finally managed to recreate the control files and startup the database but now it keeps crashing unexpectedly.
The database starts up fine and both the listener and our application are able to communicate with it but after 10-15 minutes, the listener will report ORA-12518 and the only errors I can find are in the clsc.log and css.log, these state;
2012-03-23 12:21:03.312: [ default][2004]ut_read_reg:2:ocr registry key SOFTWAREOracleolr cannot be opened. error 2
[CLSE][2004]clse_get_crs_home: Error retrieving OLR configuration [0] [Error opening olr registry key. The system cannot find the file specified.]
and
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: [network] error for endp 0C3BCA10, req 0C3BE270, type sgipcnreqtypeConnect (1), data 00000000, sret sgipcretConnectionRefused (28)
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos op : sgipcwWait
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos dep : The remote system refused the network connection. (1225)
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos loc : GetQueueComp
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos info: failed for over 0C3BDCC8
2012-03-23 14:36:37.523: [ CSSCLNT][5384]clssscConnect: gipc request to clsc://(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61100)) failed with 29 (00000013)
2012-03-23 14:36:37.523: [ CSSCLNT][5384]clsssInitNative: connect to (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61100)) failed, rc 29
The content of my listener.ora is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:Oracleproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS='EXTPROC_DLLS=ANY')
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:Oracleproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS='EXTPROC_DLLS=ANY')
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 158.41.215.112)(PORT = 1521))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
DEFAULT_SERVICE_LISTENER = (PVSSRDB)
and my tnsnames.ora is
PVSSRDB =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS = (PROTOCOL = TCP)(HOST = 158.41.215.112)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = PVSSRDB)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
I would appreciate any advice you can offer on this issue..
Edited by: JonathanR on 23-Mar-2012 07:53
Key Software Oracle Olr Cannot Be Opened.error 2013
Key Software Oracle Olr Cannot Be Opened.error 2 Free
ocr registry key SOFTWAREOracleolr cannot be openedDoesn't appear to be an XE install, just judging from your OH path but perhaps we can help anyways. And looks like CRS, cluster services, I don't have much practice on using that feature.
Wondering about the localhost:port at 127.0.0.1:61100 entry in listener.log, if you have multiple NICs or multiple ethernet interfaces set up, it might be trying to talk on the wrong interface. Verify the IP address. Which OS? Win7? XP? Server 2008? 2008R2?
Please post your ifconfig output, maybe there's a VPN adapter or another interface getting in the way.
$ ipconfig /all
.. Ethernet adapter Local Area Connection: ..
.. IP Address .. : 158.41.215.112
$ hostname
.. - hostname
$ nslookup 158.41.215.112
.. - hostname[.domain?]
$ nslookup hostname
.. -158.41.215.112 (?)
$ nslookup hostname.domainname
.. - 158.41.215.112 (?) An ora-12518 usually indicates a resource problem- low memory, process unable to start, something along those lines. How large is your SGA+PGA, and how much physical memory, and pagefile size, on the host?
Edited by: clcarter on Mar 23, 2012 12:25 PM
add -12518 note Similar Messages
HKEYLOCALMACHINE SOFTWARE ORACLE HKEYLOCALMACHINE SOFTWARE ORACLE KEY HOMENAME includes the following parameters for an Oracle home directory. Depending on products you install, additional parameters can also be created. See your Windows development manuals. The system cannot find the file specified. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 11-OCT-2016 09:46:10 Tracing not turned on.
Hello -
This is the error in grid alert:
Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
But the test of connection string in database configure screen is successful. tnsping works too.
Grid version: 11.2.0.1.0, no patches.
Target database version: 10.2.0.2
Connect string: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = s08) (PORT = 1528))) (CONNECT_DATA = (SID = S08) (GLOBAL_NAME = S08.WORLD)))
Any ideas?
OK. Are you testing the connectivity from 'Preferred Credentials ' setting page?
Try to configure target from
Targets--databases-- then select your database and click on 'configure' button.
Enter all the details and press 'Test Connection' button once it shows that connection is successful go to next page and finally save the setting.
Let me know how it goes..
Hello all,
Did anyone know why we get the error in the OEM grid:
Failed to connect to database instance: ORA-03135: connection lost contact (DBD ERROR: OCISessionBegin).
We checked the listener and it is running fine. Can someone advice where to look? Thanks.
Hello,
1. I tried to ping to the grid control server, and it was successful. However when reviewing the emagent.trc trace file, I noticed the following error:
SQL = '/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl'..
LOGIN = dbsnmp/PW@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mddbbanner8-vip)(PORT=1521))(CONNECT_DATA=(SID=PROD4)))
2009-01-13 10:44:31 Thread-4113849248 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent mddbbanner8_3872_PROD4 on PROD.loe.corp_PROD4: ORA-06550: line 1, column 65:
PLS-00201: identifier 'DBMS_AQADM' must be declared
ORA-06550: line 1, column 65:
PL/SQL: Statement ignored
2009-01-13 10:44:31 Thread-4113849248 ERROR recvlets.aq: unable to create subscription on oracle_database PROD.loe.corp_PROD4
2. In the emdctl.trc trace file, I see these errors:
2009-01-09 15:54:26 Thread-4136655072 WARN http: snmehl_connect: connect failed to (mddbbanner8:3872): Connection refused (error = 111)
2009-01-09 15:54:26 Thread-4136655072 ERROR main: nmectla_agentctl: Error connecting to https://mddbbanner8:3872/emd/main. Returning status code 1
3. Anyone experienced the same errors from 1 and 2 above? Any solution to this issue?
Thanks.
Hello All,
I am trying to connect to oracle database using an user_exit and not the built in LOGON function .
the user_exit - can connect to the DB ( I see a connection in v$session) , but when the form tries to perform any other action (like simple select ) i get a ora-3114 - not connected to oracle .
how ever if on the logon trigger instead of using the user_exit i use the built in logon - all is working fine.
my conclusion is that the user_exit , although connects to the oracle DB somehow does not 'populate' the connection to the forms
how come ?
why ?
any way to solve this issues ?
thanks
S.
p.s.
the reason i am trying to perform that is because the built in logon function, can not accept passwords which contains the @ sign .
USER_EXIT is used to call a function outside Forms. So, it creates a separate connection to the database. Your Forms session still has no connection.
I don't think there is any other way to connect Forms to the database than the LOGON built-in.
I have a 4 node cluster and getting this alert very ferquently..
checking audit_trail gives this error
SQL select count(*) from dba_audit_trail
2 ;
select count(*) from dba_audit_trail
ERROR at line 1:
ORA-01115: IO error reading block from file 1 (block 108673)
ORA-01110: data file 1: '+DG_PROD/ngprod/datafile/system.258.665846277'
ORA-15081: failed to submit an I/O operation to a disk
Documentation on error says.....
ORA-02002: error while writing to audit trail
Cause: The auditing facility is unable to write to the AUDIT_TRAIL table. If this error occurs, SQL statements that are currently being audited may also fail. This error will occur if the SYSTEM tablespace runs out of disk space.
Action: Add space to the SYSTEM tablespace or delete rows from the AUDIT_TRAIL table. If these operations fail or do not eliminate the problem, shut down and restart Oracle with auditing disabled. This is done by setting the initialization parameter AUDIT_TRAIL to FALSE.
How should I check the system tablespaces ..I'm getting the error..and moreover they are autoextendible..Any idea about the issue
You can check the space available in any tablespace with a query from dba_free_space;
Give serious consideration to moving AUD$ out of the system tablespace. Theoretically you can not do this prior to database 11.1.0.7 (where you can use the built-in package DBMS_AUDIT_MGMT.MOVE_DBAUDIT_TABLES). But if you open an SR at metalink they will instruct you to do it manually which keeps everything legal and supported.
http://www.morganslibrary.org/reference/dbms_audit_mgmt.html
Also look into using resumable transactions (DBMS_RESUMABLE) to keep these things from happening in the future.
http://www.morganslibrary.org/reference/dbms_resumable.html
guys,
i have a problem here with the connection between a client host and a server database, using a new non-default listener LISTENER_BKP_1. The error showed is:
ORA-12518: TNS:listener could not hand off client connection
i had learned about this error here before, and i toke some notes as follows:
h2. listener.log
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2009 01:23:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is C:oracleproduct10.2.0db_2networkadminlistener.ora
Log messages written to C:oracleproduct10.2.0db_2networkloglistener_bkp_1.log
Trace information written to C:oracleproduct10.2.0db_2networktracelistener_bkp_1.trc
Trace level is currently 0
Started with pid=2212
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WINXP)(PORT=1523)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-SEP-2009 01:24:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=PAULO))(COMMAND=services)(ARGUMENTS=64)(SERVICE=listener_bkp_1)(VERSION=169869568)) * services * 0
25-SEP-2009 01:24:49 * (CONNECT_DATA=(SERVICE_NAME=financeira.winxp)(CID=(PROGRAM=C:ORACLE?instantclient_10_2sqlplus.exe)(HOST=PAULO_NOTEBOOK)(USER=ORACLE_DBA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=51649)) * establish * financeira.winxp * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
25-SEP-2009 01:24:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=PAULO))(COMMAND=services)(ARGUMENTS=64)(SERVICE=listener_bkp_1)(VERSION=169869568)) * services * 0
h2. lsnrctl services
C:lsnrctl services listener_bkp_1
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2009 01:33:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WINXP)(PORT=1523)))
Services Summary..
Service 'FINANCEIRA.WINXP' has 1 instance(s).
Instance 'FINANCEI', status UNKNOWN, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:1
LOCAL SERVER
The command completed successfully
h2. listener.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FINANCEIRA.WINXP)
(SID_NAME = FINANCEI)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WINXP)(PORT = 1521))
SID_LIST_LISTENER_BKP_1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FINANCEIRA.WINXP)
(SID_NAME = FINANCEI)
LISTENER_BKP_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WINXP)(PORT = 1523))
h2. v$resource_limit
RESOURCE_NAME ; CURRENT_UTILIZATION ; MAX_UTILIZATION ; INITIAL_ALLOCATION ; LIMIT_VALUE
processes ; 26 ; 30 ; 150; 150
sessions ; 30 ; 35 ; 170 ; 170
2 rows selected
this means that it didn't reach the resource limites yet. What i can do to solve the problem ???
another important information is that connecting by the default listener LISTENER instead of the LISTENER_BKP_1 listener, the connection is completed successfully. There's enough SGA memory space too.
Tks,
Paulo_BR wrote:
i have a problem here with the connection between a client host and a server database, using a new non-default listener LISTENER_BKP_1. The error showed is:
ORA-12518: TNS:listener could not hand off client connectionDon't do Oracle on Windows, so I'm not sure how the following relates to the Listener dealing with a dedicated server connection request on Linux/Unix.
On Linux/Unix, a dedicated server request means just that - a dedicated process has to be started to service that client. The Listener does it by using the parameters of the configured listener.ora service to execute +$ORACLE_HOME/bin/oracle+. This process then starts up, and the Listener hands off the client connection for this process for servicing.
If there is a failure somewhere on this series of steps fail, the Listener throws the ORA-12518 exception. For example, the +$ORACLE_HOME+ has been incorrectly configured in listener.ora and it fails to execute and startup a dedicated server process.
And this relates to the underlying error you are seeing:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directoryI think that the Listener on Windows uses the CreateRemoteThread() Win32 call to start up the server process thread. However, it needs a valid process identifier (of the existing Oracle instance) for this call - and thus needs to first identify the Oracle instance process. Could be that this step uses a ORACLE_HOME reference. And if that directory path is not valid, it is unable to identify the process id of the Oracle instance and thus unable to spawn a dedicated thread to service that client.
I started getting the 'password has expired' error in my SOA server log today (six months after installing my SOA Suite 11.1.1.4 development environment). I found a tip in an old forum thread:
Failed to connect to database instance: ORA-28001: the password has expired
and changed the password expiration time as suggested, and bounced my SOA server hoping for the best. But I'm still getting the password has expired error. Is there a way to clear that out so that I don't have to go back and figure out which user(s) are being affected and what their passwords should be reset back to so that my SOA environment will work again? Thanks!
Hi,
Better to check the password_life_time unlimited for all your schemas, suppose your prefix is DEV you may have:
DEV_MDS
DEV_ORABAM
DEV_ORASDPM
DEV_SOAINFRA
Cheers,
Vlad
SQL Developer Blocked and is not allowed to connect to database gives ORA-200001.
i found on net that DBA can write triggers which can deny connection to database from certain appplication.
so i want a way to change application name so that when it connects to database
the V$SESSION will have different value (other than SQL Developer) in column PROGRAM and/or MODULE (which i think is used by dba to restrict the connection).
one more way is
i am using jdbc url to connect to database
in java we can change properties of connection to change the PROGRAM in V$SESSION.
but i am not java expert so dont know how and where to make the changes
either way my aim is to connect to database such that V$SESSION will have different value (other than 'SQL Developer') in column PROGRAM and/or MODULE
This is not system configration or credential issue.
This is a check which is put DBA using logon trigger
to check certain user loging in using certain application.
only some users using particular username are getting this error when they try to logon using oracle sql developer
the same users when uses different username(some generic user names created to access database) to access the same database then they are able to login.
similarly if they login using SQL navigator they are able to login with both their own and the generic user name
more over of all the database instances this is only happening on some of the instances and all of them are development instances.
following will help you understand
USER DBUSERNAME DATABASE APPLICATION ACTION
X X DB1 Oracle Sql Developer Blocked
X G(Genric) DB1 Oracle Sql Developer Login Success
X X DB1 Sql Navigator/SqlPLus Login Success
X G(Genric) DB1 Sql Navigator/SqlPLus Login Success
X X DB2 Oracle Sql Developer Login Success
X G(Genric) DB2 Oracle Sql Developer Login Success
X X DB2 Sql Navigator/SqlPLus Login Success
X G(Genric) DB2 Sql Navigator/SqlPLus Login Success
I just want to bypass this check which i think uses V$SESSION and columns PROGRAM and/or MODULE to check the application used by particular user.
if i can override these values some where in oracle sql developer before loging in the DB then i can clearly pass this check and login to database.
Edited by: user13430736 on Jun 21, 2011 4:05 AM
Edited by: user13430736 on Jun 21, 2011 4:12 AM
Hi There,
Let me brief you first how this prob arises:
I had run RCU for creating database schemas ...for that i have change my system processes to 300 to run RCU properly..
IT worked fine but after rebooting my system..when i try to connect the db thru sqldeveloper.. i am getting the error'Listener Refused the connection:ORA12519,TNS no appropriate service handler'...for which i have consulted the
ORA-12519 using thin JDBC client this forum one of the post suggested that change process to 150..
Now i have three points:
1.Can i also alter my system processes to make it work fine..?
2.Currently as i am trying to connect thru JDev it is throwing me an exception ' Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor'.. I guess this prob is due to aforesaid issue and it will work once the instance is up...
3.I have shutdown and startup my DB in cmd and it gives me message database mounted and opened ....does it means that db is working fine but still it wont be able to connected coz of process..
Vivekk
onnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary..
Service 'ProdDBXDB' has 1 instance(s).
Instance 'proddb', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 4552
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=63127))
Service 'orcl.India.TCS.com' has 1 instance(s).
Instance 'orcl', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'orclXDB.India.TCS.com' has 1 instance(s).
Instance 'orcl', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 2608
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59766))
Service 'proddb' has 1 instance(s).
Instance 'proddb', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'testdb' has 1 instance(s).
Instance 'testdb', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'testdbXDB' has 1 instance(s).
Instance 'testdb', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 2600
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59765))
The command completed successfully
One More Thing Niket ..when i try to connect my DB thru SQLDEVELOPER i get a different error
'Listener Refused the connection with following error:ORA-12519,TNS:no appropriate service handler found'..the desc of which i have written as a part of ques?
Hi,
I am attempting to connect to my Oracle Linux Machine which has 2 databases FROM my 10g Grid control which is on a Windows XP 32 bit.
Although I can login to the actual linux box with the host and database credentials ; I cant use the same to login to the database using Grid control.
I have tried testing the connection using Grid Control Preferences Preferred Credentials Host ; but its just not recognizing the credentials as correct.
When I attempt to startup the database using the host and DB credentials : ERROR MESSAGE : servername : servername comes up.
My agent on linux box is up. My Listener is running fine.
On my Grid control . i have the DB, OMS, and Agent running as well.
Any inputs on this issue, I'd appreciate very much.
Thanks for your reply.
Under Hosts on the Main Grid Console Home Page 'server3.sam' Status shows UP. This server houses my 2 databases. But when I click on Databases it shows Instance DOWN.
Status
Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
I have verified that my lsnrctl status is good on the linux box. My target agent is up and running on it as well.
So I try to start the STARTUP button I enter the HOST Credentials of the Linux box and the Database credentials which I use 'SYS' (in upper case - just in case that mattered) and choose SYSDBA ;
Error Message
server3.sam: server3.sam
I created a new dba account and try to login .. dont seem to work ; I tried using SYSTEM account and even altering my sys and system passwords . all turn out negative.
And the ANSWER to your question --- Grid Control Preferences Preferred Credentials Database Instance corresponding to my database name ; I enter my sysdba username / password AND the host username / password of my Linux box TEST which also turns out negative.
This entry is auto filled in since I 'checked' the box 'Save as Preferred Credential'; initially when I tried to start the DB using the STARTUP button.
By the way, my Win XP doesnt really have a password set under User accounts.
Any suggestions please ?
The witcher 3 wild hunt pc . Visit Tunefind for music from your favorite TV shows and movies. Find all 55 songs in The Witcher 3: Wild Hunt Soundtrack, with scene descriptions. Listen to trailer music, OST, original score, and the full list of popular songs in the film. Buy The Witcher 3: Wild Hunt Soundtrack. $10.99 Add to Cart. About This Content Venture into the rich and atmospheric world of The Witcher 3: Wild Hunt through the original game soundtrack. Track Listing. 1 'The Trail' 2:49 2 'Geralt of Rivia' 2:22 3 'Eredin, King of the Hunt' 2:27 4.
Hi folks, I recently changed the SID (but not name) of my database. Everything has been working great, but I get the following error message in OEM after it's been running for about 10 minutes:
Agent Connection to Instance
Status Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
Since everything else is running fine (everything else in OEM is working fine, network connections via SQL Developer, Toad, JDBC, I'm not sure where to look.
I also have a second server running (on which I haven't changed the SID) to compare to. Outputs of lsnrctl services, the tnsnames.ora file, and everything else seems to line up.
I'd be happy to post anything that might be useful, thanks very much!
Hello,
recently I was hitting the same problem:
Listener Status: Up
Agent Connection to Instance Status: Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
It turns out that the message is misleading and the problem lies in the locked dbsnmp account. I resolved that through
Grid Control / Targets / Search List / (Select DB with problems) - Configure
where it showed the following error:
'java.sql.SQLException: ORA-28000: the account is locked The Connect Descriptor was (description=(address=(host=xx)(protocol=tcp)(port=xxxx))(connect_data=(service_name=xx)(instance_name=xx)(UR=A)))
Change dbsnmp Password - The error message shown above indicates that the agent is unable to monitor this database because the agent cannot logon. To correct this, the Monitor Password needs to match the corresponding database password for dbsnmp. To change both the dbsnmp database password and the Monitor Password, click the Change dbsnmp Pasword button. This operation will also unlock the dbsnmp user.'
It is possible to change the password from that dialog what I did. It is working fine now.
I do not know if the problem lies in accout locked or wrong password after all, but repeating the configuration resolved the case.
Greetings
Remigiusz Boguszewicz
HI Experts,
Today i got this alert from oem grid during RMAN bakcup of the PROD database.when i try to connect the database i am able to get into to the DB successfully with out any issues.
But i am not sure why this error has come and resone behind that.Please advise.
From: Oracle OEM [mailto:[email protected]]
Sent: Tuesday, February 22, 2011 11:21 PM
To: DBA_GROUP
Subject: EM Alert: Critical:PROD.test.edu.au - Failed to connect to database instance: ORA-00257: archiver error. Connect internal only, until freed. (DBD ERROR: OCISessionBegin).
Target Name=PROD.test.edu.au
Target type=Database Instance
Host=delhi.win.test.edu.au
Occurred At=Feb 22, 2011 11:20:33 PM EST
Message=Failed to connect to database instance: ORA-00257: archiver error. Connect internal only, until freed. (DBD ERROR: OCISessionBegin).
Severity=Critical
Acknowledged=No
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN
when i check the alertlog file i could see the following
Tue Feb 22 23:01:36 2011
Starting control autobackup
Control autobackup written to DISK device
handle '/oracledb/rman_backup/PROD/control_c-197342269-20110222-01'
Tue Feb 22 23:22:42 2011
Errors in file /oracle/admin/PROD/udump/hubprd_ora_27069.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
PLease let me know the cause of the issues and solution to overcome this issues.
Regards,
Salai
It would appear that your archive location is full. If it is full, then try to get some more free space there by either deleting the old archives or specifying a different location.
I don't see any mention of a flash recovery area in the log message, but you may also want to confirm that you have reached your space allocated to the FRA.
OS: Windows2003 Standard Edition SP1
Oralce 10.2.0.1.0 for Micorsoft Windows(32bit)
I install Oracle 10.2 on Windows 2003, during installation, reports a waring at Product-Specific Prerequisite Checks:
Checking Network Configuration requirements ..Check complete. The overall result of this check is: Failed
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP.
I try to modify the Network config from assign IP address automatically to specify static IP address. then, Oralce can be installed successfully, and create database, connect to database.. all work well.
But once I do restart(stop/start) the database server, then the database can not be connected and report error ORA-12514. but I do not do any changes, only restart the database server.
I also try to configure LoopBack metioned in the warning message, but it does not work as well.
I try to install Oracle10.2 on other clean machines with different OS, like Windows XP sp2, I got the same result.
Also, I doubt database server does not really start when restarting it, although no error or warning is reported. because of I watch the system memory usage, I do not see any increase of memory when I start the database server, it's not normal.
I setup a Oralce10.1 server on the same machine, it has not this problem.
Could anyone help me to solve it?
Thanks verfy much.
Frank
below is my sqlnet.ora, listener.ora and tnsnames.ora .
sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadminsqlnet.ora
Generated by Oracle configuration tools.
This file is actually generated by netca. But if customers choose to
install 'Software Only', this file wont exist and without the native
authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
listener.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadminlistener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbserver5)(PORT = 1521))
tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadmintnsnames.ora
Generated by Oracle configuration tools.
ORA102EN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbserver5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora102en)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
------------------------------------------------------------------
Paste the results of tnsping ora102en, hope it's useful to find any clue.
C:Documents and SettingsAdministratortnsping ora102en
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-JUL-2
006 14:24:40
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:oracleproduct10.2.0db_1networkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbs
erver5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora10
2en)))
OK (30 msec)
hi ,
my name is varun
i am using oracle 9i on window xp
my clint and server r on same machine
i was working on the database with a non-sys user
suddenly i got one errror
tns packet faliue
then after that
ORA-12523: TNS:listener could not find instance appropriate for the client
connection
could u plz help me out and resolve this problem
thanx in advance
Varun,
There is no problem with listener registration, problem is with the database processes (allowed connections). If the max number of processes allowed is reached, pmon doesnt allow any new connection from listerner. that the root cause for this problem.
Fix:
Increase the number of process in initSID.ora to higher value and restart database.
1. edit the file D:oracleora92databaseinitdb01.ora
Processes=200 ----- any higher value required
2. login as sysdba Shutdown the database -----
3. startup database -----
SQL startup pfile=D:oracleora92databaseinitdb01.ora
Regards
Vignesh Bala
Message was edited by:
Vignesh Bala
Hi,
We had had some difficulties with our portal lately. All of a sudden portlets failed and started givin error messages all over our webpages.
I tried to login to EM Console to try and restart Portal OC4J and got this error
An error was encountered while loading page. An error occurred when attempting to connect to the Database.
Resolution:
Make sure that the database and listener are up.
If the database is up, make sure that the OracleAS Repository API files ias.properties and iasschema.xml are correctly configured.
If necessary, use the EM Console to reconfigure the host, user name and password associated with the database
Base Exception:
java.sql.SQLException
Listener refused the connection with the following error:
ORA-12500, TNS:listener failed to start a dedicated server process
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PORTAL.MSS.EDUS.SI)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASDB.MSS.EDUS.SI)))
. Listener refused the connection with the following error:
ORA-12500, TNS:listener failed to start a dedicated server process
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PORTAL.MSS.EDUS.SI)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASDB.MSS.EDUS.SI)))
In .INF/network/sqlnet.log
Fatal NI connect error 12500, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=portal.mss.edus.si)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=asdb.mss.edus.si)(CID=(PROGRAM=I:OracleINFApacheApacheApache.exe)(HOST=CLUSTER1)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 11-JUN-2007 13:00:24
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
After restart everything works as normal. Any ideas what went wrong, or where to look for some additional answers?
Black clover watch online, free . Ora12500 means your OS has run out of resources, so you cannot start a process on the Server Side. Post the complete error stack, the last lines show further information to troubleshoot this error. Maybe you are looking for Key Software Oracle Olr Cannot Be Opened.error 2013 Key Software Oracle Olr Cannot Be Opened.error 2 Free
I have successfully installed Windows 8.1 Pro 64-bit onto my Mid 2009 Macbook Pro 5,4. The installer from BootCamp 5.0.533.5033 would not run, but I installed one-by-one the files under Apple and then ran the 64-bit nVidia installlers. I have everyt
Hi all: I hava configed the security-constraint in web.xml, e.g : web-resource-nameAllAdmin/web-resource-name url-patternfaces/pub/staff/admin/*/url-pattern and in this security-constraint does not hava the role-name : role-nameMIR Cust
I am trying to syn a recording on my iMac to my iPhone 4S. I get the recording on the iPhone but it is light gray instead of black and doesn't play. What am I doing wrong?
HiBRBRi'm trying to run a shell on unix using this string:BRBRessmsh aggregazione_SE01BRBRThe aggregazione_SE02 file contains the following:BRBRlogin supervisor 'password' on sappdwh01;BRexecute aggregate process on database SE_02.S
Hello. I had big troubles with my computer, so i had to format it 3 or 4 times in the past week. Stupidly I forgot to deactivate my iTunes everytime. I even cant deactivate all of my Computers, since I already did that once last april (so i have to w
This has been causing me endless problems for two days now and I desperately need to leave our database running before the weekend. I cloned our database and moved it to a new server following the instructions in this guide, after a quite a few attempts I finally managed to recreate the control files and startup the database but now it keeps crashing unexpectedly.
The database starts up fine and both the listener and our application are able to communicate with it but after 10-15 minutes, the listener will report ORA-12518 and the only errors I can find are in the clsc.log and css.log, these state;
2012-03-23 12:21:03.312: [ default][2004]ut_read_reg:2:ocr registry key SOFTWAREOracleolr cannot be opened. error 2
[CLSE][2004]clse_get_crs_home: Error retrieving OLR configuration [0] [Error opening olr registry key. The system cannot find the file specified.]
and
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: [network] error for endp 0C3BCA10, req 0C3BE270, type sgipcnreqtypeConnect (1), data 00000000, sret sgipcretConnectionRefused (28)
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos op : sgipcwWait
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos dep : The remote system refused the network connection. (1225)
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos loc : GetQueueComp
2012-03-23 14:36:37.523: [ GIPCNET][5384] gipcmodNetworkAsyncComplete: slos info: failed for over 0C3BDCC8
2012-03-23 14:36:37.523: [ CSSCLNT][5384]clssscConnect: gipc request to clsc://(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61100)) failed with 29 (00000013)
2012-03-23 14:36:37.523: [ CSSCLNT][5384]clsssInitNative: connect to (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=61100)) failed, rc 29
The content of my listener.ora is
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:Oracleproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS='EXTPROC_DLLS=ANY')
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:Oracleproduct11.2.0dbhome_1)
(PROGRAM = extproc)
(ENVS='EXTPROC_DLLS=ANY')
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 158.41.215.112)(PORT = 1521))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
DEFAULT_SERVICE_LISTENER = (PVSSRDB)
and my tnsnames.ora is
PVSSRDB =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS = (PROTOCOL = TCP)(HOST = 158.41.215.112)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = PVSSRDB)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
I would appreciate any advice you can offer on this issue..
Edited by: JonathanR on 23-Mar-2012 07:53
Key Software Oracle Olr Cannot Be Opened.error 2013
Key Software Oracle Olr Cannot Be Opened.error 2 Free
ocr registry key SOFTWAREOracleolr cannot be openedDoesn't appear to be an XE install, just judging from your OH path but perhaps we can help anyways. And looks like CRS, cluster services, I don't have much practice on using that feature.
Wondering about the localhost:port at 127.0.0.1:61100 entry in listener.log, if you have multiple NICs or multiple ethernet interfaces set up, it might be trying to talk on the wrong interface. Verify the IP address. Which OS? Win7? XP? Server 2008? 2008R2?
Please post your ifconfig output, maybe there's a VPN adapter or another interface getting in the way.
$ ipconfig /all
.. Ethernet adapter Local Area Connection: ..
.. IP Address .. : 158.41.215.112
$ hostname
.. - hostname
$ nslookup 158.41.215.112
.. - hostname[.domain?]
$ nslookup hostname
.. -158.41.215.112 (?)
$ nslookup hostname.domainname
.. - 158.41.215.112 (?) An ora-12518 usually indicates a resource problem- low memory, process unable to start, something along those lines. How large is your SGA+PGA, and how much physical memory, and pagefile size, on the host?
Edited by: clcarter on Mar 23, 2012 12:25 PM
add -12518 note Similar Messages
HKEYLOCALMACHINE SOFTWARE ORACLE HKEYLOCALMACHINE SOFTWARE ORACLE KEY HOMENAME includes the following parameters for an Oracle home directory. Depending on products you install, additional parameters can also be created. See your Windows development manuals. The system cannot find the file specified. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 11-OCT-2016 09:46:10 Tracing not turned on.
Hello -
This is the error in grid alert:
Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
But the test of connection string in database configure screen is successful. tnsping works too.
Grid version: 11.2.0.1.0, no patches.
Target database version: 10.2.0.2
Connect string: (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = s08) (PORT = 1528))) (CONNECT_DATA = (SID = S08) (GLOBAL_NAME = S08.WORLD)))
Any ideas?
OK. Are you testing the connectivity from 'Preferred Credentials ' setting page?
Try to configure target from
Targets--databases-- then select your database and click on 'configure' button.
Enter all the details and press 'Test Connection' button once it shows that connection is successful go to next page and finally save the setting.
Let me know how it goes..
Hello all,
Did anyone know why we get the error in the OEM grid:
Failed to connect to database instance: ORA-03135: connection lost contact (DBD ERROR: OCISessionBegin).
We checked the listener and it is running fine. Can someone advice where to look? Thanks.
Hello,
1. I tried to ping to the grid control server, and it was successful. However when reviewing the emagent.trc trace file, I noticed the following error:
SQL = '/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.enabl'..
LOGIN = dbsnmp/PW@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mddbbanner8-vip)(PORT=1521))(CONNECT_DATA=(SID=PROD4)))
2009-01-13 10:44:31 Thread-4113849248 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent mddbbanner8_3872_PROD4 on PROD.loe.corp_PROD4: ORA-06550: line 1, column 65:
PLS-00201: identifier 'DBMS_AQADM' must be declared
ORA-06550: line 1, column 65:
PL/SQL: Statement ignored
2009-01-13 10:44:31 Thread-4113849248 ERROR recvlets.aq: unable to create subscription on oracle_database PROD.loe.corp_PROD4
2. In the emdctl.trc trace file, I see these errors:
2009-01-09 15:54:26 Thread-4136655072 WARN http: snmehl_connect: connect failed to (mddbbanner8:3872): Connection refused (error = 111)
2009-01-09 15:54:26 Thread-4136655072 ERROR main: nmectla_agentctl: Error connecting to https://mddbbanner8:3872/emd/main. Returning status code 1
3. Anyone experienced the same errors from 1 and 2 above? Any solution to this issue?
Thanks.
Hello All,
I am trying to connect to oracle database using an user_exit and not the built in LOGON function .
the user_exit - can connect to the DB ( I see a connection in v$session) , but when the form tries to perform any other action (like simple select ) i get a ora-3114 - not connected to oracle .
how ever if on the logon trigger instead of using the user_exit i use the built in logon - all is working fine.
my conclusion is that the user_exit , although connects to the oracle DB somehow does not 'populate' the connection to the forms
how come ?
why ?
any way to solve this issues ?
thanks
S.
p.s.
the reason i am trying to perform that is because the built in logon function, can not accept passwords which contains the @ sign .
USER_EXIT is used to call a function outside Forms. So, it creates a separate connection to the database. Your Forms session still has no connection.
I don't think there is any other way to connect Forms to the database than the LOGON built-in.
I have a 4 node cluster and getting this alert very ferquently..
checking audit_trail gives this error
SQL select count(*) from dba_audit_trail
2 ;
select count(*) from dba_audit_trail
ERROR at line 1:
ORA-01115: IO error reading block from file 1 (block 108673)
ORA-01110: data file 1: '+DG_PROD/ngprod/datafile/system.258.665846277'
ORA-15081: failed to submit an I/O operation to a disk
Documentation on error says.....
ORA-02002: error while writing to audit trail
Cause: The auditing facility is unable to write to the AUDIT_TRAIL table. If this error occurs, SQL statements that are currently being audited may also fail. This error will occur if the SYSTEM tablespace runs out of disk space.
Action: Add space to the SYSTEM tablespace or delete rows from the AUDIT_TRAIL table. If these operations fail or do not eliminate the problem, shut down and restart Oracle with auditing disabled. This is done by setting the initialization parameter AUDIT_TRAIL to FALSE.
How should I check the system tablespaces ..I'm getting the error..and moreover they are autoextendible..Any idea about the issue
You can check the space available in any tablespace with a query from dba_free_space;
Give serious consideration to moving AUD$ out of the system tablespace. Theoretically you can not do this prior to database 11.1.0.7 (where you can use the built-in package DBMS_AUDIT_MGMT.MOVE_DBAUDIT_TABLES). But if you open an SR at metalink they will instruct you to do it manually which keeps everything legal and supported.
http://www.morganslibrary.org/reference/dbms_audit_mgmt.html
Also look into using resumable transactions (DBMS_RESUMABLE) to keep these things from happening in the future.
http://www.morganslibrary.org/reference/dbms_resumable.html
guys,
i have a problem here with the connection between a client host and a server database, using a new non-default listener LISTENER_BKP_1. The error showed is:
ORA-12518: TNS:listener could not hand off client connection
i had learned about this error here before, and i toke some notes as follows:
h2. listener.log
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2009 01:23:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is C:oracleproduct10.2.0db_2networkadminlistener.ora
Log messages written to C:oracleproduct10.2.0db_2networkloglistener_bkp_1.log
Trace information written to C:oracleproduct10.2.0db_2networktracelistener_bkp_1.trc
Trace level is currently 0
Started with pid=2212
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WINXP)(PORT=1523)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
25-SEP-2009 01:24:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=PAULO))(COMMAND=services)(ARGUMENTS=64)(SERVICE=listener_bkp_1)(VERSION=169869568)) * services * 0
25-SEP-2009 01:24:49 * (CONNECT_DATA=(SERVICE_NAME=financeira.winxp)(CID=(PROGRAM=C:ORACLE?instantclient_10_2sqlplus.exe)(HOST=PAULO_NOTEBOOK)(USER=ORACLE_DBA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=51649)) * establish * financeira.winxp * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
25-SEP-2009 01:24:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=PAULO))(COMMAND=services)(ARGUMENTS=64)(SERVICE=listener_bkp_1)(VERSION=169869568)) * services * 0
h2. lsnrctl services
C:lsnrctl services listener_bkp_1
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 25-SEP-2009 01:33:40
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WINXP)(PORT=1523)))
Services Summary..
Service 'FINANCEIRA.WINXP' has 1 instance(s).
Instance 'FINANCEI', status UNKNOWN, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:1
LOCAL SERVER
The command completed successfully
h2. listener.ora file
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FINANCEIRA.WINXP)
(SID_NAME = FINANCEI)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WINXP)(PORT = 1521))
SID_LIST_LISTENER_BKP_1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = FINANCEIRA.WINXP)
(SID_NAME = FINANCEI)
LISTENER_BKP_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WINXP)(PORT = 1523))
h2. v$resource_limit
RESOURCE_NAME ; CURRENT_UTILIZATION ; MAX_UTILIZATION ; INITIAL_ALLOCATION ; LIMIT_VALUE
processes ; 26 ; 30 ; 150; 150
sessions ; 30 ; 35 ; 170 ; 170
2 rows selected
this means that it didn't reach the resource limites yet. What i can do to solve the problem ???
another important information is that connecting by the default listener LISTENER instead of the LISTENER_BKP_1 listener, the connection is completed successfully. There's enough SGA memory space too.
Tks,
Paulo_BR wrote:
i have a problem here with the connection between a client host and a server database, using a new non-default listener LISTENER_BKP_1. The error showed is:
ORA-12518: TNS:listener could not hand off client connectionDon't do Oracle on Windows, so I'm not sure how the following relates to the Listener dealing with a dedicated server connection request on Linux/Unix.
On Linux/Unix, a dedicated server request means just that - a dedicated process has to be started to service that client. The Listener does it by using the parameters of the configured listener.ora service to execute +$ORACLE_HOME/bin/oracle+. This process then starts up, and the Listener hands off the client connection for this process for servicing.
If there is a failure somewhere on this series of steps fail, the Listener throws the ORA-12518 exception. For example, the +$ORACLE_HOME+ has been incorrectly configured in listener.ora and it fails to execute and startup a dedicated server process.
And this relates to the underlying error you are seeing:
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directoryI think that the Listener on Windows uses the CreateRemoteThread() Win32 call to start up the server process thread. However, it needs a valid process identifier (of the existing Oracle instance) for this call - and thus needs to first identify the Oracle instance process. Could be that this step uses a ORACLE_HOME reference. And if that directory path is not valid, it is unable to identify the process id of the Oracle instance and thus unable to spawn a dedicated thread to service that client.
I started getting the 'password has expired' error in my SOA server log today (six months after installing my SOA Suite 11.1.1.4 development environment). I found a tip in an old forum thread:
Failed to connect to database instance: ORA-28001: the password has expired
and changed the password expiration time as suggested, and bounced my SOA server hoping for the best. But I'm still getting the password has expired error. Is there a way to clear that out so that I don't have to go back and figure out which user(s) are being affected and what their passwords should be reset back to so that my SOA environment will work again? Thanks!
Hi,
Better to check the password_life_time unlimited for all your schemas, suppose your prefix is DEV you may have:
DEV_MDS
DEV_ORABAM
DEV_ORASDPM
DEV_SOAINFRA
Cheers,
Vlad
SQL Developer Blocked and is not allowed to connect to database gives ORA-200001.
i found on net that DBA can write triggers which can deny connection to database from certain appplication.
so i want a way to change application name so that when it connects to database
the V$SESSION will have different value (other than SQL Developer) in column PROGRAM and/or MODULE (which i think is used by dba to restrict the connection).
one more way is
i am using jdbc url to connect to database
in java we can change properties of connection to change the PROGRAM in V$SESSION.
but i am not java expert so dont know how and where to make the changes
either way my aim is to connect to database such that V$SESSION will have different value (other than 'SQL Developer') in column PROGRAM and/or MODULE
This is not system configration or credential issue.
This is a check which is put DBA using logon trigger
to check certain user loging in using certain application.
only some users using particular username are getting this error when they try to logon using oracle sql developer
the same users when uses different username(some generic user names created to access database) to access the same database then they are able to login.
similarly if they login using SQL navigator they are able to login with both their own and the generic user name
more over of all the database instances this is only happening on some of the instances and all of them are development instances.
following will help you understand
USER DBUSERNAME DATABASE APPLICATION ACTION
X X DB1 Oracle Sql Developer Blocked
X G(Genric) DB1 Oracle Sql Developer Login Success
X X DB1 Sql Navigator/SqlPLus Login Success
X G(Genric) DB1 Sql Navigator/SqlPLus Login Success
X X DB2 Oracle Sql Developer Login Success
X G(Genric) DB2 Oracle Sql Developer Login Success
X X DB2 Sql Navigator/SqlPLus Login Success
X G(Genric) DB2 Sql Navigator/SqlPLus Login Success
I just want to bypass this check which i think uses V$SESSION and columns PROGRAM and/or MODULE to check the application used by particular user.
if i can override these values some where in oracle sql developer before loging in the DB then i can clearly pass this check and login to database.
Edited by: user13430736 on Jun 21, 2011 4:05 AM
Edited by: user13430736 on Jun 21, 2011 4:12 AM
Hi There,
Let me brief you first how this prob arises:
I had run RCU for creating database schemas ...for that i have change my system processes to 300 to run RCU properly..
IT worked fine but after rebooting my system..when i try to connect the db thru sqldeveloper.. i am getting the error'Listener Refused the connection:ORA12519,TNS no appropriate service handler'...for which i have consulted the
ORA-12519 using thin JDBC client this forum one of the post suggested that change process to 150..
Now i have three points:
1.Can i also alter my system processes to make it work fine..?
2.Currently as i am trying to connect thru JDev it is throwing me an exception ' Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor'.. I guess this prob is due to aforesaid issue and it will work once the instance is up...
3.I have shutdown and startup my DB in cmd and it gives me message database mounted and opened ....does it means that db is working fine but still it wont be able to connected coz of process..
Vivekk
onnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary..
Service 'ProdDBXDB' has 1 instance(s).
Instance 'proddb', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 4552
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=63127))
Service 'orcl.India.TCS.com' has 1 instance(s).
Instance 'orcl', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'orclXDB.India.TCS.com' has 1 instance(s).
Instance 'orcl', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 2608
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59766))
Service 'proddb' has 1 instance(s).
Instance 'proddb', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'testdb' has 1 instance(s).
Instance 'testdb', status READY, has 1 handler(s) for this service..
Handler(s):
'DEDICATED' established:0 refused:0 state:ready
LOCAL SERVER
Service 'testdbXDB' has 1 instance(s).
Instance 'testdb', status READY, has 1 handler(s) for this service..
Handler(s):
'D000' established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: 01HW191334, pid: 2600
(ADDRESS=(PROTOCOL=tcp)(HOST=01HW191334.India.TCS.com)(PORT=59765))
The command completed successfully
One More Thing Niket ..when i try to connect my DB thru SQLDEVELOPER i get a different error
'Listener Refused the connection with following error:ORA-12519,TNS:no appropriate service handler found'..the desc of which i have written as a part of ques?
Hi,
I am attempting to connect to my Oracle Linux Machine which has 2 databases FROM my 10g Grid control which is on a Windows XP 32 bit.
Although I can login to the actual linux box with the host and database credentials ; I cant use the same to login to the database using Grid control.
I have tried testing the connection using Grid Control Preferences Preferred Credentials Host ; but its just not recognizing the credentials as correct.
When I attempt to startup the database using the host and DB credentials : ERROR MESSAGE : servername : servername comes up.
My agent on linux box is up. My Listener is running fine.
On my Grid control . i have the DB, OMS, and Agent running as well.
Any inputs on this issue, I'd appreciate very much.
Thanks for your reply.
Under Hosts on the Main Grid Console Home Page 'server3.sam' Status shows UP. This server houses my 2 databases. But when I click on Databases it shows Instance DOWN.
Status
Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
I have verified that my lsnrctl status is good on the linux box. My target agent is up and running on it as well.
So I try to start the STARTUP button I enter the HOST Credentials of the Linux box and the Database credentials which I use 'SYS' (in upper case - just in case that mattered) and choose SYSDBA ;
Error Message
server3.sam: server3.sam
I created a new dba account and try to login .. dont seem to work ; I tried using SYSTEM account and even altering my sys and system passwords . all turn out negative.
And the ANSWER to your question --- Grid Control Preferences Preferred Credentials Database Instance corresponding to my database name ; I enter my sysdba username / password AND the host username / password of my Linux box TEST which also turns out negative.
This entry is auto filled in since I 'checked' the box 'Save as Preferred Credential'; initially when I tried to start the DB using the STARTUP button.
By the way, my Win XP doesnt really have a password set under User accounts.
Any suggestions please ?
The witcher 3 wild hunt pc . Visit Tunefind for music from your favorite TV shows and movies. Find all 55 songs in The Witcher 3: Wild Hunt Soundtrack, with scene descriptions. Listen to trailer music, OST, original score, and the full list of popular songs in the film. Buy The Witcher 3: Wild Hunt Soundtrack. $10.99 Add to Cart. About This Content Venture into the rich and atmospheric world of The Witcher 3: Wild Hunt through the original game soundtrack. Track Listing. 1 'The Trail' 2:49 2 'Geralt of Rivia' 2:22 3 'Eredin, King of the Hunt' 2:27 4.
Hi folks, I recently changed the SID (but not name) of my database. Everything has been working great, but I get the following error message in OEM after it's been running for about 10 minutes:
Agent Connection to Instance
Status Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
Since everything else is running fine (everything else in OEM is working fine, network connections via SQL Developer, Toad, JDBC, I'm not sure where to look.
I also have a second server running (on which I haven't changed the SID) to compare to. Outputs of lsnrctl services, the tnsnames.ora file, and everything else seems to line up.
I'd be happy to post anything that might be useful, thanks very much!
Hello,
recently I was hitting the same problem:
Listener Status: Up
Agent Connection to Instance Status: Failed
Details Failed to connect to database instance: ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach).
It turns out that the message is misleading and the problem lies in the locked dbsnmp account. I resolved that through
Grid Control / Targets / Search List / (Select DB with problems) - Configure
where it showed the following error:
'java.sql.SQLException: ORA-28000: the account is locked The Connect Descriptor was (description=(address=(host=xx)(protocol=tcp)(port=xxxx))(connect_data=(service_name=xx)(instance_name=xx)(UR=A)))
Change dbsnmp Password - The error message shown above indicates that the agent is unable to monitor this database because the agent cannot logon. To correct this, the Monitor Password needs to match the corresponding database password for dbsnmp. To change both the dbsnmp database password and the Monitor Password, click the Change dbsnmp Pasword button. This operation will also unlock the dbsnmp user.'
It is possible to change the password from that dialog what I did. It is working fine now.
I do not know if the problem lies in accout locked or wrong password after all, but repeating the configuration resolved the case.
Greetings
Remigiusz Boguszewicz
HI Experts,
Today i got this alert from oem grid during RMAN bakcup of the PROD database.when i try to connect the database i am able to get into to the DB successfully with out any issues.
But i am not sure why this error has come and resone behind that.Please advise.
From: Oracle OEM [mailto:[email protected]]
Sent: Tuesday, February 22, 2011 11:21 PM
To: DBA_GROUP
Subject: EM Alert: Critical:PROD.test.edu.au - Failed to connect to database instance: ORA-00257: archiver error. Connect internal only, until freed. (DBD ERROR: OCISessionBegin).
Target Name=PROD.test.edu.au
Target type=Database Instance
Host=delhi.win.test.edu.au
Occurred At=Feb 22, 2011 11:20:33 PM EST
Message=Failed to connect to database instance: ORA-00257: archiver error. Connect internal only, until freed. (DBD ERROR: OCISessionBegin).
Severity=Critical
Acknowledged=No
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN
when i check the alertlog file i could see the following
Tue Feb 22 23:01:36 2011
Starting control autobackup
Control autobackup written to DISK device
handle '/oracledb/rman_backup/PROD/control_c-197342269-20110222-01'
Tue Feb 22 23:22:42 2011
Errors in file /oracle/admin/PROD/udump/hubprd_ora_27069.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 2
PLease let me know the cause of the issues and solution to overcome this issues.
Regards,
Salai
It would appear that your archive location is full. If it is full, then try to get some more free space there by either deleting the old archives or specifying a different location.
I don't see any mention of a flash recovery area in the log message, but you may also want to confirm that you have reached your space allocated to the FRA.
OS: Windows2003 Standard Edition SP1
Oralce 10.2.0.1.0 for Micorsoft Windows(32bit)
I install Oracle 10.2 on Windows 2003, during installation, reports a waring at Product-Specific Prerequisite Checks:
Checking Network Configuration requirements ..Check complete. The overall result of this check is: Failed
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP.
I try to modify the Network config from assign IP address automatically to specify static IP address. then, Oralce can be installed successfully, and create database, connect to database.. all work well.
But once I do restart(stop/start) the database server, then the database can not be connected and report error ORA-12514. but I do not do any changes, only restart the database server.
I also try to configure LoopBack metioned in the warning message, but it does not work as well.
I try to install Oracle10.2 on other clean machines with different OS, like Windows XP sp2, I got the same result.
Also, I doubt database server does not really start when restarting it, although no error or warning is reported. because of I watch the system memory usage, I do not see any increase of memory when I start the database server, it's not normal.
I setup a Oralce10.1 server on the same machine, it has not this problem.
Could anyone help me to solve it?
Thanks verfy much.
Frank
below is my sqlnet.ora, listener.ora and tnsnames.ora .
sqlnet.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadminsqlnet.ora
Generated by Oracle configuration tools.
This file is actually generated by netca. But if customers choose to
install 'Software Only', this file wont exist and without the native
authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
listener.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadminlistener.ora
Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbserver5)(PORT = 1521))
tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadmintnsnames.ora
Generated by Oracle configuration tools.
ORA102EN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbserver5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora102en)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
------------------------------------------------------------------
Paste the results of tnsping ora102en, hope it's useful to find any clue.
C:Documents and SettingsAdministratortnsping ora102en
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-JUL-2
006 14:24:40
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:oracleproduct10.2.0db_1networkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cnpb-dbs
erver5)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora10
2en)))
OK (30 msec)
hi ,
my name is varun
i am using oracle 9i on window xp
my clint and server r on same machine
i was working on the database with a non-sys user
suddenly i got one errror
tns packet faliue
then after that
ORA-12523: TNS:listener could not find instance appropriate for the client
connection
could u plz help me out and resolve this problem
thanx in advance
Varun,
There is no problem with listener registration, problem is with the database processes (allowed connections). If the max number of processes allowed is reached, pmon doesnt allow any new connection from listerner. that the root cause for this problem.
Fix:
Increase the number of process in initSID.ora to higher value and restart database.
1. edit the file D:oracleora92databaseinitdb01.ora
Processes=200 ----- any higher value required
2. login as sysdba Shutdown the database -----
3. startup database -----
SQL startup pfile=D:oracleora92databaseinitdb01.ora
Regards
Vignesh Bala
Message was edited by:
Vignesh Bala
Hi,
We had had some difficulties with our portal lately. All of a sudden portlets failed and started givin error messages all over our webpages.
I tried to login to EM Console to try and restart Portal OC4J and got this error
An error was encountered while loading page. An error occurred when attempting to connect to the Database.
Resolution:
Make sure that the database and listener are up.
If the database is up, make sure that the OracleAS Repository API files ias.properties and iasschema.xml are correctly configured.
If necessary, use the EM Console to reconfigure the host, user name and password associated with the database
Base Exception:
java.sql.SQLException
Listener refused the connection with the following error:
ORA-12500, TNS:listener failed to start a dedicated server process
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PORTAL.MSS.EDUS.SI)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASDB.MSS.EDUS.SI)))
. Listener refused the connection with the following error:
ORA-12500, TNS:listener failed to start a dedicated server process
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PORTAL.MSS.EDUS.SI)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ASDB.MSS.EDUS.SI)))
In .INF/network/sqlnet.log
Fatal NI connect error 12500, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=portal.mss.edus.si)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=asdb.mss.edus.si)(CID=(PROGRAM=I:OracleINFApacheApacheApache.exe)(HOST=CLUSTER1)(USER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 11-JUN-2007 13:00:24
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
After restart everything works as normal. Any ideas what went wrong, or where to look for some additional answers?
Black clover watch online, free . Ora12500 means your OS has run out of resources, so you cannot start a process on the Server Side. Post the complete error stack, the last lines show further information to troubleshoot this error. Maybe you are looking for Key Software Oracle Olr Cannot Be Opened.error 2013 Key Software Oracle Olr Cannot Be Opened.error 2 Free
I have successfully installed Windows 8.1 Pro 64-bit onto my Mid 2009 Macbook Pro 5,4. The installer from BootCamp 5.0.533.5033 would not run, but I installed one-by-one the files under Apple and then ran the 64-bit nVidia installlers. I have everyt
Hi all: I hava configed the security-constraint in web.xml, e.g : web-resource-nameAllAdmin/web-resource-name url-patternfaces/pub/staff/admin/*/url-pattern and in this security-constraint does not hava the role-name : role-nameMIR Cust
I am trying to syn a recording on my iMac to my iPhone 4S. I get the recording on the iPhone but it is light gray instead of black and doesn't play. What am I doing wrong?
HiBRBRi'm trying to run a shell on unix using this string:BRBRessmsh aggregazione_SE01BRBRThe aggregazione_SE02 file contains the following:BRBRlogin supervisor 'password' on sappdwh01;BRexecute aggregate process on database SE_02.S
Hello. I had big troubles with my computer, so i had to format it 3 or 4 times in the past week. Stupidly I forgot to deactivate my iTunes everytime. I even cant deactivate all of my Computers, since I already did that once last april (so i have to w
