- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Oracle10g Client - SQLPLUS Error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2008 10:08 PM
08-28-2008 10:08 PM
Pls note though that running SQLPLUS under MGR using "...@beyield" results an error but running SQLPLUS under MGR using "...@beyield.company.com" is OK.
Pls see below for details.
-----------------------------
ORACLE10G ACCT
-----------------------------
ORACLE10G$ $ sqlplus vf_edc_admin/dwhedc_vf@beyield
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Aug 29 11:13:22 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
----------------------
MGR ACCT
----------------------
1) OK
ADMIN$ $ sqlplus vf_edc_admin/dwhedc_vf@beyield.company.com
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Aug 29 13:48:27 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.2.0.3.0 - 64bit Production
2) NOT OK
MGR$ $ sqlplus vf_edc_admin/dwhedc_vf@beyield
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Aug 29 11:14:07 2008
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: vf_edc_admin
Enter password:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
----------------------
TNSNAMES ENTRY
----------------------
beyield.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = servername.company.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = beyield)
(SERVER = DEDICATED)
(GLOBAL_NAME = beyield.world)
)
)
BEYIELD.company.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = servername.company.com)(PORT = 1521))
)
(CONNECT_DATA =
(SID = beyield)
(SERVER = DEDICATED)
)
)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2008 01:04 AM
08-29-2008 01:04 AM
Re: Oracle10g Client - SQLPLUS Error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2008 02:51 AM
08-29-2008 02:51 AM
Re: Oracle10g Client - SQLPLUS Error
If nothing add
NAMES.DEFAULT_DOMAIN = world
You can also try to connect @beyield.world because you specified beyield.world in your tnsnames.ora
Rgds
Marc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2008 06:01 AM
08-29-2008 06:01 AM
Re: Oracle10g Client - SQLPLUS Error
As with tnsnames.ora, sqlnet.ora also needs conversion in OVMS 8.3.
$ CONVERT/FDL=SYS$INPUT x.x sqlnet.ora
RECORD
CARRIAGE_CONTROL carriage_return
FORMAT stream_LF
^Z
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2008 07:15 PM
09-01-2008 07:15 PM
SolutionMuch appreciated.
fwiw, I wrote a modest DCL script to check Oracle files line LISTENER.ORA, TNSNAMES, SQLNET...
It suggests a 1-line fix for those files that need it.
$! --- Check_fix_oracle_file.com ----
$if p1.eqs."" then goto help
$!p1 = f$elemenent(0,";",p1) + ";0"
$old = ""
$loop:
$ file = f$search(p1)
$ if file.eqs."" then exit
$ if file.eqs.old then exit
$ old = file
$ rat = f$file(file,"rat")
$ rfm = f$file(file,"rfm")
$ if rat .eqs. "CR" .and. rfm .eqs. "STMLF" then goto loop
$ name = f$pars(file,,,"NAME") + f$pars(file,,,"TYPE")
$ write sys$output name, ": RFM/RAT = ''rfm'/''rat'. Should be STMLF/CR."
$ write sys$output "Issue: $ CONVERT/FDL=""RECORD; FORMAT STREAM_LF;
CARRIAGE CARRIAGE"" ''name' ''name'"
$ goto loop
$help:
$type sys$input:
-- Please provide (wildcarded) file specification as parameter
$exit
Cheers,
Hein.