Scribd
Upload
13 views21 pages

Oracle Installation

The document provides a step-by-step guide for installing and configuring Oracle, emphasizing the correct folder naming convention and the selection of the Oracle base path. It instructs users to modify the sqlnet.ora file to change SQL_AUTHENTICATION_SERVICES to (NONE) and to use the Net Configuration Assistant for further setup. Finally, it details how to configure SQL Developer for database connection testing and viewing tables.

Uploaded by

kumarcscs
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views21 pages

Oracle Installation

The document provides a step-by-step guide for installing and configuring Oracle, emphasizing the correct folder naming convention and the selection of the Oracle base path. It instructs users to modify the sqlnet.ora file to change SQL_AUTHENTICATION_SERVICES to (NONE) and to use the Net Configuration Assistant for further setup. Finally, it details how to configure SQL Developer for database connection testing and viewing tables.

Uploaded by

kumarcscs
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Oracle Installation and Configuration – Gopinathan A R

Folder name should be like this only. Should not contain any etc letters. Ex : NT_18000_client (1)
Oracle base: by default, it will suggest some path, just avoid that
Browse from Oracle base and select C:\Oracle

Software location: comes automatically.


This screen will take some time based on processor’s speed.

During above process, this popup will appear and just give Allow access.
Once installation is done, go to below path and open [Link] file in notepad++
Here you can see by default, SQL_AUTHENTICATION_SERVICES = (NTS)

Make it like this, SQL_AUTHENTICATION_SERVICES = (NONE) and Save this file.


After above steps, go to All apps.

Select Net Configuration Assistant and follow the steps.


Once you click Net configuration assistant, you will get this screen.
Configure SQL Developer,
Here, should select, Connection Type : TNS then in Network Alias : (you can able to see configured
DB) select that one.
Perform Test.

Here you can see status will be success. Now you can Connect.
Now you can see DB here, you can expand this one to view tables.

You might also like