9i
\n\u2022SPFILE
\nCREATE SPFILE = ‘filename’
\nFROM PFILE = ‘pfilename’<\/p>\n
CREATE SFILE = ‘pfilename’
\nFROM SPFILE = ‘filename’<\/p>\n
ALTER SYSTEM set parameter = val
\nSCOPS = MEMORY | SPFILE | BOTH<\/p>\n
\u2022Connect internal
\nCONNECT user\/passwd AS SYSDBA<\/p>\n
sqlplus ‘\/as sysdba’
\nsqlplus “\/as sysdba” (for windows)
\n*for windows make sure
\n\tuser is in ORA_DBA group
\n\tuncomment SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora<\/p>\n
sqlplus \/nolog<\/p>\n
07_DICTIONARY_ACCESSIBILITY is now false<\/p>\n","protected":false},"excerpt":{"rendered":"
9i \u2022SPFILE CREATE SPFILE = ‘filename’ FROM PFILE = ‘pfilename’ CREATE SFILE = ‘pfilename’ FROM SPFILE = ‘filename’ ALTER SYSTEM set parameter = val SCOPS = MEMORY | SPFILE | BOTH \u2022Connect internal CONNECT user\/passwd AS SYSDBA sqlplus ‘\/as sysdba’ … Continue reading