select username from dba_users where username not in ('SYS','SYSTEM','DBSNMP','EXFSYS','MDSYS','ORDDATA') order by 1; spool off EOF # Loop on each user with generating its DDL: for USERNAME in `cat ${SPOOLLOF}` do export USERNAME ${ORACLE_HOME}/bin/sqlplus -S '/assysdba' <<...
Please refer this note to set variables SAP NOTE:- 556232 what is mentioned on your listener.ora under (SID_NAME = SID) ? Can you tell me how do you login to your DB form CMD? sqlplus. Regards JUDE. You must be a registered user to add a comment. If you've already registered, ...