SQL Developer Data Modeler

Welcome to the forums !

>
I have installed oracle 10g ...
>

Which 10g ? 10gR1 ? 10gR2 ? What is the full OS ?

>
however i failed to logon to database.
>

Pl post complete error messages

HTH
Srini

user oracle and groups are Operating system user and groups not the database user.......


Use Sys or System or Scott with passwords your specified during installation

Plz mark as helpful or correct

Cheers,
Baig

why don't you post the error messages? it might be issue with your environment settings, .bash_profile etc.
do su - oracle once and trying logging into oracle.

HTH,
Thanks

shavali,

i have installed 10201_database_linux32.zip so iguess its 10g2

when i ran sqlplus oracle/passwd@orcl
i got username/password incorrect logon denied

wheni just ran sqlplus oracle/passwd
i got something more severe like
ORA-... : ORACLE not available
and it says something about memory and shared realms

the OS is fedora 7 i386

Baig,

thanks,

in deed i can log in to my computer with the created user oracle but not to the database orcl
then should delete this oracle user ? it can be useful only if i can consider it as a guest account that users can use to connect to database which is not the case here as you said.

now if i just do sqlplus / as sysdba
it succeded !

So this is the user SYS you spoke about, isn't it ?

how can i connect to as user SYSTEM ?

it is bothering that these users have no passwords, this means anyone can connect to orcl using them. is it possible to change that and how ?

knowing that i have to grant access to the database to some users, what is the best way to proceed ? should i create some oracle database account for them ? may these accounts be the same as the OS accounts. Any available SQL command for that is very welcome.

Edited by: user12092668 on Nov 6, 2009 12:55 AM

when i ran sqlplus oracle/passwd@orcl
i got username/password incorrect logon denied

Do you have "oracle" user in your database?

wheni just ran sqlplus oracle/passwd
i got something more severe like
ORA-... : ORACLE not available
and it says something about memory and shared realms

Is your oracle up and running?

gtcol,

well it is sure that i can connect to my computer with oracle user but it is imposible to connect to database. it seems that this user is not really a database user. that's why i think i must delete it, it is useless. why bothering creating it during installation at the first time, strange.

well i will search how to create a database user with sqlplus.


oracle is runing since sqlplus / as sysdba succeeded

pleaseeeee don't drop this user 'oracle', oracle uses this user for all transactions in OS, seems like you're new to oracle, please go to through oracle documentation first .

1) Dont delete the oracle user this user is Owner of Oracle installation/inventory if u dont delete then Oracle will not work ........

2) connect / as sysdba is working because Oracle Operating system authentication is enabled thats why u r able to connect with / as

3) if u want to connect from system or any other user in SQLPLUS then try

# sqlplus  system/passwod

4) i dont understand your basic requirement i guess ur server is accessable to lot of people........ best way is create seperate users in Oracle database with

  create user ABC identified by password;
  grant connect, resource to abc;

5) install SQL Developer or Oracle client installation on client side to access sqlplus or worksheet with Oracle accounts without worrying about 'oracle' operating system user.


Regards,
Baig


Again mark it helpful if it is ;)

user12092668 ,

once u are able to login thru /as sysdba. you can alter the password of by user 'system' by following query

alter user system identified by password.

Try to connect with system user with new password. you shuold be able to connect to it.


Himanshu