Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle database configuration

3155808Nov 7 2016 — edited Dec 7 2016

I follow this link for configure sql developer connection ..

I install all files. jdk , oracle database 12c, web logic , reports all i installed succesfuuly

I follow this link for installing of oracle database 12c

Installing Oracle Database 12c on Windows

so in this link 8th point is

The Typical Install Configuration window appears. Click on a text field and then the balloon icon ( )to know more about the field. Note that by default, the installer creates a container database along with a pluggable database called "pdborcl". The pluggable database contains the sample HR schema. Change the Global database name toorcl. Enter the "Administrative password" as Oracle_1. This password will be used later to log into administrator accounts such as SYS and SYSTEM. Click Next.

so i enter username and password Oracle_1

but this shows error

pastedImage_1.png

i have Oracle home not oracle_1

C:\Oracle\Middleware\Oracle_Home

and

D:\app\OracleHomeUser1

and

listener is

# listener.ora Network Configuration File: D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID\_DESC =

  (SID\_NAME = CLRExtProc)

  (ORACLE\_HOME = D:\\app\\OracleHomeUser1\\product\\12.1.0\\dbhome\_1)

  (PROGRAM = extproc)

  (ENVS = "EXTPROC\_DLLS=ONLY:D:\\app\\OracleHomeUser1\\product\\12.1.0\\dbhome\_1\\bin\\oraclr12.dll")

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

tns is

# tnsnames.ora Network Configuration File: D:\app\OracleHomeUser1\product\12.1.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS\_LIST =

  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT\_DATA =

  (SID = CLRExtProc)

  (PRESENTATION = RO)

)

)

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT\_DATA =

  (SERVER = DEDICATED)

  (SERVICE\_NAME = orcl)

)

)

and how i configure this connection?

any help please

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2017
Added on Nov 7 2016
28 comments
3,618 views