Re: ora-12514

2002-04-05 Thread Suzy Vordos
Also create links for the *.ora files from /var/opt/oracle to $ORACLE_HOME/network/admin of each Oracle version, and set TNS_ADMIN variable to /var/opt/oracle. For multiple ORACLE_HOME's, write a script that prompts the user to enter ORACLE_SID, then set ORACLE_HOME from oratab for that ORACLE_S

RE: ora-12514

2002-04-05 Thread Gene Sais
for unix think env var TNS_ADMIN for nt think registry entry TNS_ADMIN. >>> [EMAIL PROTECTED] 04/05/02 01:07PM >>> Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and

RE: ora-12514

2002-04-05 Thread Hamid Alavi
Actualy I have 8.1.6 & 8.1.7 on sun solaris not NT, the things which confusing me is the first day after installation I could connect to database and every thing was fine till I shutdown the database after taht I couldn't conect at all & all the time get ora-12514 ERROR!!! don't find any thing bet

RE: ora-12514

2002-04-05 Thread Sutton, Reed
Hamid, Are you using Unix? If you are, put your sqlnet.ora and tnsnames.ora in a generic location so that all homes can access them. For instance, on HP-UX we put them in /etc and on Solaris we put them in /var/opt/oracle. That way all the different versions are accessing the same files, no ma

RE: ora-12514

2002-04-05 Thread Hamid Alavi
Tom, I have checked all the tnsname & sqlnet.ora for both side client & server nothing have been changed after I shutdown the database, I have a question how come it was working perefect before I shutdown the database, don't know when you shutdown it's change some thing on tnsname etc.. or not???

RE: ora-12514

2002-04-05 Thread Mercadante, Thomas F
Hamid, I got stung with this just yesterday. Look closely at the TNSNAMES file. Check this example: WTWT_DBDOL0A1ADVWTW = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Dbdol0a1advwtw)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = wtwt)(SERVER = DEDICATE

Re: ora-12514

2002-04-04 Thread Suzy Vordos
Check the value of service_names: SQL> show parameter service_names Then make sure your tnsnames.ora uses SERVICE_NAME (not SID) within CONNECT_DATA and the value of SERVICE_NAME matches the value returned by the above query (normally db_name.db_domain) CONNECT_DATA=(SERVICE_NAME=db_nam

RE: ora-12514

2002-04-04 Thread DENNIS WILLIAMS
Hamid - I would check your ORACLE_SID, ORACLE_HOME settings. Are you using TWO-TASK environment variable? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 04, 2002 5:12 PM To: Multiple recipients of list ORACLE-L Hi list, I asked this quest

Re: ORA-12514

2001-09-25 Thread Ron Rogers
Brian, In order for you to connect to the Oracle database on server A from server B you have to have the server A instance defined in the TNSnames.ora on server B. From the ORA message it appears that it in not defined and/or you do not have the IP address of server A in the server B host file

Re: ORA-12514

2001-09-25 Thread Ruth Gramolini
Do you have that database in the tnsnames on the machine you are trying to access it from? If not, put if into the tnsnames file on that machine. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 25, 2001 12:20 PM > H

RE: ORA-12514

2001-09-25 Thread Ahmed Gholam Hussain
Hi Brian , U need to define the service name in your TNSNAMES.ORA file ...Or use NET8 Easy Config define to define that .. U can find the TNSNAMES.ORA under Oracle home It looks like the following : Service Name .WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PR

RE: ORA-12514 TNS names could not resolve service name

2001-02-07 Thread Myers, Laura H, SITS
PROTECTED]] > Sent: Thursday, February 01, 2001 2:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ORA-12514 TNS names could not resolve service name > > Rick: > In tnsnames.ora, is the entry listed as "satt.world" ? > If so, then chec

Re: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Oliver Artelt
Don't forget your domain in tnsnames.ora. A serv.= or serv.mydomain.com should work. oli On Thursday 01 February 2001 19:33, [EMAIL PROTECTED] wrote: > Hi All, > > NT 4/Oracle 8.1.6 > > I can do a tnsping satt. The entry is in tnsnames.ora. When I try to > connect using sqlplus > I get ora-125

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Gogala, Mladen
Try TWO_TASK on Unix, LOCAL on NT or ORA_DFLT_HOSTSTR on the NT predecessor. -Original Message- Sent: Thursday, February 01, 2001 2:33 PM To: Multiple recipients of list ORACLE-L So you want to connect without the @string system/password as opposed to system/password@orcl? -O

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Cale, Rick T (Richard)
I want to connect using the @service_name > -Original Message- > From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 01, 2001 2:33 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ORA-12514 TNS names could not resolve service name &

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Ruiz, Mary A (CAP, CDI)
Rick: In tnsnames.ora, is the entry listed as "satt.world" ? If so, then check the sqlnet.ora file, to see if there is a line names.default_domain = world Just a shot in the dark, Mary Ruiz / Atlanta GA -Original Message- Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipi

RE: ORA-12514 TNS names could not resolve service name

2001-02-01 Thread Kevin Kostyszyn
So you want to connect without the @string system/password as opposed to system/password@orcl? -Original Message- T (Richard) Sent: Thursday, February 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L Hi All, NT 4/Oracle 8.1.6 I can do a tnsping satt. The entry is in tns