| Login as sysdba [message #293124] |
Fri, 11 January 2008 00:00  |
sudhir1582
Messages: 17
Registered: December 2007
|
Junior Member |
|
|
Hi All,
On sun solaris 10 , i have installed oracle 10.2.0.1 software only. Can i take sysdba login , but when i login as sysdba i'm getting the following error.
ORA-12162: TNS:net service name is incorrectly specified
I checked the tnsname.ora file but tnsname.ora file is not created.
Regards
Sudhir
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Login as sysdba [message #293394 is a reply to message #293391] |
Sat, 12 January 2008 01:24  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
>NO! SQL*NET is NOT required to connect to the database!
NOT Required when we connect without TNS_ENTRY.
Required when we connect with TNS_ENTRY.
Always better to connect with TNS_ENTRY becuase suppose if we have two database in single server then we can identify our database through TNS_ENTRY and not connect to wrong database.
hope you understand my point.
Regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
