- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle sqlplus error on hpux 11i
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
Discussions
Discussions
Forums
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
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
тАО12-23-2005 10:56 AM
тАО12-23-2005 10:56 AM
When i try to execute the command sqlplus and enter my username and password i got below error:-
ERROR:
ORA-12162: TNS:net service name is incorrectly specified
Appreciate any help.
Thanks,
Shiv
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 11:29 AM
тАО12-23-2005 11:29 AM
Re: oracle sqlplus error on hpux 11i
The error occurs as the service name is incorrectly specified in 'tnsnames.ora" file.
Check the file for any correct syntax in the connect descriptor like un-matched parentheses or any unwanted characters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 03:45 PM
тАО12-23-2005 03:45 PM
Re: oracle sqlplus error on hpux 11i
there is problem with your tnsnames.ora most probably or your sql client is not resolving to the listener. Did you try tnsping?
to check this, try to connect by explicitly specifying the connect string thus bypassing the tnsnames.ora
try:
sqlplus 'user/password@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mydb.mu)(PORT=1521)))(CONNECT_DATA=(SID=mydb)))'
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 03:51 PM
тАО12-23-2005 03:51 PM
Re: oracle sqlplus error on hpux 11i
It also seems like you did not specify a TNS:Net service name nor have the environement variable TWO_TASK set.
Also, did you set the user environment variable $ORACLE_SID?
In case, you don't want to specify the alias as define in the tnsnames.ora, you may also wish to add the ORACLE_SID to your .profile. This will give the BEQ adapter a route to connect to the instance.
hope this helps too!
merry christmas
Kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 04:39 PM
тАО12-23-2005 04:39 PM
Re: oracle sqlplus error on hpux 11i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-23-2005 04:41 PM
тАО12-23-2005 04:41 PM
Re: oracle sqlplus error on hpux 11i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-25-2005 04:43 PM
тАО12-25-2005 04:43 PM
Solutionnet_service_name=
(DESCRIPTION=
(ADDRESS=(protocol_address_information))
(CONNECT_DATA=
(SERVICE_NAME=service_name)))
You have specified wrong TNS name, so that you got this error.
-Arun
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-26-2005 08:06 PM
тАО12-26-2005 08:06 PM
Re: oracle sqlplus error on hpux 11i
did you set the ORACLE_SID prior to try to conenct by sqlplus?
if not use:
export ORAENV_ASK=NO
export ORACLE_SID=
.oraenv
to define it.
To check if the
tnsping
HTH,
Art