Updating tnsnames ora

03-Jan-2015 10:09 by 9 Comments

Updating tnsnames ora - Live sex chat with old woman

On unix systems, both double quotes " and single quotes ' will do: exp [email protected]'(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=test.com)(PORT\=1527)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))' and exp [email protected]"(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=test.com)(PORT\=1527)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))" work both An environment variable can be used ( both quotes ): export DB="(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=test.com)(PORT\=1527)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))" exp [email protected]$DB No spaces are allowed in the string in either case; this will not work because of the space after the = sign: "(DESCRIPTION\= (ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=test.com)(PORT\=1527)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))" On Windows ( Windows client but db on a unix server ), only double quotes " work.

You can put this entry in a file and use a short name instead of it.

If you are asking: can I put something like: myconnection= (description=(.....)) in my and then somehow use it but override the service name on the command line, that would be "no" you either use an alias or you do not.

Why do Oracle clients need to use such complicated connect strings to reach a server?

Other brands of DBs only need to know the hostname of the server (and optionally port number), username, password, and name of the database.

Hi I am trying to use SQLPlus to connect to database directly using just the connect string (ie without referencing to tnsnames.ora) I have this in my POD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = PODS. COM)(PORT = 1521)) ) (CONNECT_DATA = (SID = ODS) ) ) I can connect to the database if I use the command below, obviously the SQLPlus is refering the that I have) sqlplus USER/[email protected] However, if I do this, I will the error shown below. Thanks in advance for your help KH Ting sqlplus user/[email protected](description=(address_list=(address=....... Try this string: (description=(address=(protocol=TCP)(host=scsatlspdb1)(PORT=1521)(CONNECT_DATA=( SERVER=DEDICATED)(SERVICE_NAME=P416))) Hi Tom, With you answer I am able to connect to database without having entry in file.

COM:1521/ODS ORA-12154: TNS:could not resolve the connect identifier specified Is there any way, I can connect to the database without refering to as defined in the TNS_ADMIN system environment variables?

ODS))) will work (use quotes if in Unix else the () are interpreted by the shell) that url like syntax is supported by (much) later releases of sqlplus. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where that is not a "dblink", it is a tns connect string. How did you find that when try to connect to sqlplus with connect string as defined by is actually getting replaced by complete string ( what you shown to us ) ? Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL] where ] | / Enter user-name: but same thing if I use "/" as user sqlplus /@(DESCRIPTION = (ADDRESS = (COMMUNITY = TCP) (PROTOCOL = TCP) (Host = mumsa000200)(Port = 1521))(CONNECT_DATA =(SID = infod)(GLOBAL_NAME = infod))) it is working very fine.Tom, I know DBLINKs can be created like that but never tried from sqlplus (until I read this) gave it a try.isnt working but I may be missing something very basic from ================= MYDBTEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hppkg_test)(PORT = 1515)) (CONNECT_DATA = (SID = TESTDB) ) ) Testing from Sqlplus ==================== C:\orahome1\ora92\binsqlplus [email protected] SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jul 28 2005 Copyright (c) 1982, 2002, Oracle Corporation. Enter password: *** Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production [email protected] Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production trying copy and paste from ---------------------------------------- C:\orahome1\ora92\binsqlplus [email protected]"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= hppkg_test)(PORT=1515))(CONNECT_DATA =(SID = TESTDB))" SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jul 28 2005 Copyright (c) 1982, 2002, Oracle Corporation. very very VERY different [[email protected] tkyte]$ sh -vx sqlplus 'scott/[email protected](DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora9ir2com)))' + sqlplus 'scott/[email protected](DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora9ir2com)))' SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jul 28 2005 Copyright (c) 1982, 2002, Oracle Corporation. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production [email protected] getting rid of your spaces, sometimes throws a muddle in the middle of it all TWO_TASK is also a viable alternative to specifying the connect string (tnsnames file needs exist with your entry in though) Sorry .. I tried to do echo "sqlplus parag/[email protected]" sh -vx sqlplus atlas/[email protected] [1]+ sqlplus parag/[email protected] SQL*Plus: Release 9.2.0.6.0 - Production on Tue Aug 2 2005 Copyright (c) 1982, 2002, Oracle Corporation. Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production SQLHi Tom, I have few more questions reagarding this thread Q1/ On AIX when I am trying to connect to database by this method in export command, it is giving me an error exp t/[email protected](DESCRIPTION = (ADDRESS = (COMMUNITY = TCP) (PROTOCOL = TCP) (Host = mumsa000200)(Port = 1521))(CONNECT_DATA =(SID = infod) )) but while same string is working for sqlplus connection Q2/ From oracle 8.1.7 server when I am trying to connect to Oracle 9.2 server with global_name parameter it is giving me error sqlplus t/[email protected](DESCRIPTION = (ADDRESS = (COMMUNITY = TCP) (PROTOCOL = TCP) (Host = mumsa000200)(Port = 1521))(CONNECT_DATA =(SID = infod)(GLOBAL_NAME = infod))) {4_TProd}/f205/prod/site/jcl SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 4 2005 (c) Copyright 2000 Oracle Corporation. So kindly explain me what is global_name and where it will be useful, secondly why error is comming when I am using global_name parameter ? conn scott Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory but i can connect using [email protected] the orcl connect identified point to my oracle. if the database is remote, then you use a tns connect string to get to it. OPN-linked account currently without "SR Create" privilege due to snail-bureaucracy.I think I created that confusion by bringing in database links here.. you can either create a dblink using service names or straight away in your sql statement (like below) SQLselect instance_name from [email protected] 2 / INSTANCE_NAME ---------------- TESTDB ============== and thanks for the tip..eliminating all spaces around '=' made the sql connection work fine (thanks.more cool thing up the sleeve..) SQLHi Following the tips, I have tried using the entry shown below but ended up got the error message shown below. regards & thanks pjp Hi Tom, Thanks for your answer. The select on table from 'A','B','C' works like the following: select * from [email protected] My questions: There is no dblink in databases 'A','B' or 'C' named R.world. Only if you are on the same machine with the server would you just use "scott/tiger" If you have a remote machine and want to default a connect string, on unix: export TWO_TASK=orcl on windows, set LOCAL=orcl (you can use control panel -I can't - it doesn't pops up neither with "all sources" nor with "document id (knowledge base, forum, or bug)" - tried with and without the trailing ".1" just in case. Alberto - In the quick find list of values you select "All Sources" Not quite - it pops up a forum thread named: "Re : Strange behavior with NONEXISTENT db links " that contains the text "...Earlier, I have forgot to mentioned that I am using Oracle Instanst Client on Win2K to connect to my company databases through windows command shell. COM)(PORT=1521)))(CONNECT_DATA=(SID=ODS))' ORA-12154: TNS:could not resolve the connect identifier specified Enter user-name: So I tried this sqlplus 'user/[email protected](DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PODS. COM)(PORT=1521)))(CONNECT_DATA=(SID=ODS))' but got this error SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jul 29 2005 Copyright (c) 1982, 2004, Oracle. Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: Is this method applicable for windows? sqlplus scott/[email protected](DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle.com)(POR T=1521))(CONNECT_DATA=(SERVICE_NAME=ora10g))) SQL*Plus: Release 10.1.0.4.0 - Production on Fri Jul 29 2005 Copyright (c) 1982, 2005, Oracle. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options [email protected] test/[email protected](description=(address_list=( address=(protocol=TCP)(host=ht85af6)(port=1521)))(connect_data=(service_name=chu bb))) SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 29 2005 Copyright (c) 1982, 2002, Oracle Corporation. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production Tom, I have a similar issue. I am getting the same kind of error using sqlplus to connect to a remote db sqlplus topprv/[email protected] '(description = (address_list=(address=scsatlspdb1.mydomain.com)))' Usage: SQLPLUS [ [ "-S" uses silent mode then i did this : sqlplus topprv/[email protected] '(description=(address=(protocol=TCP)(host=scsatlspdb1)(PORT=1521)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=P416)' i keep on getting syntax error. After removing spaces I am able to connect by SQL but with exp command in unix still I am not able to connect. The note is 186296.1: Without creating the database link in the database,can ..." (I already tried that yesterday, as stated in my previous post) Hey btw - I'm not the one interested in the document, I'm just answering Tom's request above :) gist of note: you do not need to create a database link if you are using naming services and global names.sqlplus user/[email protected]'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PODS. I am getting the same kind of error using sqlplus to connect to a remote db sqlplus topprv/[email protected] '(description = (address_list=(address=scsatlspdb1.mydomain.com)))' Usage: SQLPLUS [ [ "-S" uses silent mode then i did this : sqlplus topprv/[email protected] '(description=(address=(protocol=TCP)(host=scsatlspdb1)(PORT=1521)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=P416)' i keep on getting syntax error. Pl guide me exp t/[email protected](DESCRIPTION=(ADDRESS=(COMMUNITY=TCP)(PROTOCOL=TCP)(Host=sinsa1100054)(Port=1521))(CONNECT_DATA=(SID=atpp0 1)(GLOBAL_NAME=atpp01))) regards & thannks pjp Problem : Have to select from a table in remote database 'R' from local database 'L' The select on remote table works from other databases 'A','B' and 'C' without dblinks!! You can select * from [email protected]; without having issued create database link global.Another option for connecting with export is to escape out the '=' signs and include single quotes.For example, exp username/[email protected]'(DESCRIPTION\= (ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=hostname) (Port\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=ora9i)))' This works for UNIX, I don't have a windows machine to test on.

  1. harley davidson motorcycle dating sites 24-Feb-2016 19:04

    Mac Gyver fans, it's your turn for a ride in the reboot carousel that networks can't seem to stop going 'round and 'round on.

  2. Sexarbe 01-Mar-2016 08:00

    Ok, ok, some people are just more touchy feely than others.