| connection issue........! [message #121360] |
Fri, 27 May 2005 14:47  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai all,
here in our firm , we could not able to connect the client to the database. it gives ora-12154 error. we have checked listener.ora , tnsnames.ora and sqlnet.ora. everything seems to be perfect.following are the .ora files
sqlnet.ora
-----------
# SQLNET.ORA Network Configuration File: d:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
listener.ora
-------------
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(
)
tnsnames.ora
-------------
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
DB_A.B.C.D=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DB)
(SERVER = DEDICATED)
)
)
plz help out in this issue.
regards
bala
|
|
|
|
|
|
| Re: connection issue........! [message #121367 is a reply to message #121364] |
Fri, 27 May 2005 15:26  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
thanks a lot for ur reply...alas........! still blowing the same error ora-12154.what to do..?
following are the changes done
listener.ora
------------
# LISTENER.ORA Network Configuration File: d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = tcms)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = tcms)
)
)
sqlnet.ora file commented out and tnsnames.ora is allright.
regards
bala
|
|
|
|
| Re: connection issue........! [message #121403 is a reply to message #121367] |
Sat, 28 May 2005 07:33 |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
post what you have done ( with clear formats. use [ code ] your posting [ /code ].
comment of sqlnet.ora (server)
Post your tnsnames.ora (cleint side)
post your listener.ora ( server)
session that restarts the listener.
session that tnspings your databaseserver ( tnsping service_name).
session that gives error (sqlplus username/pass@service_name).
[Updated on: Sat, 28 May 2005 07:34] Report message to a moderator |
|
|
|
| Re: connection issue........! [message #121916 is a reply to message #121403] |
Wed, 01 June 2005 14:36 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
mahesh,
see , our database server is in linux
and the client is win2k professional
following is for ur reference that u asked.
----Tnsnames.ora / client-side---------
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TCMS_192.168.0.250 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MUTATION)
(SERVER = DEDICATED)
)
)
TCMS.TRICOMPTECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MUTATION)
)
)
-------Listener.ora / server-side-------
# LISTENER.ORA Network Configuration File: /mnt/ora_system/oracle/901/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =A.B.C.D)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /mnt/ora_system/oracle/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME= MUTATION)
(ORACLE_HOME = /mnt/ora_system/oracle/9.2.0)
(SID_NAME = MUTATION)
)
)
sqlnet.ora is not in the server-side.
tnsping <service_name> gives as follows
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 01-JUN-2005 10:53:49
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = A.B.C.D) (PORT =1521))) (CONNECT_DATA = (SERVICE_NAME=MUTATION)))
OK (0 msec)
help out to connect the client.
regards
bala
|
|
|
|
| Re: connection issue........! [message #122051 is a reply to message #121916] |
Thu, 02 June 2005 10:17 |
|
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
tnsping should be executed from the client side.
and as per your posting
TCMS.TRICOMPTECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A.B.C.D)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MUTATION)
)
)
The service name was my example. Replace with yours.
[Updated on: Thu, 02 June 2005 10:19] Report message to a moderator |
|
|
|
| Re: connection issue........! [message #122052 is a reply to message #122051] |
Thu, 02 June 2005 10:22 |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
mahesh,
the service name is with ours only..no problem on that..now a new problem arises with ora-12535 and not with ora-12154.
see , in our firm database server is in LINUX and the clients are all in windows 2000. in a particular system which is not in network , a separate system, we want that system to connect to the database server.but it blows ora-12535.i have pinged that server's ip in the system which gives request timed out.while the system is having the separate line of internet.how to connect to the database.help out in this issue..?
tnsnames.ora and sqlnet.ora are as said earlier.
regards
bala
|
|
|
|
|
|
|
|
| Re: connection issue........! [message #135297 is a reply to message #121360] |
Tue, 30 August 2005 17:33 |
gatita
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
Greetings,
I'm having similar problems with a slightly different twist. I installed 9i on a Solaris 9 box. The initial configuration has the server and client on the same machine; this is the "slightly different twist". The following conditions exist on the client/server machine:
1. No database has been built; this was my intent. I want to start an Oracle instance with the "nomount" option (SGA + background processes)
2. I have defined a listener named, densrvcs.xxx.yyyy.zzz. I can start the listener by using the following command:
% lsnrctl densrvcs.xxx.yyyy.zzz
The following message is returned while the listener is starting: The listener supports no services
3. I have used "tnsping" as follows and it returns no errors:
% tnsping densrvcs.den.esri.com
4. My listener.ora has the following listener defined:
densrvcs.den.esri.com =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = am)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = densrvcs)
)
)
5. I have added the following two lines to the bottom of my sqlnet.ora file:
NAMES.DEFAULT_DOMAIN = den.esri.com
NAMES.DIRECTORY_PATH = (TNSNAMES)
6. My tnsnames.ora file has the following entries:
densrvcs.den.esri.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = am)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = densrvcs)
)
)
7. listener.ora, sqlnet.ora, and tnsnames.ora are all located in the following directory:
$ORACLE_HOME/network/admin
Now to my questions:
1. I get the ora-12154 error when the following commands are used:
% sqlplus /nolog
SQLPLUS> startup nomount <<------------- Error occurs here
What service name should I be using? I have densrvcs.den.esri.com in both my listener.ora and tnsnames.ora files. When the client and server are the same machine do I need a listener and/or a tnsnames file?
I have tried the network configuration assistant with the same result.
Thanks for reading and I'd appreciate any help you can provide.
Mike
|
|
|
|
|
|
| Re: connection issue........! [message #135426 is a reply to message #135301] |
Wed, 31 August 2005 09:23 |
gatita
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
Thanks for the response.
echo $ORACLE_SID
densrvcs
% sqlplus /nolog
sql> startup nomount pfile='$ORACLE_HOME/dbs/initdensrvcs.ora';
Same error: ora-12154
Is the command, "sqlplus /nolog" part of the problem?
Mike
|
|
|
|
|
|
| Re: connection issue........! [message #135440 is a reply to message #135433] |
Wed, 31 August 2005 10:08 |
gatita
Messages: 3
Registered: July 2005
|
Junior Member |
|
|
| Mahesh Rajendran wrote on Wed, 31 August 2005 09:44 |
did you configure initdensrvcs.ora?
and remove all the entries in sqlnet.ora
|
> did you configure initdensrvcs.ora?
I set db_name=densrvcs
Since I'm starting an idle instance is this parameter required?
I set db_domain=xx.yyyy.zzz
> and remove all the entries in sqlnet.ora
yes
Mike
[Updated on: Wed, 31 August 2005 10:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
