Networking And Gateways :: What Does Status UNKNOWN Mean For A Service
May 26, 2010
I get this error when I try to connect to this database service as another user. I can connect to it as sys without any problem and the database is up.
And when I check to see whether the listener is running for that service, using lsnrctl status command, it shows that the service is UNKNOWN. What does this status mean?
> sqlplus usera/password@prod
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 25 14:50:35 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 25-MAY-2010 22:56:22
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=xxx)(Port=1521))
STATUS of the LISTENER
[code]....
View 8 Replies
ADVERTISEMENT
Dec 18, 2003
I installed Oracle 9i under W2K with preconfigured DB (SID=ORCL), after that I intalled Oracle developer suite and everything is OK but, When I created second DB (SID=SUMM), I get "ORA-12154: TNS:could not resolve service name" when I tried to connect with :
SQL> connect sys/oracle@summ as sysdba
NB: I have no problem when I use
SQL> connect sys/oracle@orcl as sysdba
Below, are my SQLNET.ORA, TNSNAMES.ORA, LISTENER.ORA files
# SQLNET.ORA Network Configuration File: C:oracleora90networkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
[code]....
View 39 Replies
View Related
May 15, 2013
What I'm trying to do Establish a remote connection to an Oracle 9i R2 9.2.0.8.0 database using "Oracle Provider for OLEDB 9.2.0.7.0" (I was unable to find an 9.2.0.8.0 equivalent) on a Windows Server 2008 R2 64-bit machine.
My configuration
sqlnet.ora
# SQLNET.ORA Network Configuration File: D:oracleora92
etworkADMINsqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DEFAULT_DOMAIN = B81DCS.COM
SQLNET.AUTHENTICATION_SERVICES= (NTS)
[code]....
View 21 Replies
View Related
May 14, 2013
My database is oracle 9i when try to connect oracle database using putty to AIX server like..
$ sqlplus
SQL*Plus: Release 9.2.0.8.0 - Production on Wed May 15 09:50:01 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys@testdb as sysdba
Enter password: (given password)
(then showing the following Error message)
ERROR:
ORA-12154: TNS:could not resolve service name
But I try to connect using SQLPlus window then it is successfully connected also if i try to connect using command line window like..
C:>sqlplus /
Enter user-name: sys@testdb as sysdba
Enter password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
JServer Release 9.2.0.8.0 - Production
SQL> select name from v$database;
NAME
---------
TESTDB
then it is also successfully connected to database..what is the problem .
my TNSLISTENER.ora file is
# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SINGERDB =
(DESCRIPTION =
(ADDRESS_LIST =
[code]....
View 7 Replies
View Related
Jan 31, 2013
ORA-12518 Tns: Listener does not currently know of service
from application server using client 10g to connect our database.This problem happens only in application server and we tried from another server we can connect to database easily but problem only in application server.
this error since TNSNAMES and network are properly hosted since there no network disconnection betwwen database server and application server.
View 1 Replies
View Related
Dec 24, 2010
My server database is not connected today whenever I try to connect it. It was working properly till yesterday but today morning when I came to office and want to connect with server then my database server show the message "ORA-12154 TNS: could not resolve the service name" and not connected.
View 9 Replies
View Related
May 19, 2010
I can able to login to the database through an user A. But when I try login as B,I am getting the follwing error. ORA-12154: TNS:could not resolve service name...I am using the following method.
1. Login to the database server via putty.
2. sqlplus A/****
for the user A,the step2 is working fine. But the same step is failing for the user B.And the user B is trying to connect to the database from the same server as the user A logged in to the database successfully.
db01: sqlplus B/*****
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 19 13:12:52 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
Enter user-name: I don't know why this error is coming for a particular user only.
View 21 Replies
View Related
Nov 18, 2012
I am getting the following error.
C:>sqlplus sys/oracle@duptest as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Nov 18 17:58:22 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Enter user-name:
My tnsnames.ora is as follows:
# tnsnames.ora Network Configuration File: C:appAliproduct11.2.0dbhome_1NETWORKADMIN nsnames.ora
# Generated by Oracle configuration tools.
DUPTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LRTU6C15D75.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = duptest.localdomain)
[code]....
The command completed successfully
View 6 Replies
View Related
Jan 25, 2010
im getting error ORA-12514.our prod db runs under default listener.nw i have configured another listener.if i try to connect from the loacl im grtting above error,bt im able to tnsping from the local system.
View 8 Replies
View Related
Oct 4, 2011
I am trying to connect to Oracle 11g using ODBC.I created a data source name from Admistrative Tools->ODBC Data Sources.I selected Oracle in OraClient11g_home1 as the driver. I tested the connection and it was succesful.I tried to connect from visual studio. I used the Data Source as Microsoft ODBC Data SOurce. Selected my DSN from drop down (LORAC). I gave the user name and password and got the followign errors:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
This is my tnsnames.ora located in C:oracleproduct11.1.0client_1
etworkadmin directory.
# tnsnames.ora Network Configuration File: C:oracleproduct11.1.0client_1
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
LORAC =
(DESCRIPTION =
[code]...
When i do tnsping LORAC, i get OK. When I do tnsping of the other service name i get Failed. However when I try to connect to that service from Visual studio I get a differnt set of errors:
ORA-12154: TNS:could not resolve the connect identifier specified
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I had assumed that as the test connection from ODBC Administrator had worked I would be able to connec to my database from viusal studio. Is there something wrong in my tnsnames.ora? The content or its directory location?
View 8 Replies
View Related
May 13, 2013
I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.
after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.
ORA-12154: TNS:could not resolve service name
for the same reason my scheduled cron tab can not run export backup. cron tab error is
EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully
I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is
# ls -l admin
total 112
-rw-r--r-- 1 oracle oinstall 14661 Apr 26 2002 libnk59.exp
-rw-r--r-- 1 oracle oinstall 643 Apr 26 2002 libnk59.imp
-rw-r--r-- 1 oracle oinstall 5728 Apr 26 2002 libnrad9.exp
[code]....
View 5 Replies
View Related
Nov 13, 2011
I have a requirement wherein I need to access the MS ACCESS database table from Oracle Client.I have created ODBC data source and have configured tnsnames.ora and listener.ora for the same. As a next step I am trying to configure HS init file for hsodbc connection but couldn't find the directory hs in $ORACLE_HOME (<ORACLE_HOME>hsadmininit******.ora). Any patch that needs to be applied for hsodbc connection in the server.
View 3 Replies
View Related
Feb 9, 2010
I have oracle 11g on windows xp. I can connect to oracle by SQL Plus without any problem, but when i want to connect to oracle by Toad or SQuirrel i see this error:
PTM Coding: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
my listner.ora and tnsnames.ora come below:
listner.ora:
# listener.ora Network Configuration File: C:appKiarashproduct11.1.0db_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
[Code].....
View 4 Replies
View Related
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
Feb 21, 2010
I want connect mssql in oracle by orale Gateways 11g
my environment:
windows Wista
oracle 11.1.0.7.0
Oracle Database Gateways 11.1.0.7.0
SQL SEVER2008
these soft in one computer.
my steps :
1. set initdg4mssql.ora
2.set listener.ora
3. set tnsnames.ora
4.start lsnrctl
5.use SYSTEM/ORACLE@DZCDB
logined. create dblink and test.
but it's error. i want to know where is the error.
View 1 Replies
View Related
Jun 26, 2013
I am working on people-soft, currently i am installing it but i found this error
ORA-12154: TNS:could not resolve the connect identifier specified
/*---------------------------------------------*/
this is listener.ora
# listener.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadminlistener.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_HRCS9 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db)
(PROGRAM = extproc)
)
)
/*---------------------------------------------*/
tnsnames.ora
# tnsnames.ora Network Configuration File: C:oracleproduct10.2.0db
etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
HRCS9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = umhs-86cd1970f)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
/*----------------------------------------------------*/
sqlnet.ora
# 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)
/*--------------------------------------------------------*/
View 1 Replies
View Related
Oct 8, 2012
I have one production server with oracle 11g R2 DB. I have to change Server Hardware and thats why I have to install oracle 11g R2 DB on New hardware and test it. I had installed DB with software only option and copied the cold backup of production server. The hostname and ip address of both the servers are different. I had change the "db_domain" parameter into init.ora with the hostname.Now my question is that can the same db runs on the same network with different hosts. Change of "db_domain" parameter into the init.ora is enough or i have to follow some other procedure.
View 12 Replies
View Related
Jan 24, 2005
I´m working with Oracle 9.2.0 / HP-UX and I need to configure two different listeners for the same server using different IP address.
View 12 Replies
View Related
Jul 5, 2012
I am trying to create a database link from the 11g database to the 10g database using:
create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>;
It Returns
Database link created.
select sysdate from dual@ORCL10R2 returns error:
ERROR at line 1:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
what changes I need to make to tnsnames and listener at both servers.
View 8 Replies
View Related
Dec 12, 2011
How to change listerner.ora name ? I want to have something like that application.ora instead of listener.ora.
View 9 Replies
View Related
Nov 2, 2011
I installed Oracle Express on my Windows 2003 Enterprise server. And right off the bat I cannot connect to it via command line. I have googled and read many sites, but am still getting the same error, no matter what I do. I am newbie again (was a DBA in 1990...when I used to have the same error and fix it in seconds...not sure why this problem still lingers in Oracle) so most likely I am overlooking something. Below are my tnsnames.ora and liserner.ora files
tnsnames.ora
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
[code]....
# 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)
View 19 Replies
View Related
Mar 28, 2011
My client get the error Ora-12514 when he tries to connect to the db.Well;
1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.
View 12 Replies
View Related
Apr 11, 2012
Im planning to install OID. I will use it for Oracle Net name resolution and Enterprise User Security.
How is this product licensed? Is it included in a enterprise rdbms license?
View 2 Replies
View Related
Jul 13, 2010
I have an Access DB which I'm using to connect to an Oracle DB at work. There are several Oracle DB's that I can connect to using Access but this one I'm not able to connect to. I get the Oracle error ORA-25153 Temporary Table Space is empty.
I don't have the ability to make changes to the Oracle DB only to read and query.
View 1 Replies
View Related
Jul 5, 2012
When I run the below query, the session got the below errors exactly after 1 hour. I checked profile, resource limit, and sqlnet.expire_time. The SQLNET.EXPIRE_TIME value is 10. Except expire time there is time limit in profile and resource. I dont know how this session is losting connection exactly after 1 hour. What could be the issue here and what else need to check it?
14:34:09 SQL> << DELETE query >>
ERROR:
ORA-03114: not connected to ORACLE
DELETE FROM amsoftinstall
[code]...
SQL> select * from V$RESOURCE_LIMIT;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- ---------------------------------------- -------------------------
-------
processes 37 49 150 150
sessions 44 56 170 170
[code]...
SQL> select * from USER_RESOURCE_LIMITS;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
[code]...
View 1 Replies
View Related
Aug 23, 2007
I'd got this error, TNS-12542, address already in used on my multithreaded application.
After finding some documents about this error, it happen because other application used same port as my listener. But i'd assured that only my listener, but it didn't happen in the first running process, but after some processes (hundreds of processes).
View 4 Replies
View Related
May 29, 2012
what is ISP concept in Oracle10g???
View 2 Replies
View Related
Sep 22, 2011
I am facing a issue on DBCA Installation, when i tried from off-shore.
a. When Iam connecting a server using production / Model VPN , and try to start Installing DBCA Using X11-Forwarding of putty,
b. DBCA installation Started but its tooo Slow, it takes more than 3Hrs (Started at 9AM and ends at 11.17AM)
c. First time it fails and second time its went to success, Whereas when i take alog of server ping request - I am getting a frequent "Requested time out" due to network fluctuation.
So let me know is the network fluctuation affects the Installation through VPN, if So how to overcome and is any workaround on that ?
View 4 Replies
View Related
Jun 6, 2011
We're deploying a new product release however this build uses Oracle 11G. We want to perform a side by side install for testing purposes. These are low usage systems so installing another Oracle build will not hinder the system.
We intend to test for a couple of weeks and migrate data, then uninstall the 10G. I'm in the process of installing 11G now, the 10G is up and running. I don't want to impact the 10G install. I'm installing 11G in /home/oracle/oracle11G directory. I would like to use 1 Listener.ora file. I've broken down the install bellow.
10G
SID "processing"
Oracle home /home/oracle/oracle10g
/mnt/Oracle/Oracle10GData
/mnt/Oracle/OracleRedoLog
11G
SID "processing11G"
Oracle home /home/oracle/oracle11g
/mnt/Oracle/Oracle11GData
/mnt/Oracle/Oracle11GRedoLog
I've copied the listener.ora file bellow.
LISTENER_PROCESSING =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= X (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521))
[code].......
LISTENER_PROCESSING2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X (PORT = 1522))
[code]......
Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.
View 1 Replies
View Related
Mar 11, 2013
I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?
Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.
View 3 Replies
View Related
