Hi!
I have a question i hope someone can help me with!
I've just installet oracle 12c (12.1.0.1.0) developer edition.
I have problems with connecting to my tablespace, from a dba_user.
Here's what i've done:
SID=orcl
Container = PDBORCL
1. I've created a tablespace in the usual way
create tablespace EQS
datafile 'E:\app\Administrator\oradata\orcl\EQS3\eqspid003_data01.dbf'
size 32m reuse
autoextend on
extent management local;
2. I've created a local user, which is added to the dba_users
CREATE USER eqsdba
IDENTIFIED BY dbaeqs
DEFAULT TABLESPACE EQS
CONTAINER = CURRENT;
3. I've granted these five priviliges to the user
grant create session to eqsdba;
grant create table to eqsdba;
grant create sequence to eqsdba;
grant create trigger to eqsdba;
grant resource to eqsdba;
When i logout of SQLPLUS from SYSTEM-user and try to connect to eqsdba i get
sqlplus eqsdba/dbaeqs@orcl
"ORA-01017: Invalid username/password; logon denied" (ORA-01017)".
This used to work on 11g (we have it like that in oracle 11g, except the container) Any help would do!.
TNSNAMES.ORA looks like this:
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE11upgrade)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
LISTENER.ORA looks like this:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\oraql\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\oraql\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ORACLE11upgrade)(PORT = 1521))
)
)