Entering To Db as SysDBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

shirin,

and you need to know the password of sys. by default it is change_on_install. pass of system is manager

Hope this helps

ASKER

about :
>>you just need to set ORACLE_SID=<SID> then<<
Where and How ?
I m beginner.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thanks for your comment,

i writed these instructions

C:\>Set oracle_sid=orcl
C:\>sqlplus /nolog

another page was opened
i writed :
SQL> connect internal
ORA-01031: insufficient privileges

after it i tested sys user

SQL> connect sys/shirin as sysdba
ORA-01031: insufficient privilege

where is my mistakes,and how can i solve
this problem?

I increased points To 100.

at first My oracle DB located in

ASKER

My oracle DB located on E drive.

shirin,

Please check if your OS user is belong to ORA_DBA group

What is the value of SQLNET.AUTHENTICATION_SERVICES parameter in your sqlnet.ora file ? Change it to (NONE) or comment it out to see what happen

Hope this helps

mtae

You should be able to connect to the database as sysdba in a windows environment by:

c:> sqlplus "/ as sysdba"

as long as you belong to the same group as the one who installed oracle. (ORA_DBA group as baonguyen1 says).

What is in your sqlnet.ora file and what are the values of the following parameters in your init.ora file

remote_login_passwordfile
os_authent_prefix
remote_os_authent

It's something to do with your connection set up I think, that is why you are getting "insufficient privileges".

ASKER

thanks for your comments
about
>>Please check if your OS user is belong to ORA_DBA group<<
I came into with Administrator account that belonged to Administratos,ora_DBA,ora_oper,ora_ORCL_DBA,ORA_ORCL_OPER groups.

My Sqlnet.ora Contents
>>
# E:\ORANT\NET80\ADMIN\SQLNET.ORA Configuration File:E:\ORANT\net80\admin\sqlnet.ora
# Generated by Oracle Net8 Assistant
NAME.DEFAULT_ZONE = world
NAMES.DEFAULT_DOMAIN = world
sqlnet.authentication_services = (NONE)
SQLNET.EXPIRE_TIME = 0

SQLNET.ENCRYPTION_SERVER = requested

SQLNET.ENCRYPTION_CLIENT = requested

NAMES.DIRECTORY_PATH= (TNSNAMES)
<<

And about init.ora :
i dont have init.ora on oracle 8.0.0.5 .
i have initorcl.ora on database folder that cosisit of :
>>
db_name = orcl
db_files = 1020
control_files = ("E:\ORANT\database\ctl1orcl.ora", "E:\ORANT\database\ctl2orcl.ora")
db_file_multiblock_read_count = 16
db_block_buffers = 566
shared_pool_size = 11534336
log_checkpoint_interval = 6000
processes = 128
dml_locks = 200
log_buffer = 32768
sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
#audit_trail = true
#timed_statistics = true
background_dump_dest = E:\ORANT\rdbms80\trace
user_dump_dest = E:\ORANT\rdbms80\trace
db_block_size =2048
compatible = 8.0.5.0.0
sort_area_size = 65536
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240
text_enable = true

##### For archiving if ARCHIVELOG is on ########
LOG_ARCHIVE_DEST =E:\ORANT\database\archive
LOG_ARCHIVE_FORMAT =arc%S.%T
LOG_ARCHIVE_BUFFERS =4
LOG_ARCHIVE_BUFFER_SIZE =127
<<

Do you see any problems in this Configurations?

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

baounguyen1,
Great, many thanks For your efforts.
you will give all of points.

What happend for my oracle DB with that line?
I wait for your answer.
Finally , awarded 25 extra points(100+25) to you.

Thanks again.

ASKER

Can you tell me what is the Role of NTS parameter
in correcting my problem or i close this question
with only 100 points?

SOLUTION

byalcin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

thank For your comments.

shirin,

Sorry for not responding. Yesterday was friday and I left the office very early.

byalcin is right about the SQLNET.AUTHENTICATION_SERVICES paramater in the sqlnet.ora file. You define the authentication method using ths parameter. If you set it to NONE, then users won't be able to log on using OS authentication.

Be aware that if you set it to NTS and the OS user is the domain user you will get error "ORA-12570 TNS:packet reader failure" if you machine is not connected to the domain. It is because because the authentication will try to reach the domain users database on the PDC or BDC

Hope this makes clear