iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Oracle Tips/Questions and Answers:

 

More Resources by Google:

 

Question: I want to change my port from 7777 to 80, how can I do that. For example: when a user type "http://servername:7777, he or she be able to only type "http://servername."

How can I do that.

 

If you want to use a port that is less than 1024 on UNIX then you should run it as the root. The following instruction descript for you how to make a changes so you can start your opmn as root. # opmnctl startall

 

By default, Oracle HTTP Server runs as a non-root user (the user that installed Oracle Application Server). On UNIX systems, if you change the Oracle Application Server non-SSL listen port number to a value less than 1024, you must enable Oracle Application Server to run as root, as follows: 

Step #01: 

Log in as root. 
Run the following commands in the middle-tier Oracle home: 
cd ORACLE_HOME/Apache/Apache/bin
chown root .apachectl
chmod 6750 .apachectl

Step #02: 
Update the Application Server Control Console with the new port number: 
Edit the following file: 
(UNIX) ORACLE_HOME/Apache/Apache/httpd.conf
Save and close the file. 

Stop and start opmn:

# opmnctl stopall

# opmnctl startall


Question: I added more than 200 users to to a group in the portal and now I am getting the following message. How can I change the parameter so I don't get this message.

'Number Of Results Exceeded The Search Return Limit DAS'.

What you need to do is to change the orcldassearchsizelimit attribute via DAS.

Do change the orcldassearchsizelimit attribute, execute the following steps:

1. In http://host.domain:<sso_port>/oiddas, login and click the Configuration tab; check the Search Return Limit. 
2. Change this to a higher number than total number of users, and then click the icon under Submit, Refresh Page.
3. Going back to the DAS screen from Portal, after clicking Go, all the users will appear when searching with '%'.

 

Question: My OID Superuser (orcladmin) password was locked. How can I unlock the orcladmin password?

The following error I am getting when I connect or logon to OID as cn=orcladmin (the superuser).

Password Policy Error:9001: cn=orcladmin: Your account is locked

Please contact the Administrator

Error: Your password has expired. Please contact administrator to reset it.

 

The reason you get this error, because the default Password Maximum Failure is set to 10 and the default Password Expiry Time is set to 60 days. After 10 attempts fail or 60 days with no password change the cn=orcladmin account will be locked.

 

To unlock the orcladmin account, you should use the oidpasswd utility in $ORACLE_HOME/bin.

 

The format is:

# oidpasswd connect=<OID connect string> unlock_su_acct=true

 

For example:

# oidpasswd connect=orcl unlock_su_acct=true

OID DB user password:

After entering the password, you should get the following message:

OID super user account unlocked successfully.

 

Question: How can I add multiple users to OID?

 

Create a file and enter all the users with the following format:

dn: cn=testuser1,cn=users,dc=iselfschooling,dc=com

cn: testuser1

sn: surname1 SURNAME

objectclass: top

objectclass: person

objectclass: inetorgperson

objectclass: orcluser

objectclass: orcluserv2

givenname: testuser1 GIVENNAME

uid: testuser1

userpassword: password1

mail: testuser1@saa.senate.gov

 

dn: cn=testuser2,cn=users,dc=iselfschooling,dc=com

cn: testuser2

sn: surname2 SURNAME

objectclass: top

objectclass: person

objectclass: inetorgperson

objectclass: orcluser

objectclass: orcluserv2

givenname: testuser2 GIVENNAME

uid: testuser2

userpassword: password2

mail: testuser2@saa.senate.gov

Call it "myusers.ldif"

 

Run the Oracle ldapadd utility to add your users from the myusers.ldif file to OID with the following command:
ldapadd -p 389 -h yourservername -D "cn=orcladmin" -w <password> -f myusers.ldif

 

Google
 
Web web site