All,
iam facing some weird issues when i try to install the sample db in oracle 12.2x.
1. downloaded and unzipped ( the correct = db-sample-schemas-12.2.0.1.zip) all scripts and placed in = F:\app\weblogic\product\12.2.0\dbhome_1\demo\schema
2. connect as sys ADMIN
3. set session = > alter session set "_ORACLE_SCRIPT"=true;
4. run => @mksample SystemPassword1 SysPassword1 hrPassword1 oePassword1 pmPassword1 ixPassword1 shPassword1 biPassword1 users temp $ORACLE_HOME/demo/schema/log/ localhost:1521/orcl
now #4 return all sorts of crazy error like below but regardless -
ERROR at line 1:
ORA-00922: missing or invalid option
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_cre.sql"
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_popul.sql"
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_idx.sql"
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_code.sql"
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_comnt.sql"
SP2-0310: unable to open file "__SUB__CWD__/human_resources/hr_analz.sql"
Using windows 10 professional,
thanks,