Linux: How to change hostname

[root@localhost ~]# hostname

localhost.localdomain

[root@localhost ~]# hostname

localhost.localdomain

1. change name in /etc/hostname file.

[root@localhost ~]# cat /etc/hostname

localhost.localdomain

[root@localhost ~]# 

[root@localhost ~]# cat /etc/hostname

node1

[root@localhost ~]#

2. change name in /etc/hosts file.

[root@localhost ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

[root@localhost ~]#

[root@localhost ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.137.60  node1   node1

[root@localhost ~]#

[root@localhost ~]# hostname

node1

[root@localhost ~]#

OPW-00001: Unable to open password file

 When you try to create the password file in windows operating system for newly created database and for which we lost sys account password.

Here below I got error message, when I try to create password file:

C:\Users\oracle> orapwd file=C:\app\oracle\product\11.2.0\dbhome_1\database\pwddb02.ora password=manager entries=5 ignorecase=y

OPW-00001: Unable to open password file

cause:

1. missing privileges for oracle user.

2. missing proper grants to dba_ora group.

Solution:

add oracle user to dba_ora group.

correct the access levels for oracle home directory:

now you can create the password file.

ORA-00904 :: invalid identifier (awr report generation)

ERROR:

REASON:

respective user doesn't have execution permision on 'dbms_workload_repository' package.

SOLUTION:

Provide the execution permission on dbms_workload_repository to the respective user by using following steps.

$sqlplus / as sysdba 

SQL> grant execute on dbms_workload_repository to test;

SQL> conn test/test1

SQL> @?/rdbms/admin/awrrpt.sql


Hope it will help to resolve your issue.



By
Manjunath

ORA-01031: insufficient privileges in oracle on windows

Problem:

When you try to log on to SQLPLUS as sysdba following error may occur.

Error Message

ORA-01031: insufficient privileges

Reason:Your user is not a member of ORA_DBA group  (dba group in unix).

Solution:

For Windows.

Add your user to ORA_DBA group.

Here are the below steps to add your user to ORA_DBA group.

1.       Goto start  -> run -> compmgmt.msc  -> Local Users and Groups -> users -> goto properties of your user -> Member of -> add ORA_DBA group.

Now try to connect via sysdba.

Here is the solved screen.

Hope it will help to resolve your issue.



By
Manjunath

RemoteOperationalException: ERROR: Invalid username and/or password

Problem:

When you try to log on to OEM in windows following error may occur.

Error Message

RemoteOperationalException: ERROR: Invalid username and/or password

Solution:

Set the 'Log on batch job' and 'Log on service'.

Step1: Goto control panel -> Administrative Tool -> Local Security Settings.

       Local Policies -> User Rights Assignment -> double click on 'Log on as a batch job'

Step 2: Add the user here which you are trying accessing the OEM and click apply and OK.

Step3 : Follow the step 2 for adding user to 'Log on as a service'.

Step4: Now try to log on to OEM.

          You will get the following screen if db is down.

Hope it will help to resolve your issue.



By
Manjunath