Topic: Database Administration >> Logging as / as sysdba
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Logging as / as sysdba |
| muzu |
Posted: Aug 16, 2007 03:26:14 AM |
Total Post: 37
Joined: Aug, 2007
|
| What is the default username and password will be taken when we log as 'sqlplus / as sysdba' ? |
|
|
 Ratnaker |
| Posted: Aug 16, 2007 04:03:50 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Hi muzu,
You need to set one parameter
OS_AUTHENT_PREFIX in parameter file
actually this is OS authenticate user
Ratnaker
|
|
|
|
|
| Mohammed Taj |
| Posted: Aug 18, 2007 02:41:25 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
there are two types of password authentication method.
1. Password file
You need to create password file through ORAPWD utility.
when you give userid/pwd then password file method is use.
2. OS authentication.
You have to set two OS parameter.
"conn / as sysdba" or "conn /" then OS authentication method is use.
Regards
Taj
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| Bishal Khetan | 169 |
|
|
