Home » RDBMS Server » Server Administration » Login as sysdba (10.2.0.1)
Login as sysdba [message #293124] Fri, 11 January 2008 00:00 Go to next message
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 #293125 is a reply to message #293124] Fri, 11 January 2008 00:05 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
why are you using SQL*Net to login to the database?
Re: Login as sysdba [message #293132 is a reply to message #293125] Fri, 11 January 2008 00:17 Go to previous messageGo to next message
sudhir1582
Messages: 17
Registered: December 2007
Junior Member
Hi Sir,

Can u explain me , how do i login

Regards,

Sudhir
Re: Login as sysdba [message #293137 is a reply to message #293124] Fri, 11 January 2008 00:22 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
Just follow the direction found in the INSTALLATION GUIDE found at http://tahiti.oracle.com
Re: Login as sysdba [message #293390 is a reply to message #293124] Sat, 12 January 2008 00:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You have to create tnsnames.ora file through NETCA tools.
Re: Login as sysdba [message #293391 is a reply to message #293124] Sat, 12 January 2008 00:39 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
>You have to create tnsnames.ora file through NETCA tools.
NO! SQL*NET is NOT required to connect to the database!
Re: Login as sysdba [message #293394 is a reply to message #293391] Sat, 12 January 2008 01:24 Go to previous message
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


Previous Topic: Oracle is showing Weird data
Next Topic: Oracle Architecture
Goto Forum:
  


Current Time: Wed Dec 07 14:29:38 CST 2016

Total time taken to generate the page: 0.06499 seconds