Replies to This Discussion

Permalink Reply by David Frank on June 13, 2013 at 10:12am

In windows, i solved it like this.

1. Open cmd.
2. Type sqlplus "/as sysdba"
3. created my own user and made him dba.

create user shashi identified by oracle;
grant connect,resource,dba to shashi.

4. Now i am able to login to oracle with shashi/oracle.

Try this in Linux> terminal.

For more info,
http://eoracle11g.blogspot.com/

• ▶ Reply

Permalink Reply by Johnson Grounds on June 13, 2013 at 10:13am

thanks for the reply,

but i am able to login as sysdba on the same terminal but unable to connect remotely as sysdba. I guess this is related to some OS permission issues..

• ▶ Reply

Permalink Reply by Nicholas Amrhein on June 13, 2013 at 10:16am

hey all,
you need to have password file and ownership of password file then u can access as "sys as sysdba"

• ▶ Reply

▶ Reply to Discussion