9i
•SPFILE
CREATE SPFILE = ‘filename’
FROM PFILE = ‘pfilename’
CREATE SFILE = ‘pfilename’
FROM SPFILE = ‘filename’
ALTER SYSTEM set parameter = val
SCOPS = MEMORY | SPFILE | BOTH
•Connect internal
CONNECT user/passwd AS SYSDBA
sqlplus ‘/as sysdba’
sqlplus “/as sysdba” (for windows)
*for windows make sure
user is in ORA_DBA group
uncomment SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora
sqlplus /nolog
07_DICTIONARY_ACCESSIBILITY is now false