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
- Database Instance tidak bisa startup - ORA-011033: ORACLE initialization or shutdown in progress mamat, 2012-12-28 14:07:39
- Oracle Express ORA-12519 TNS no appropriate service handler found error mamat, 2012-02-28 13:50:58
- Oracle Data Pump in Oracle Database 10g (expdp and impdp) mamat, 2012-02-09 13:59:56
- Memanggil ORA_HASH function dalam Trigger mamat, 2012-01-02 18:42:52
- CROSS Query/Join Query Multiple Database ON Oracle mamat, 2011-12-14 09:57:24
- Menampilkan seluruh Relasi dalam sebuah table di ORACLE mamat, 2011-08-02 22:21:14
- Oracle Get kamus Data mamat, 2011-07-15 03:08:59
- Alter Table Menambah Auto Increment pada table di Mysql mamat, 2011-07-08 00:19:40
- Melakukan Alter Table AUTO INCREMENT pada DBMS DB2 mamat, 2011-04-16 12:01:01
- Install Oracle XE in Ubuntu 64 Bit mamat, 2011-04-07 13:38:22
- PL/SQL ORACLE Function Terbilang mamat, 2011-02-15 11:56:34
- Install DB2 Silent Mode di Linux mamat, 2010-12-08 10:06:35
- Export/Import Data Table DB2 mamat, 2010-11-01 13:46:58
- Backup and Restore on WINDOWS Server using Command Line mamat, 2010-10-21 13:00:33
- DB21061E Command Line Environment is not initialized mamat, 2010-10-21 12:49:14
- IMP/EXP ORACLE Verify that ORACLE_HOME is properly set mamat, 2010-09-03 17:41:23
- LIST DB2 ERROR SQLCODE mamat, 2010-09-03 14:59:40
- Membuat User dan Hak Akses Sederhana di Server Database Mysql mamat, 2010-08-03 11:17:51
- DB2 Tuning Tips mamat, 2010-02-02 09:20:59
- My DB2 Basic Tutorial mamat, 2009-11-25 13:55:13
- Auto increment in Oracle mamat, 2009-10-20 13:49:28
- Fast Backup DB2 on Cronjob mamat, 2009-08-27 13:59:54
- Mysql Automatic Data Recovery using Mysqldump and Crontab mamat, 2009-02-23 14:22:54
- Cara Export/Import ORACLE mamat, 2008-09-11 18:37:50
- QUERY di DB2,MYSQL,MSSQL,ORACLE dan POSTGRESQL untuk menampilkan Data Yang dinamis recordnya (LIMIT, mamat, 2008-08-06 15:25:31
- Searching, Indexing...! for Query in Mysql mamat, 2008-05-07 14:22:56