Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arabic numbers are not displaying properly in Report Builder 11.2

User_AWHMXOct 27 2021

Hai Everyone,
I have a query related to Arabic numbers. Actually i'm using report builder 11g which its having Arabic text and numbers. Arabic text is working fine and if add the below parameters in reports.sh file Arabic numbers also displaying proper but full report its showing Arabic numbers.
REPORTS_ARABIC_NUMERAL=HINDI
REPORTS_BIDI_ALGORITHM=UNICODE
Actually i want to display a specific field only in Arabic numbers and i don't want to display all the fields in Arabic. Without adding the above parameters and without disturbing the other fields is it possible to display the specific field in Arabic numbers.

Comments

EdStevens

How was it your installation/creation of the database did not prompt you for initial password for SYS and SYSTEM?
At an OS prompt, do the following (example using c:> prompt for windows)

C:\> set ORACLE_SID=<the name of your database>
C:\> sqlplus / as sysdba

# above command starts sqlplus cli and uses os authentication to connect you to the database as SYS, with SYSDBA authority. You can now ALTER USER .... to change any passwords you want. But you really shouldn't be connecting as SYS unless you absolutely need that level of unrestricted access. And even then, you should be connecting locally as shown above. For most DBA work, you should create another user (I use 'xxxxdba', where xxxx is the acronym for my organization) and 'GRANT DBA TO xxxxdba'.
Why were you installing 12c? It's already aged and on its way out the door. You should be looking at 19c, at the oldest.

User_X6ZQK

Thanks for the prompt reply EdStevens
No, it did not ask any SYS password. But it ask the Administrative password.
I need 12c because of other software dependency.
I have run the below command :

 sqlplus / as sysdba

Now I want to create the two new admin users with admin rights.
NOTE : I have not created any database yet.
is this right way : ?

create user c##user1  identified 1234;

How can I grant the user1 admin right ? and how can i check the is this admin user or not ?
After creation of admin user, i want to login in SQL Developer.

EdStevens

Now you say
NOTE : I have not created any database yet

But earlier you said
During the installation I have unlock just one user and gives the password.
How were you able to unlock a user and give a password if you have not created a database? Of course you cannot 'unlock a user" if you "have not created a database". So which is it?
NOte that while installting oracle and creating a database are two separate things, by default the installer will also create a database, if you make that selection.
No, it did not ask any SYS password. But it ask the Administrative password.
That is the password for SYS. The default "administrative" user is SYS.
One other thing, is this a non-multitenant database, or is it a Container database (CDB) with a Pluggable Database (PDB)? That will make a difference in how users are handled.

User_X6ZQK

Thanks for the reply EdStevens
Yes got your point here. during installation I have choose "Create and Configure Database" option.
I have change the "SYS" user password by using below command :

alter user SYS identified by 1234;

I have tried to connect with "SYS" user in SQL Developer . but message appeared invalid password.
It is Container database (CDB) with a Pluggable Database (PDB) database because I have select the below option :
pdb.JPGNow I want to create a user with admin right and want to login with this user in SQL developer.

I am able to connect in SQL developer with "System" user.

EdStevens

So what are the connection properties you defined in SQL Dev? Did you define it as BASIC or TNS? What are the values you supplied for the other fields? Are you wanting to connect to the CDB or the PDB?

User_X6ZQK

Thanks for the reply @edstevens1
I pick the Basic option from connection type.

EdStevens

Thanks for the reply @edstevens1
I pick the Basic option from connection type.
This is like pulling teeth. I also asked "What are the values you supplied for the other fields? Are you wanting to connect to the CDB or the PDB?"

EdStevens

Well, you just revived a thread that is dormant for over three months. Let me ask you this .... you said to "Create a new user with an _administrator_ password" (emphasis mine). So, what exactly is an "administrator" password? At the time you create a user and assign it a password, how would you distinguish an "administrator" password from any other password?

1 - 8

Post Details

Added on Oct 27 2021
8 comments
1,660 views