berbagisolusi
sid
Oracle, TNS Listener Error in Windows
If you have those problem, follow this intruction : Solution A. Set Database and restart listener – open cmd command ( start menu > run > type “cmd” <enter>) – C:\> set ORACLE_SID=YOUR_ORACLE_DB – C:\>lsnrctl stop – C:\>lsnrctl start – open windows service and starting Service[YOUR_ORACLE_SERVICE] start menu > run > type “services.msc” <enter> Solution … Continue reading
EXPORT / IMPORT ORACLE (ORACLE DUMP)
Create database directories Execute the following commands to create a database directory. This directory must point to a valid directory on the same server as the database: Login SQLPlus 1. Start Menu > run > type “cmd” <enter> 2. c:\>set oracle_sid=<oracle_sid> 3. c:\>sqlplus system/<pwd> SQL> CREATE DIRECTORY dmpdir AS ‘/opt/oracle’; Directory created. SQL> GRANT read, … Continue reading
Web Statistic
berbagisolusi 