First of all start your database by going to cmd.exe and type in
sqlplus
It will ask you for the username and password . Enter any user to connect and enter the password for that user.
After you are connected to the database open SQLdeveloper and click on create new connection .
a dialog box opens.
In the field Connection name enter any desired name, in the field username enter the specific user with which you want to connect and in the next feild enter the password for that user. Also Check save password so that you are not prompted again and again for password.
In the oracle tab set the Role to default and connection type to TNS.
From the list of Network alias select ORCL(The name may vary on different machines)
after that click on Test and You should get Success.
After the Success is printed Click on Connect. And you are done.
if you face any problem please leave a comment.!
sqlplus
It will ask you for the username and password . Enter any user to connect and enter the password for that user.
After you are connected to the database open SQLdeveloper and click on create new connection .
a dialog box opens.
In the field Connection name enter any desired name, in the field username enter the specific user with which you want to connect and in the next feild enter the password for that user. Also Check save password so that you are not prompted again and again for password.
In the oracle tab set the Role to default and connection type to TNS.
From the list of Network alias select ORCL(The name may vary on different machines)
after that click on Test and You should get Success.
After the Success is printed Click on Connect. And you are done.
if you face any problem please leave a comment.!
No comments:
Post a Comment