OHS not starting after giving opmnctl startall with error make_sock: could not bind to address xx.x.x:80

OHS not starting after giving opmnctl startall  with error make_sock: could not bind to address xx.x.x:80

[2016-12-19T05:51:07.1888+00:00] [OHS] [INCIDENT_ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main] (13)Permission denied:  make_sock: could not bind to address xx.100.100.100:80



[2016-12-19T05:51:07.1888+00:00] [OHS] [INCIDENT_ERROR:20] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main]  no listening sockets available, shutting down



[2016-12-19T05:51:07.1888+00:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8256] [tid: 140065001035584] [user: mdvreddy] [VirtualHost: main]  Unable to open logs



[2016-12-19T05:51:09.0676+00:00] [OHS] [INCIDENT_ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main] (13)Permission denied:  make_sock: could not bind to address xx.100.100.100:80



[2016-12-19T05:51:09.0676+00:00] [OHS] [INCIDENT_ERROR:20] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main]  no listening sockets available, shutting down



[2016-12-19T05:51:09.0676+00:00] [OHS] [ERROR:32] [OHS-9999] [core.c] [host_id: mdvreddy.markmotels.com] [host_addr: xx.100.100.100] [pid: 8263] [tid: 140187892651840] [user: mdvreddy] [VirtualHost: main]  Unable to open logs





cd  /u01//Oracle_WT1/ohs/bin 

Change permissions of .apachectl from

-rwxr-x---. 1 mdvrd mdvrd  12315 Feb  8  2013 .apachectl

[mdvrd@mdvreddy.markmotels.com bin]$

execute the following command to the required changes

su root 
chown root .apachectl

chmod 6750 .apachectl

su mdvreddy

to

-rwsr-s---.  1 root      mdvreddy  13278 Feb  8  2013 .apachectl

cd  /u01//Oracle_WT1/instance/instance1/bin
 ./opmnctl stopall

 ./opmnctl startall

 ./opmnctl status

 I see it is working..


 for other problems, there is a very good blog on similar issues
 https://sreejithsna.wordpress.com/2015/09/04/ohs-not-starting-after-giving-opmnctl-startall/

OGG-01091 Unable to open file MGR.rpt in AIX

OGG-01091 Unable to open file MGR.rpt in AIX - Oracle Golden gate Installation discrepancies between major operating systems

By default, manager get started when you select start manager check box during the installation process, however we see this is not the case in AIX operating system

In our case we see manager process did not come up started when installation is done successful

$ ./ggsci



Oracle GoldenGate Command Interpreter for Oracle

Version 12.1.2.1.1 .............

AIX .........., ...........

Operating system character set identified as ..............



Copyright (C) ............... All rights reserved.







GGSCI (hostname) 1> info all



Program     Status      Group       Lag at Chkpt  Time Since Chkpt



MANAGER     STOPPED





GGSCI (hostname) 2> start mgr

Manager started.



GGSCI (hostname) 3>

Source Context :

  SourceModule            : [ggstd.util.file]

  SourceID                : [/../../../../../../gglib/ggstd/fileutl.c]

  SourceFunction          : [ggOpenFile(const char *, const char *)]

  SourceLine              : [772]



201*-**-** 11:01:54  ERROR   OGG-01091  Unable to open file "/../../../../../../../dirrpt/MGR.rpt" (error 2, No such file or directory).



201*-**-** 11:01:54  ERROR   OGG-01668  PROCESS ABENDING.



GGSCI (hostname) 3>



GGSCI (hostname) 4> create subdirs



Creating subdirectories under current directory /../../../../../../



Parameter files                /../../../../../../: already exists

Report files                   /../../../../../../: created

Checkpoint files               /../../../../../../: created

Process status files           /../../../../../../: created

SQL script files               /../../../../../../: created

Database definitions files     /../../../../../../: created

Extract data files             /../../../../../../: created

Temporary files                /../../../../../../: created

Credential store files         /../../../../../../: created

Masterkey wallet files         /../../../../../../: created

Dump files                     /../../../../../../: created





GGSCI (hostname) 6> start mgr

Manager started.

all is well thereafter...

ORA-12518: TNS:listener could not hand off client connection

ORA-12518: TNS:listener could not hand off client connection



Listener stop, start .. it resolved the isseus.. if nothing helps ..try adding the below to listner. ora file.
DIRECT_HANDOFF_TTC_LISTENER=OFF

Listener stop, start .

connect to the db

alter system register;

sqlplus user/pwd@db

Ensure you have sufficent value is set for processes init parameter, change it to max lets say 1000 or 2000

Always ensure db is configured with right AMM  or properly configured SGA





Its been awhile posting a blog entry, I am back to blogging.. hopefully you all like my blogs and post your comments as always.

ORA-01031: insufficient privileges when connecting sys AS SYSDBA

ORA-01031: insufficient privileges
------------------------------------------------

We are able to connect db with sys as sysdba but not with sqlplus sys/password@dba as sysdba



This issue usually come when we do rename databases or creation of data guard databases where we do add STATIC listner entry and forgot copying the correct password file from primary to standby database ...etc. few times i have come across....

The solution for this is simply simple.. create a new password file when we renamed the database/sid/dbname

the command syntax is :

 
 cd $ORACLE_HOME/dbs
orapwd file=orapw password=password entries=10

in case of standby database:

on standby db:

cd $ORACLE_HOME/dbs

scp  orapwPRIMARYDB username@standbydbhostname:oraclehomedirectorypath/dbs/orapwSTANDBY


Verification:
---------------------

 export ORACLE_SID=SID
sqlplus sys/password@sid as sysdba

it should work now..

 

ORA-01031: insufficient privileges when connecting sys AS SYSDBA

ORA-01031: insufficient privileges
------------------------------------------------

We are able to connect db with sys as sysdba but not with sqlplus sys/password@dba as sysdba



This issue usually come when we do rename databases or creation of data guard databases where we do add STATIC listner entry and forgot copying the correct password file from primary to standby database ...etc. few times i have come across....

The solution for this is simply simple.. create a new password file when we renamed the database/sid/dbname

the command syntax is :

cd $ORACLE_HOME/dbs

orapwd file=orapw password=password entries=10

in case of standby database:

on standby db:

cd $ORACLE_HOME/dbs

scp  orapwPRIMARYDB username@standbydbhostname:oraclehomedirectorypath/dbs/orapwSTANDBY


Verification:
---------------------

export ORACLE_SID=SID

sqlplus sys/password@sid as sysdba

it should work now..

ORA-28365: wallet is not open

ORA-28365: wallet is not open:


One should be careful in securing the key and i think data can not be viewed unless we have the right key and wallet is open with right key.

Please do check with oracle online documentation all the time... its good.

SQL> select * from tde_test;
select * from tde_test
              *
ERROR at line 1:
ORA-28365: wallet is not open


SQL> conn sys as sysdba
Enter password:
Connected.
SQL> desc dba_wallets;
ERROR:
ORA-04043: object dba_wallets does not exist


SQL> desc dba_wallet_acls;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 WALLET_PATH                               NOT NULL VARCHAR2(1000)
 ACL                                                VARCHAR2(4000)
 ACLID                                     NOT NULL RAW(16)

SQL> select * from dba_wallet_Acls;

no rows selected

SQL>
SQL> desc v$encryption_Wallet;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 WRL_TYPE                                           VARCHAR2(20)
 WRL_PARAMETER                                      VARCHAR2(4000)
 STATUS                                             VARCHAR2(18)

SQL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------

STATUS
------------------
file
F:\app\HOME\admin\orcl\encryption_wallet/
CLOSED


SQL> desc v$wallet;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 CERT_ID                                            VARCHAR2(52)
 DN                                                 VARCHAR2(255)
 SERIAL_NUM                                         VARCHAR2(40)
 ISSUER                                             VARCHAR2(255)
 KEYSIZE                                            NUMBER
 STATUS                                             VARCHAR2(16)

SQL> select * from v$wallet;

no rows selected



SQL> alter system set wallet open identified by "wrongpassword";
alter system set wallet open identified by "1myPassword"
*
ERROR at line 1:
ORA-28353: failed to open wallet


SQL> alter system set wallet open identified by "correctpassword";

System altered.

SQL> conn test/test;
SQL> select * from tde_test;

        ID DATA
---------- --------------------------------------------------
         1 It is a secret and can not be shown unless wallet is open!

SQL>
SQL>

Please note: wallet should be open each time the db is restarted.
One can close the wallet with alter command : ALTER SYSTEM SET WALLET CLOSE;

DBA personal should remember the key or should keep the key safe...

-- Have a fun working in oracle technologies.. Cheers....

ORA-28365: wallet is not open

ORA-28365: wallet is not open:


One should be careful in securing the key and i think data can not be viewed unless we have the right key and wallet is open with right key.

Please do check with oracle online documentation all the time... its good.


SQL> select * from tde_test;
select * from tde_test
*
ERROR at line 1:
ORA-28365: wallet is not open


SQL> conn sys as sysdba
Enter password:
Connected.
SQL> desc dba_wallets;
ERROR:
ORA-04043: object dba_wallets does not exist


SQL> desc dba_wallet_acls;
Name Null? Type
----------------------------------------- -------- ----------------------------

WALLET_PATH NOT NULL VARCHAR2(1000)
ACL VARCHAR2(4000)
ACLID NOT NULL RAW(16)

SQL> select * from dba_wallet_Acls;

no rows selected

SQL>
SQL> desc v$encryption_Wallet;
Name Null? Type
----------------------------------------- -------- ----------------------------

WRL_TYPE VARCHAR2(20)
WRL_PARAMETER VARCHAR2(4000)
STATUS VARCHAR2(18)

SQL> select * from v$encryption_wallet;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------

STATUS
------------------
file
F:\app\HOME\admin\orcl\encryption_wallet/
CLOSED


SQL> desc v$wallet;
Name Null? Type
----------------------------------------- -------- ----------------------------

CERT_ID VARCHAR2(52)
DN VARCHAR2(255)
SERIAL_NUM VARCHAR2(40)
ISSUER VARCHAR2(255)
KEYSIZE NUMBER
STATUS VARCHAR2(16)

SQL> select * from v$wallet;

no rows selected



SQL> alter system set wallet open identified by "wrongpassword";
alter system set wallet open identified by "1myPassword"
*
ERROR at line 1:
ORA-28353: failed to open wallet


SQL> alter system set wallet open identified by "correctpassword";

System altered.

SQL> conn test/test;
SQL> select * from tde_test;

ID DATA
---------- --------------------------------------------------
1 It is a secret and can not be shown unless wallet is open!

SQL>
SQL>


Please note: wallet should be open each time the db is restarted.
One can close the wallet with alter command : ALTER SYSTEM SET WALLET CLOSE;

DBA personal should remember the key or should keep the key safe...

-- Have a fun working in oracle technologies.. Cheers....

How to solve ORA-12560: TNS:protocol adapter error

How to solve ORA-12560: TNS:protocol adapter error::

Please note that the following steps THAT I ONLY tested in oracle 11g test database and windows environment and it does not mean that they work as exactly as shown here.. it all depends on what OS one use and what database one use and other validations.. please use your own judgement before you do anything on the database..you only responsible for your actions but no one else...

1. Ensure listener is started
2. All oracle variables configured correctly

In Windows OS:
---------------

 C:\Users\Home>set ORACLE_HOME=F:\app\Home2\product\11.2.0\dbhome_1

C:\Users\Home>SET ORACLE_SID=RED

C:\Users\Home>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 3 23:32:18 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\Home>oradim -start -sid RED

C:\Users\Home>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 00:08:27 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  640286720 bytes
Fixed Size                  1376492 bytes
Variable Size             213913364 bytes
Database Buffers          419430400 bytes
Redo Buffers                5566464 bytes
Database mounted.
Database opened.

SQL> conn sys@red as sysdba
Enter password:
Connected.
SQL>

...
What may be done in UNIX OS:
-----------------------------

please check whether login made with oracle user
please check all the oracle configuration variables are set like ORACLE_SID, ORACLE_HOME, ORACLE_BASE and all...
Ensure listener is up and running (not necessary although if you are not going to append @db name in connect string but just to be sure..

I earlier got this error in UniX boxs but did not copy the output, but i believe these steps may help.. i will post real time output when i see this error in linux... next time..

-- Have a fun in working in oracle technologies .. Cheers...

How to solve ORA-12560: TNS:protocol adapter error

How to solve ORA-12560: TNS:protocol adapter error::

Please note that the following steps THAT I ONLY tested in oracle 11g test database and windows environment and it does not mean that they work as exactly as shown here.. it all depends on what OS one use and what database one use and other validations.. please use your own judgement before you do anything on the database..you only responsible for your actions but no one else...

1. Ensure listener is started
2. All oracle variables configured correctly

In Windows OS:
---------------

 C:\Users\Home>set ORACLE_HOME=F:\app\Home2\product\11.2.0\dbhome_1

C:\Users\Home>SET ORACLE_SID=RED

C:\Users\Home>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 3 23:32:18 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\Home>oradim -start -sid RED

C:\Users\Home>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 00:08:27 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  640286720 bytes
Fixed Size                  1376492 bytes
Variable Size             213913364 bytes
Database Buffers          419430400 bytes
Redo Buffers                5566464 bytes
Database mounted.
Database opened.

SQL> conn sys@red as sysdba
Enter password:
Connected.
SQL>
 

...
What may be done in UNIX OS:
-----------------------------

please check whether login made with oracle user
please check all the oracle configuration variables are set like ORACLE_SID, ORACLE_HOME, ORACLE_BASE and all...
Ensure listener is up and running (not necessary although if you are not going to append @db name in connect string but just to be sure..

I earlier got this error in UniX boxs but did not copy the output, but i believe these steps may help.. i will post real time output when i see this error in linux... next time..

-- Have a fun in working in oracle technologies .. Cheers...

ORA-29855 error in oracle and solution

We sometime see the error when insufficient privileges are assigned and CTXSYS is not presented in oracle db 10g.

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

This errors comes when lack of privileges/roles when we work with text components (formerly known as Context, or Intermedia Text), this concept provides a powerful search, retrieval, and viewing capabilities for text stored in oracle database.

The solution is as follows:
AS sys DBA:
GRANT EXECUTE ON CTX_DDL TO username ; -- for oracle text package execution i.e. index rebuild and synchronize etc. Ignore if CTX_DDL not going to be used.
grant CTXAPP to username ;

Solution:
-----------
Ensure that CTXSYS schema is installed on database instance.

Install:
@? points oracle home directory i.e. ORACLE_HOME variable, ensure ORACLE_HOME and ORACLE_SID is set (window) or with export in UNIX.
The steps to be executed as SYS user
create tablespace drsys as sysdba
run @?/ctx/admin/catctx.sql ctxsys drsys temp01 nolock
run @?/ctx/admin/defaults/drdefus.sql (as CTXSYS user )-- see below for why and how
grant execute on ctxsys.ctx_ddl to user;

Uninstall:
@?/ctx/admin/catnoctx.sql as sys

The next step is to install appropriate language-specific default preferences. There is script which creates language-specific default preferences for every language Oracle text supports in ORACLE_HOME/ctx/admin/defaults directory and script should be executed as CTXSYS user.
@?/ctx/admin/defaults/drdefXX.sql -where XX is the language code


- wish this helps you too..