Login to XE-MySQL Syntax

Login:
——
mysql -uroot -proot

# /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld restart
# mysqladmin -u root -p status
# datadir=/var/lib/mysql

mysql> show variables like ‘%datadir%;
In MySQL Space Issue: (1) Delete /var/log/mysqld.log files

———————————————————————————————————————–

Login:
——

$ sqlplus sys/oracle as sysdba

$ orapwd file =orapwXE PASSWORD=ORACLE force=y entries=3

In Oracle 11g Default path for Alter log files is:

For Issues:
———–

SQL> show parameter background_dump_dest

Ex: /u01/app/oracle/diag/rdbms/db01/db001/trace/alert_db001.log

In Oracle : (1) Delete alert log files
(2) Drop unwanted user by taking the backup using expdump and keep the backup on same server
(3) For Archive log issue, delete files from archive logs / # df -kh
SQL> archive log list;
(4) SQL DEVELOPER Connectivity issue listener
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

sqlplus system/system-password@XE

sqlplus system/system-password

sqlplus / as sysdba
Solution:

sqlplus /nolog
conn system/password
connected.
alter system register;
exit
lsnrctl stat

Now you can see the service
Even if don’t see try this one out
$ sqlplus /nolog
SQL> conn system/password
connected.
SQL> alter system set local_listener = ‘(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))’ scope = both;
… system altered …
sql> alter system register;
SQL> exit
$ lsnrctl stat (IT SHOULD SHOW SERVICE REGISTERED NOW )

This should probably work …

Advertisements
Leave a comment

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

%d bloggers like this: