(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll") (ORACLE_HOME = C:\app\Administrator\product\12.1.0\dbhome_1) # Generated by Oracle configuration tools. Listener.ora file: # listener.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\listener.ora Now I have the following error: Status: Failure -Test failed: The Network Adapter could not established the connection I've tried to use service name CLRExtProc. Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service. Query: SQL> select name, open_mode from v$pdbs where name='PDBORCL' I'm currently working on windows server 2008 OS. I have 2 versions of sql developer: 4.1.2.20, and the original from instalation: 3.2.20.10. What I'm looking is a simple "todo list" to configure connection in the sql developer, to connect, even from a remote machine, to oracle 12c DB. ORA-12505, TNS:listener does not currently know of SID given in connect descriptorĪgain, I used a default installation of oracle 12c, except setting passwords and select server type, I didn't changed much. I'm getting the following errors: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
as I saw in some manual on the internet, but it didn't worked for me. I've also have tried to use service name PDBORCL. I've tried to set entry called PDBORCL in the tnsnames.ora, I don't care about pdb, but as I understood there is no other option in oracle 12c. To user: sys as sysdba, And to the new created user demo.
I'm trying to connect to the DB with username and password like I did in oracle 11g. I've created user called demo with following command: alter session set container=pdborcl Ĭreate user demo identified by password QUOTA unlimited on users account unlock I can connect to sys user via sql developer when I select Connection Type "Local\Bequeath".īut I guess it didn't been connected to the PDB, just to the container.
I'm trying to connect sql developer to a fresh installation of oracle: