Hi.
I downloaded oracle database 12c to evaluate it
The instance was installed on a windows 10 professional machine.
I'm trying to create a pluggable databes. but I'm getting the above error.
This is the code I'm using, I copied it from SQL developer, I get the same error on sql developer and on sqlplus
CREATE PLUGGABLE DATABASE "testpdb" ADMIN USER "Admin" IDENTIFIED BY "PaSSword"
FILE_NAME_CONVERT=(
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\SYSTEM01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\SYSAUX01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\UNDOTBS01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\UNDOTBS01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\TEMP012017-07-18_18-49-53-303-PM.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\TEMP012017-07-18_18-49-53-303-PM.DBF'
)
STORAGE UNLIMITED TEMPFILE REUSE;
I ran out of ideas. Very frustrated for getting errors on a very basic thing when I'm using an out of the box installation
I googled the error and found many references to the host table.
-- My machine name is Titan, this is the output of hostname command.
C:\Users\Adrian>hostname
Titan
-- This is my host file
127.0.0.1 localhost titan titan.lan
Localhost, titan, titan.lan can be resolved by nslookup
-- this is my tnsnames.ora
# tnsnames.ora Network Configuration File: D:\app\Adrian\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLPDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = loclahost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oraclpdb)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
-- This is the alert.log
2017-07-24T00:28:01.807898-05:00
**************************************************************
Undo Create of Pluggable Database TESTPDB with pdb id - 4.
**************************************************************
ORA-21561 signalled during: CREATE PLUGGABLE DATABASE "testpdb" ADMIN USER "Admin" IDENTIFIED BY *
FILE_NAME_CONVERT=(
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\SYSTEM01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\SYSAUX01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\UNDOTBS01.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\UNDOTBS01.DBF',
'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\PDBSEED\TEMP012017-07-18_18-49-53-303-PM.DBF', 'D:\APP\ADRIAN\VIRTUAL\ORADATA\ORCL\testpdb\TEMP012017-07-18_18-49-53-303-PM.DBF'
)
STORAGE UNLIMITED TEMPFILE REUSE...
Thanks for the help