Oracle dba

login database :

[oracle@drc3 ~]$ sqlplus /nolog
SQL> connect sys as sysdba –> connect as sys dengan sysdba privilleges
SQL> connect / as sysdba –> connect dengan os authentikasi dengan sysdba privilleges
SQL> select value from v$parameter where name like ‘%service_name%’; –> untuk cek service name

*). Untuk mengunakan service_name (tnsname.ora) maka lakukan :
netca –> local net service name configuration

jika ingin koneksi dari remote host mengunakan sqlplus tetapi muncul error :
TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
maka edit tnsnames.ora comment kata2 :
(Address_List
http://www.dba-oracle.com/t_ora_12504_tns_listener_not_given_sid.htm
setelah itu , gunakan perintah berikut ini untuk connect :
SQL> connect x/oracle@x.x.x.x:1521/x –>oracle adalah password
http://stackoverflow.com/questions/29659264/sqlplus-errorora-12504-tnslistener-was-not-given-the-service-name-in-connect

create spfile :

SQL> create spfile = ‘tes’ from memory;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s