Skip to ContentSkip to Footer
Start of content
- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - OpenVMS
- >
- ORA 12162 / 12170 and Oracle 10G
Operating System - OpenVMS
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
Go to solution
Topic Options
- 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
- Email to a Friend
- Report Inappropriate Content
03-26-2009 08:54 AM
03-26-2009 08:54 AM
Hello
Still with Itanium OpenVMS 8.3-1H1 and oracle 10G R2
After installing Oracle 10 G R2 and created a test database, I have started and shut Oracle several times with
$ sqlplus / as sysdba
shutdown
or startup
and
beqlsnr stop
Then I have modified the file in [network.admin]
tnsnames.ora in order to add my database TEST
on a remote PC and the Vms server.
I then connected fine from the PC on my TEST database.
A little later, any attempt to log in fails with ORA-12162
I noticed ora_sid was no longer defined, so I defined it again, and now
$ SQLPLUS "/ AS SYSDBA"
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 26 17:37:37 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
Enter user-name:
I have looked at metalink
VMS: Checklist for TNS-12170 errors when accessing or creating a database
Doc ID: 434836.1
but found nothing
I have renamed the file tnsnames.ora
I have the logical ora_sid in the logical table.
Thanks for any hint
Gerard
Still with Itanium OpenVMS 8.3-1H1 and oracle 10G R2
After installing Oracle 10 G R2 and created a test database, I have started and shut Oracle several times with
$ sqlplus / as sysdba
shutdown
or startup
and
beqlsnr stop
Then I have modified the file in [network.admin]
tnsnames.ora in order to add my database TEST
on a remote PC and the Vms server.
I then connected fine from the PC on my TEST database.
A little later, any attempt to log in fails with ORA-12162
I noticed ora_sid was no longer defined, so I defined it again, and now
$ SQLPLUS "/ AS SYSDBA"
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Mar 26 17:37:37 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
Enter user-name:
I have looked at metalink
VMS: Checklist for TNS-12170 errors when accessing or creating a database
Doc ID: 434836.1
but found nothing
I have renamed the file tnsnames.ora
I have the logical ora_sid in the logical table.
Thanks for any hint
Gerard
Solved! Go to Solution.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-26-2009 09:09 AM
03-26-2009 09:09 AM
Solution>> Then I have modified the file in [network.admin]tnsnames.ora
When you modified it, did you take care to assure that the file retained the stream_lf attribute?
Most (just make it all) Oracle control files now HAVE to be stream_lf.
If they are not, then to fix it on 8.3 you can use one-liners like:
$conve/fdl="record; format stream_lf" tns_admin:SQLNET.ORA tns_admin:/stat
See also
http://forums11.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=1306998
And a litte script that might be belpful below.
Hope this helps,
Hein.
$! --- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-26-2009 10:16 AM
03-26-2009 10:16 AM
Re: ORA 12162 / 12170 and Oracle 10G
Thanks Hein
It works now, and while I had applied the doc when creating the tnsnames.ora, I had not checked after my modif, so I guess this is the reason of the problem.
I do not understand why I still had this error after renaming the file ?
There is a faulty logic here I think, as with Oracle 10, stop or start Oracle means using
sqlplus.
And this command is unavailable then...
Getting tired, I rebooted and it works fine now.
It works now, and while I had applied the doc when creating the tnsnames.ora, I had not checked after my modif, so I guess this is the reason of the problem.
I do not understand why I still had this error after renaming the file ?
There is a faulty logic here I think, as with Oracle 10, stop or start Oracle means using
sqlplus.
And this command is unavailable then...
Getting tired, I rebooted and it works fine now.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
End of content
United States
Hewlett Packard Enterprise International
Communities
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP