• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • PowerServer2022 Web app configuration at Database throwing ORA-12514 error

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved PowerServer2022 Web app configuration at Database throwing ORA-12514 error

  1. Issue
0
Votes
Undo
  1. chakrapani salumuri
    chakrapani salumuri
  2. PowerServer
  3. Wednesday, 9 November 2022 07:05 AM UTC

Hi,

We are Evaluating PB2022 for Procuring Licenses. 

Installed and migrated our application to 2022. (Train

Trying to make Power Server App. 

Our Database is Oracle. (Down loaded the drivers when asked and installed)

We are facing the issue after configuring the Database and encountering the following error

ora-12514: TNS: Listener does not currently know of service requested in connection descriptor (image attached)

Attachments (1)
ota-12514.PNG ota-12514.PNG
  1. Oracle
  2. PowerServer Web
ORA-00904: "TABLE_NAME": invalid identifier
Best method for updating a Powerserver application
Accepted Answer
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 November 2022 14:04 PM UTC
  2. PowerServer
  3. # Permalink
Hi Chakrapani, Please notice that Oracle 12c, 18c, 19c, or 21c are supported in PowerServer 2022. Refer to: https://docs.appeon.com/ps2022/Database_Server.html Regards, Logan
Comment
There are no comments made yet.
Responses (5)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 November 2022 10:44 AM UTC
  2. PowerServer
  3. # 1

Hi Chakrapani,

Currently, the PowerServer project configuration only supports connecting with the Oracle database via Service Name. Is it possible that you are using a TNS name by mistake?

Regards, Logan

Comment
There are no comments made yet.
chakrapani salumuri
chakrapani salumuri Accepted Answer Pending Moderation
  1. Wednesday, 9 November 2022 10:52 AM UTC
  2. PowerServer
  3. # 2

Hi Logan

Greetings

Thankyou for the reply.

TNS entry is as follows,

SPTSUAT =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.10.1.166)
(PORT = 1522)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = SPTSUAT)
)
)

 

is the "Service Name" in the screen (Database Configuration) related to the TNS names entry ?

We don't think so !!

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 9 November 2022 11:15 AM UTC
i don't know why there's not SERVICE_NAME value in your tnsnames, but try with SPTSUAT

You can try the connecting using:

10.10.1.166.SPTSUAT

or

10.10.1.166@SPTSUAT

but I'm not sure if it'll work.

  1. Helpful 1
There are no comments made yet.
chakrapani salumuri
chakrapani salumuri Accepted Answer Pending Moderation
  1. Wednesday, 9 November 2022 11:26 AM UTC
  2. PowerServer
  3. # 3

Hi Logan

My DB version is Oracle 10g

where as i tried to connect Oracle 12c DB its CONNECTING 

is there any other pre-requisites for 10g DB Connection

Please Help

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 9 November 2022 11:47 AM UTC
Hi,

Not sure if I remember well, but you have to have at least 11.x.x.x version of Oracle client. (not all 11.X are working well). Then there was also some bug with a certain 12.c.x.x.x version.

I'd recommend to use a 19c client, even if your server is not a 19c database.

regards and hope it helps.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 9 November 2022 11:49 AM UTC
Then, I forgot to add. Using 19c client won't work for any version of your DB server version. Which version is the database on the server?

  1. Helpful
There are no comments made yet.
chakrapani salumuri
chakrapani salumuri Accepted Answer Pending Moderation
  1. Wednesday, 9 November 2022 11:58 AM UTC
  2. PowerServer
  3. # 4

It's 10g

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 9 November 2022 13:11 PM UTC
10g not supported. You didn’t read the system requirements? https://docs.appeon.com/ps2022/Installation_requirements.html
  1. Helpful 1
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.