Mamat Zone

HOME | SITEMAP

Oracle Express ORA-12519 TNS no appropriate service handler found error

Posted on 2012-02-28 13:50:58 by mamat, 0 Comments

Fixing the ORA-12519: TNS:no appropriate service handler found error

1. Masuk ke /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin

2. Login sebagai user oracle
Ketik:
su - oracle
3. Ketik:
./sqlplus

4. Masukan Username dan Password
Username : SYSTEM
Password : 112233 <-- kalau gak salah

5. Ketik command berikut:
alter system set processes=300 scope=spfile;
6. Restar Oracle
/etc/init.d/oracle-xe restar

Other Articles